<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Home / SQL Server / Introduction to SQL Server Window Functions

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.

Free Community Plan View Pricing Plans
Introduction to SQL Server Window Functions
  • Course Info
  • Instructor
  • What to know beforehand
  • System Requirements

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.

Course Outline ( Free Preview)

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 of training
  • 11 Modules
  • * Access on mobile and browser
  • Certificate of Completion
Free Community Plan View Pricing