DeepDive T-SQL – Analytic Functions (Grouping, Pivoting and Windowing and more)
Master these powerful functions!
Duration: 8 hours
What does this course cover?
Windowing functions are one of the most powerful and at the same under-utilized time features of the T-SQL language. Apparently the reason is that developers often are simply not aware of it. Using windowing functions developers can create powerful, simplified code with awesome results.
Pre-requisites: What do you need to know?
Experience with SQL Server Administration and Development
WHEN and WHERE is this course running?
Grouping, Pivoting and Windowing
- Window Functions
- Pivoting and Unpivoting Data
- Custom Aggregations
- Grouping Sets
TOP and OFFSET-FETCH
- Top N Per Groupfication
- Inserting Data
- Deleting Data
- Updating Data
- Merging Data
- The OUTPUT Clause