Introduction to SQL Server Window Functions

Learn SQL Server window functions for data analysis: basics, syntax, examples, and applications like running totals, moving averages, and rankings. Essential for developers enhancing data analysis skills.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Description

In this course, you will learn about SQL Server window functions and how they can be used to analyze data. You will learn the basics of window functions, including syntax and examples. Additionally, you will see how to use window functions to calculate running totals, moving averages, and rankings. This is a must-watch series for developers who want to improve their data analysis skills and learn about the powerful capabilities of SQL Server window functions.

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

Module 00 - What you need to get started

Module 01A - Introduction to SQL Server Window Functions 7 min.

Module 01B - Window Functions (Introduction) 17 min.

Module 02A - Window Aggregates (Introduction) 25 min.

Module 02B - Window Aggregates (Running Totals) 17 min.

Module 03A - Window Ranking Functions (Row_number) 33 min.

Module 03B - Window Ranking Functions (Rank and Dense Rank) 13 min.

Module 03C - Window Ranking Functions (Identifying Duplicates) 16 min.

Module 04A - Window Analytical Functions (Lag and Lead) 21 min.

Module 04B - Window Analytical Functions (Use Cases) 20 min.

Module 04C - Window Analytical Functions (Working with Blanks) 16 min.

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Mitchell Pearson

Data Engineer (Azure) Trainer

Mitchell Pearson has been with Pragmatic Works for 11 years as a Data Platform Consultant, Trainer and Team Lead. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform, Microsoft Azure and Fabric.

Learn More

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course includes:

3+ hours hours of training
Access on mobile and browser
Certificate of Completion