Microsoft SQL Server 2008 T-SQL Fundamentals

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

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

Itzik Ben-Gan is a principal mentor and a founder of Solid Quality Mentors. A Microsoft MVP for SQL Server since 1999, Itzik teaches and consults internationally on T-SQL querying, programming, and query tuning. He has written numerous articles for SQL SERVER MAGAZINE and MSDN®, and speaks at industry events such as Microsoft Tech Ed, DevWeek, PASS, and SQL Server Connections.