My database skills suck.

[Woosta]

I know elementary SQL, but I'm willing to learn more. I started off with MySQL but I've heard PgSQL is better.. not that it matters for now -- but does anyone have some good resources or books I can read to get a better handle on databases? Normalization, etc?

 

[George P Burdell]

Try looking for a book that concentrates more on database theory than on any particular flavor of SQL. I recommend a college textbook like this one:
http://www.amazon.com/Fundamen...Elmasri/dp/0321369572/

College textbooks tend to be very boring (because of the high dosage of theory) but they cover fundamentals that industry books often skip over. You'll have a much better understanding of databases if you make effort and read that book.

Google around and check colleges that offer open courseware. I'm sure they'll have a database class with notes/videos somewhere.

 

[DanMart25]

You may like to try SQL-The Complete Reference by McGraw-Hill Osborne Media. Covers SQL quite comprehensively.

 

[SparksBox]

sql quick ref: http://www.w3schools.com/sql/default.asp

 

[Chrono]

w00t w00t dudes. I totally forgot about w3schools. I'm glad I know some basics at least. Got 20/20 in the quiz in 4 mins. Had me questioning my knowledge for a bit there. Any other good suggestions for learning SQL related material? Some good sites on learning about pl/sql for oracle db?

 

[Hyperblaze]

My best recommendation would be practice. Create a project that database intensive. Select data from multiple tables at once to gain information.