The Agenda

This seminar covers advanced aspects of T-SQL querying and programming with a performance-centric focus. The seminar demonstrates practical uses of T-SQL features, with optimized and polished solutions, many of which were developed by the speaker. The seminar also covers the newest additions to T-SQL in SQL Server 2016 and 2017. The topics covered by the seminar include: the APPLY operator, window functions, (including batch-mode support), pivoting and unpivoting techniques, the OFFSET-FETCH filter, system-versioned temporal tables, string splitting and concatenation with the STRING_SPLIT and STRING_AGG functions, SQL Graph, and more.

Pre-requisites
1 year of experience writing T-SQL code and optimizing queries
Laptop Required:No