Hello,
My new semester has started and I have a subject named DBMS (Database Management System). This is the first time I'm studying databases and so I'm not feeling very enthusiastic about databases (partly because I already had learnt C/C++ and I feel that programming is a lot easier that DBMS). Nevertheless, I must learn at least one DBMS as it is part of my college course. I'm confused and I want some suggestions:
Que-1: There are a lot of DBMSs out there (e.g. MySQL, Oracle, PostgreSQL). Although I don't exactly know the DBMS that will be part of my present semester, but it will be either SQL or Oracle. Which one is the best DBMS? Why do you prefer a particular DBMS?
Note: I don't love Microsoft and OS specific products. I will prefer using some free DBMS.
Que-2: I am an absolute idiot ;) when it comes to databases and DBMS. Which book will you prefer for the same?
Que-3: @MODS: Where should I post questions related to databases (and not some specific DBMS)?
Que-4: If you are asked to compare difficulty level of programming and learning a DBMS, which one would be lesser difficult (and logical)?
Thanks...
AmbrNewlearner
8 3027
I like 'Mimer' a lot; it has a very conforming SQL engine and runs on about everything that can say 'beep'. The bloody thing even runs on a phone. It has all sorts of interfaces (C/C++ Java etc). Give it a try.
Read "Relational DBMSes" by one of the inventors of all this relational algebra misery: Mr. Date.
kind regards,
Jos
ps. you can download a full developer version at http://www.mimer.com
Hello, @JosAH
Do you mean this book?
Thanks for your advice...
AmbrNewlearner
@ambrnewlearner
It has the word 'relational' in the title if I remember well (I'm not near my pile of books right now). I bet Google can help you here. There were (or are?) two volumes of the book; the second one dealt with the relational model.
kind regards,
Jos
edit: I googled a bit and I think this is a fine book to start with.
Atli 5,058
Expert 4TB
Hi.
I think your DBMS vs programming question isn't really valid. They are two very different things, which are usually meant to work in cooperation.
DBMSs are used to store data, and sure, you can do a certain amount of programming on them, but that is limited at best.
Programming languages are meant to process data, which usually comes either directly from the user, or from some sort of a database.
I would consider it a very very huge gap in a programmer's skill set if (s)he did not at least know the basics of using a database, because at some point, we are all likely to be using a database.
As to which DBMS you should choose.
I recommend trying MySQL. It's free and it's very well documented (you could even check out the source code if the documentation failed you ;P).
A perfect place to start, even if you choose to use another server down the road.
For the basic queries you are likely to use at first, it won't really matter. All the major SQL servers confirm to the standard, at least up to the point where the basic queries will work on them all.
When I first learned SQL, my teacher had us use M$ SQL Server 2003, but I was using Linux so I just used MySQL. The difference was so little that even tho I did everything on MySQL, I got a perfect score for all my projects when they were tested on SQL Server 2003.
Although, getting to know the differences between the data types would be a good idea ;)
I first learned MYSQL and PHP. After a while, I went into MS SQL and .Net. MYSQL and SQL are almost the same so I have no problem with that.
You don't need to read the whole book. I suggest read the basics. Start creating programs and apply it. Start with the basic processes like add, edit and delete in your programs. Then do complicated processes one step at a time. You'll notice that you are learning and at the same time enjoying since you are creating your own programs.
@ambrnewlearner
You should start learning first...It is interesting subject...quite logical if it comes to some concepts like concurrency management..
More precisely ACID properties...
If you feel any confidence over DBMS later, I suggest to start writing some UDF for mysql..
Regards,
Ash
NeoPa 32,556
Expert Mod 16PB @ambrnewlearner
That should be Misc Questions Ambr (not café). I'll move this one for you.
For future questions of this type (general DB), if you find that they don't get noticed, you can use the Help thread to attract some expert attention. Please use this sparingly, but as an expert yourself, there's no reason why you should not have the benefits of being a member of the team.
Hello,
My internet connection was down from last few days and so I could not reply back. But, now my connection is up and running again :)
Thank you all for your valuable responses. I now get a feel that databases are not a lot boring as I thought previously.
@NeoPa: Thanks for moving this thread to 'Misc. Questions'. And, I will (try to ;) remember that I need to post such questions to Misc forum.
@JosAh: I have ordered the book that you linked in your last reply. It will take a few days for it to be delivered at my doorstep. And so, till then I'm reading to Introduction to Database Systems by the same author (i.e. C. J. Date) that I found out in my university library. After going through first chapter of this book, I feel that databases are not as un-intuitive as I thought. There is no doubt that books written by C. J. Date are best at explaining the basic concepts.
Thanks to everyone once again...
AmbrNewlearner
Sign in to post your reply or Sign up for a free account.
Similar topics
by: I.V. Aprameya Rao |
last post by:
Hi
I have to implement a flat file dbms. The basic condition is that
relations will be given in files and i will have to run certain select
project join queries on those relations.
Can...
|
by: Az Tech |
last post by:
Hi people,
(Sorry for the somewhat long post).
I request some of the people on this group who have good experience
using object-orientation in the field, to please give some good ideas
for...
|
by: Steven O. |
last post by:
First, this may not be the correct newsgroup. I have some relatively
basic questions on SQL. I tried to find a newsgroup that was
specifically just about SQL, and was surprised to find that all...
|
by: Albretch |
last post by:
.. Can you define the Character Set for particular tables instead of
databases?
. Which DBMSs would let you do that?
. How do you store in a DBMS i18n'ed users' from input, coming over
the web...
|
by: Michael B. |
last post by:
I was just thinking about this, specifically wondering if there's any
features that the C specification currently lacks, and which may be
included in some future standardization.
Of course, I...
|
by: Jatinder |
last post by:
I 'm a professional looking for the job.In interview these questions
were asked with some others which I answered.But some of them left
unanswered.Plz help.
Here are some questions on C/C++, OS...
|
by: Steve |
last post by:
I have read a couple articles online, read my Jesse Liberty book but I am
still confused as to just what the best practices are for using exceptions.
I keep changing how I'm working with them and...
|
by: GeorgeRXZ |
last post by:
Hi Friends,
I have some questions related to C Language.
1What is the difference between the standard C language and Non
standard C language ?
2which is better C Lanugage, C under Linux/...
|
by: =?Utf-8?B?Ymxi?= |
last post by:
I am posting to the general discussion group - but I cannot find my
postings... or replies...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |