Description
Book SynopsisItzik 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/.
Table of ContentsCHAPTER 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: T-SQL for data analysis
CHAPTER 8: Data modification
CHAPTER 9: Temporal tables
CHAPTER 10: Transactions and concurrency
CHAPTER 11: SQL Graph
CHAPTER 12: Programmable objects
Appendix: Getting started
