Window functions are so powerful that they serve as a dividing point in time: people talk about SQL Server before window functions and SQL Server after window functions. Because they were introduced into the standard relatively recently, these functions aren't covered in many T-SQL courses.
This course is intended for intermediate users. We assume the user knows the basics of T-SQL, including:
In this MS SQL Server course you will learn:
You'll discover how window functions in MS SQL Server can be used to:
You'll also get a deeper understanding of T-SQL aggregate functions.
Course progress
Exercises completed
1.
Window functions? We'll explain what they're all about
2.
Your first encounter with window functions
3.
Discover how to define a function window with PARTITION BY
4.
Learn how you can rank rows with window functions
5.
Learn how to create sophisticated window frames for your window functions
6.
Learn the most essential analytic functions
7.
Create advanced statistics computed independently for various groups of rows
8.
Do you know when window functions are evaluated in a T-SQL query? Let's find out!
9.
Master all the skills you've acquired so far with our practice set
10.
Test all the skills you've acquired so far with this comprehensive final quiz