Database, where to start?.

harry_houdini said:
Hi guys,
I wanted to learn about databases in detail. Not for some exam or as a necessity, just for knowledge.
Please tell me from where to start.

I would like to go as deep as I have interest in this subject. I hardly do only one thing at a time, but this would be one of the things.
Consider I do not know anything which I guess is right :bleh:.
Please tell me what all I need to know, understand, study. Does it directly mean picking up an SQL book or there is a prerequisite, I mean things I need to know before starting to study databases.

And which database to choose? There are so many out there, Oracle, MySql, MsAccess, etc.

Thanks
Click to expand...
Just start with Basic sql queries .
 
I have been working in Oracle Applications since 4 years. SO here is what i say.
Start with ANSI SQL first.
In fact you can start with a oracle DB itself.

Get yourself the free Oracle Database Express Edition installed on your PC to practice:
http://www.oracle.com/technetwork/products/express-edition/downloads/index.html

Get a good book like to learn sql and pl/sql :
http://www.flipkart.com/murach-s-oracle-sql-pl-sql-works-all-versions-through-11g-1st/p/itmdyusdnbb42uq8?pid=9788184045888&ref=e9eebc59-c825-4bf2-a8ad-3ad558d7117d&srno=s_2&otracker=from-search&query=Murachs Oracle SQL and PLSQL

Also what people forget while learning SQL is the basic Database Concepts and the performance tuning aspects, which is very important when you write an optimised sql. Unless you know this, you wont be able to write good sqls. Refer to the link below.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2689775200346342643

Visit sites like AskTom, to learn more.
 
Back
Top