Interactive Course
Learn how to use analytic T-SQL functions to deeply understand data.
Ultimate money saver
With our Forever plan this course will cost you only
$ 4.33
83% OFF
41 hours left
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:
You'll also get a deeper understanding of T-SQL aggregate functions.
Course progress
Exercises completed
Window functions? We'll explain what they're all about
Exercises completed
Your first encounter with window functions
Exercises completed
Discover how to define a function window with PARTITION BY
Exercises completed
Learn how you can rank rows with window functions
Exercises completed
Learn how to create sophisticated window frames for your window functions
Exercises completed
Learn the most essential analytic functions
Exercises completed
Create advanced statistics computed independently for various groups of rows
Exercises completed
Do you know when window functions are evaluated in a T-SQL query? Let's find out!
Exercises completed
Master all the skills you've acquired so far with our practice set
Exercises completed
Test all the skills you've acquired so far with this comprehensive final quiz
Exercises completed