Answer by Jay Bonk ·
This would be a good site to start with:
as would this:
This would be a good choice for a book:
Also, take advantage of the online forums, post questions... here, also at the MSDN Forums.
Read the articles on SSC, try the question of the day.
Also, Jacob Sebastian runs the http://beyondrelational.com/ web site and just started the TSQL Challenges for Beginners, try and work through them. Follow-up and see the solutions that were picked as winners....
Answer by dave ballantyne ·
I would suggest you start with RDBMS theory first. The Manga guide to RDBMS is a good starting point Amazon Link. Once upto speed on that many of the concepts that you will encounter will make a lot more sense.
Answer by Steve Jones - Editor ·
I think that we have some good basic SQL articles on SQLServerCentral.
Basic joins: http://www.sqlservercentral.com/redirect/articles/65234/ Understanding NULL: http://www.sqlservercentral.com/articles/Basic+Querying/understandingthedifferencebetweenisnull/871/ Writing Simple Selects (3 part) - http://www.sqlservercentral.com/redirect/articles/2675/
SQLShare (www.sqlshare.com) has a lot of video content. I own part of that site, so I'll list it first, but MidnightDBA and Database Journal have videos as well.