Good resources for learning T-SQL reasonably thoroughly?

  • pietlinden

    SSC Guru

    Points: 62456

    1. there's the Stairway series on here.
    2. Itzik's T-SQL Fundamentals and T-SQL Querying
    Anything else I should read? I'm thinking a good bit on how data gets retrieved (so indexing).
    I used Jonathan Kehayis's (I think) code to "explode" AdventureWorks, so if I write a really bad query, it takes forever to execute. (I know, it's a case of baselining, which I should definitely practice).

    I'm tempted to read some of the Querying book on certification only to be sure that I cover everything. (Yeah, I have some old certs, and I think they're not worth the paper they're printed on)..

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715842

    That's where I'd start. The stairway gets you moving. Itzik's book is great. From there you could look at the Hi Performance SQL Server book and the T-SQL Recipes books, but if you get through Itzik's book, you'll have a better idea of how things work and where you might want to focus your efforts at that time.

    We have some T-SQL Challenges here that let you practice as well.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply