Microsoft® SQL Server® 2008 T-SQL Fundamentals

Front Cover
Microsoft Press, Nov 30, 2009 - Computers - 418 pages
7 Reviews

Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance—including exercises and code samples—that show you how to develop code to query and modify data. You’ll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries.

Discover how to:

Apply T-SQL fundamentals, create tables, and define data integrity Understand logical query processing Query multiple tables using joins and subqueries Simplify code and improve maintainability with table expressions Explore pivoting techniques and how to handle grouping sets Write code that modifies data Isolate inconsistent data and address deadlock and blocking scenarios

What people are saying - Write a review

User ratings

5 stars
4 stars
3 stars
2 stars
1 star

Review: Microsoft SQL Server 2012 T-SQL Fundamentals

User Review  - Anna Beatriz - Goodreads

Not so "fundamental". I believe this book goes a little beyond fundamentals. Itzik Ben-Gan explains everything in a very comprehensible way. Definitely recommended to beginners seeking a solid foundation in T-SQL and also to more experienced developers looking to enhance their skills. Read full review

Review: Microsoft SQL Server 2012 T-SQL Fundamentals

User Review  - Vera VB - Goodreads

Very comprehensible and thorough inside in T-SQL, not only for the novice but also for those experienced in T-SQL to keep up with new stuff in SQL Server 2012. Good understandable examples and nice ... Read full review

Other editions - View all

About the author (2009)

Itzik Ben-Gan is a mentor and cofounder of SolidQ. A Microsoft MVP for SQL Server since 1999, Ben-Gan teaches and consults internationally on T-SQL querying, programming, and query tuning. He is the author of Microsoft SQL Server T-SQL Fundamentals and coauthor of Inside Microsoft SQL Server: T-SQL Querying and Inside Microsoft SQL Server:T-SQL Programming. He has written numerous articles for SQL Server Magazine and MSDN, and speaks at industry events such as Microsoft TechEd, DevWeek, PASS, and SQL Server Connections.

Bibliographic information