Table of Contents

Contents at a Glance
Introduction

CHAPTER 1 Background to T-SQL querying and programming 

CHAPTER 2 Single-table queries 

CHAPTER 3 Joins

CHAPTER 4 Subqueries

CHAPTER 5 Table expressions

CHAPTER 6 Set operators

CHAPTER 7 Beyond the fundamentals of querying

CHAPTER 8 Data modification

CHAPTER 9 Temporal tables

CHAPTER 10 Transactions and concurrency

CHAPTER 11 Programmable objects

Appendix: Getting started

Index

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/.