T-SQL Querying: Advanced Techniques

Extend your T-SQL knowledge to write optimal queries

You learn to use advanced features of Transact-SQL. This will enable you to consider different solution strategies to solve business questions, leading to a more optimal solution.
- Refresher
- Table Expressions
- Set Operators
- Window Ranking, Offset and Aggregate Functions
- Pivot Tables and Grouping Sets
- Programming with T-SQL

In this module we will make sure everyone remembers the basics of querying and we can continue at the same level. Goals:
- Standard elements of a SELECT query
- Joins
- Grouping & Aggregating
- Subqueries

Table expressions are SQL elements that are not a table but can (mostly) be used as if they were in fact a table. Goals:
- Views
- Table Valued Functions
- Derived Tables
- Common Table Expressions (CTE)
- Apply
- When to pick which option?

Set Operators allow you to vertically combine and compare two similar result sets. This contrasts joins, where you are horizontally combining data. Goals:
- UNION (ALL)
- EXCEPT / INTERSECT

Window functions are ideal for many analytics scenarios like running totals and moving averages. They also allow you to 'time travel' to previous or following values in your result set. Goals:…