Tracks/SQL Track/Advanced SQL: Window Functions

Advanced

5 modules · ~12h

Advanced SQL: Window Functions

Master window functions for powerful analytics: ranking, running totals, and advanced calculations.

5 modules9 lessons26 exercises~12h

Window function basicsPARTITION BYRanking functionsRunning totalsLAG/LEAD analysis

Start course

Recommended prerequisites

SQL Subqueries & CTEs

Content

Course modules

5 modules

What are Window Functions?

Understand the concept and syntax of window functions.

2 exercises12m

PARTITION BY Basics

Learn to partition windows for grouped calculations.

3 exercises15m

Tracks/SQL Track/Advanced SQL: Window Functions

Advanced

5 modules · ~12h

Advanced SQL: Window Functions

Master window functions for powerful analytics: ranking, running totals, and advanced calculations.

5 modules9 lessons26 exercises~12h

Window function basicsPARTITION BYRanking functionsRunning totalsLAG/LEAD analysis

Start course

Recommended prerequisites

SQL Subqueries & CTEs

Content

Course modules

5 modules

What are Window Functions?

Understand the concept and syntax of window functions.

2 exercises12m

PARTITION BY Basics

Learn to partition windows for grouped calculations.

3 exercises15m

Advanced SQL: Window Functions

Recommended prerequisites

Course modules

Window Function Basics

What are Window Functions?

PARTITION BY Basics

Ranking Functions

Running Totals and Row Comparison

Advanced Window Techniques

Capstone Project

Advanced SQL: Window Functions

Recommended prerequisites

Course modules

Window Function Basics

What are Window Functions?

PARTITION BY Basics

Ranking Functions

Running Totals and Row Comparison

Advanced Window Techniques

Capstone Project