Table of Contents

Contents at a Glance
Introduction

CHAPTER 1 Background to T-SQL querying and programming CHAPTER 2 Single-table queries CHAPTER 3 JoinsCHAPTER 4 SubqueriesCHAPTER 5 Table expressionsCHAPTER 6 Set operatorsCHAPTER 7 Beyond the fundamentals of queryingCHAPTER 8 Data modificationCHAPTER 9 Temporal tablesCHAPTER 10 Transactions and concurrencyCHAPTER 11 Programmable objectsAppendix: Getting startedIndex

About the Author

TZIK BEN-GAN is a mentor with and co-founder of SolidQ. A Microsoft Data Platform MVP since 1999, Itzik has taught numerous training events around the world focused on T-SQL querying, query tuning, and programming. Itzik is the author of several books about T-SQL. He has written many articles for SQL Server Pro as well as articles and white papers for MSDN and The SolidQ Journal. Itzik's speaking engagements include Tech-Ed, SQL PASS, SQL Server Connections, presentations to various SQL Server user groups, and SolidQ events. Itzik is a subject-matter expert within SolidQ for its T-SQL related activities. He authored SolidQ's Advanced T-SQL and T-SQL Fundamentals courses and delivers them regularly worldwide. You can learn more about Itzik at http://tsql.solidq.com/.