Good resources for learning T-SQL reasonably thoroughly?

• pietlinden

  SSC Guru

  Points: 63552

  More actions

  September 4, 2018 at 7:30 pm

  #150821

  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: 737424

  More actions

  November 14, 2018 at 9:50 am

  #2013497

  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.