Learning resources for T-SQL?

  • Can you provide websites/books/info to fully learn and master T-SQL.

    I sometimes struggle and waste time on semi simple T-SQL code and I'm at the point where I need to learn it from A-Z, including the best approach taken when tackling problems.

    Any info is much appreciated.

  • The main resource I used when learning T-SQL was "The SQL Server 2000 Bible". I'd use the 2008 version these days, or maybe 2005, but it's that series that was the most helpful to me.

    I know plenty of others who used some of the books by Microsoft Press. Check that out, there are definitely good ones there.

    There are also a number of discussions of this exact subject on this site. Try searching through the 2005 Newbies forum, you'll find a lot of good recommendations.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • I always suggest Itzik Ben-Gan's books, SQL Server 2008 T-SQL Fundamentals and/or Inside SQL Server 2005: T-SQL Programming.

    Hey GSquared, Paul Neilsen is supposed to finish the 2008 version of the Bible pretty soon according to the tweets he's been leaving on Twitter.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Cool. I haven't paid attention to what versions of the books are available recently.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 4 posts - 1 through 3 (of 3 total)

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