What are some good database resources online ?

Question

Hi,

Can anyone point me to some really good online resources for understanding Database Concepts.

p.s.: My background is of Java Development.

Thanks.

Answer 1

I would recommend

1. Buy database in depth by C.J. Date
2. Read anything by Codd

Not online resources, but useful nonetheless

Answer 2

Date and Codd are the patron saints of relational databases, but I wouldn't recommend either as introductory reading.

Here are two on-line resources that I like:

1. The Database Programmer
2. The Database Column

And here's a nice poster describing the first three rules of normalization. You'll be light years ahead if you can understand just this.

Answer 3

I studied databases from these book : http://www.amazon.com/Database-Systems-Complete-Book-GOAL/dp/0130319953 . At the beginning there is a hardcore theory, complex but having read this you will understand database fundamentals.

Look here for online resource: http://media.wiley.com/product_data/excerpt/2X/04700465/047004652X.pdf

Try this for java oriented people: http://utenti.lycos.it/yanorel6/2/ch43.htm

HTH

Answer 4

http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

http://www.tek-tips.com/faqs.cfm?fid=4785

http://wiki.lessthandot.com/index.php/Category%3AData%5FManagement

http://www.sommarskog.se/dynamic%5Fsql.html