If you work with SQL Server in any capacity, as a developer,
DBA, BI specialist, data scientist, power user, you need to know your T-SQL.
The thing is, this language is deceptive. When you start learning it you
quickly get to write queries with filters, sorting, grouping, joining, and so
on. You might get a false sense of confidence and the wrong impression that the
language is easy to master. In reality, most get to learn T-SQL without
understanding the fundamentals, and this can lead to using the language
incorrectly. Often people assume things about the language that are not
guaranteed, and end up with bugs in their code.
This seminar is dedicated to correct understanding of T-SQL querying
fundamentals. You will learn about logical query processing—probably the most
critical aspect of T-SQL that any T-SQL practitioner should master. The seminar
also covers fundamentals of query constructs like joins, subqueries, table
expressions (derived tables, CTEs, views, table valued functions), the APPLY
operator, and set operators. The seminar also covers some of the newest additions
to T-SQL like STRING_SPLIT, STRING_AGG, DROP IF EXISTS, CREATE OR ALTER, and AT
TIME ZONE. If time will permit, the seminar will also cover the fundamentals of
more specialized query constructs like PIVOT, UNPIVOT, grouping sets and window
Know your T-SQL querying fundamentals well, and then
tackling advanced problems will be so much easier.