SQL Server - Seeking best resources to learn and brush up sql query skills

Asked By abhi saber on 31-Jan-12 08:48 AM

Please refer online resources - eBooks with free download URLs to learn this.

Also need help to download and install northwind database on sql server 2008 - please note it is 2008 or 2005

Thanks

[)ia6l0 iii replied to abhi saber on 31-Jan-12 09:01 AM

This link gives you the NorthWind database.
http://www.microsoft.com/downloads/thankyou.aspx?familyId=06616212-0356-46a0-8da2-eebc53a68034&displayLang=en

Install from the MSI using the steps outlined in this online post.
http://hodentek.blogspot.com/2008/12/northwind-database-with-sql-server-2008.html

And here are the tutorials.
http://msdn.microsoft.com/en-us/library/ms167593(SQL.100).aspx

Venkat K replied to abhi saber on 31-Jan-12 09:36 AM

MSSQL:
http://www.google.com/search?hl=en&safe=off&q=introduction+to+ms+sql -> http://www.intermedia.net/support/SQL/sqltut.asp

SQLServercentral is also one of the site with best resources: http://www.sqlservercentral.com/

Thanks

Suchit shah replied to abhi saber on 31-Jan-12 12:20 PM

if you ask me my opinion if i want to brush up the sql query skill definitely i will go here :

http://blog.sqlauthority.com/ ( this is the best as from my point of view if you want to upgrade with new thing)
http://www.sql-tutorial.net/
http://www.w3schools.com/SQL/sql_intro.asp

Hope same thing also helps you