1234567

Gain a solid understanding of T-SQL—and write better queries

Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you’ll quickly learn how to write effective code—whether you’re a programmer or database administrator.

Discover how to:

  • Work with programming practices unique to T-SQL
  • Create database tables and define data integrity
  • Query multiple tables using joins and subqueries
  • Simplify code and improve maintainability with table expressions
  • Implement insert, update, delete, and merge data modification strategies
  • Tackle advanced techniques such as window functions, pivoting and grouping sets
  • Control data consistency using isolation levels, and mitigate deadlocks and blocking
  • Take T-SQL to the next level with programmable objects

Itzik Ben-Gan

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2012 T-SQL Fundamentals and Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions. He has written many articles for SQL Server Pro as well as articles and whitepapers for MSDN. Itzik's speaking activities include TechEd, DevWeek, SQLPASS, SQL Server Magazine Connections, various user groups around the world, and SolidQ's events to name a few. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities. For more details please visit http://tsql.solidq.com.