PDA

View Full Version : SQL Learning Recommendations



mark
March 25th, 2007, 02:29 PM
My job is almost exclusively dealing with Microsoft SQL Server (in their various iterations), writing ad hoc queries and I'm looking for recommendations for learning-related sites. They don't have to be MS oriented, but it would probably help.

Anybody got any favorites?

Thanks!

koenn
March 25th, 2007, 05:04 PM
If I remember correctly, MS SQL Server setup cd's include the "Books Online" - very extensive help / documentation, I'd think everything you need to know is in there.
On the other hand, SQL is a really simple language (25 words ?) so if all you have to do is make queries you just need to learn SQL, and get lots of practise.
The language is easy but queries can be very complicated, so experience pays off.

beginners sql tut : http://www.w3schools.com/sql/default.asp
advanced sql tut : http://www.1keydata.com/sql/sql.htm

ms sql server 2005 books online :
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx