SQL Window Functions

Unlock advanced analytics with OVER(), PARTITION BY, ROW_NUMBER, RANK, LAG, LEAD, and running totals.

~10h total

6 lessons

~4h content

Pro Access

✦ Includes mini project

⭐ Certificate of completion

No setup required · 100% browser-based

What You'll Learn

Write window functions with OVER() and PARTITION BY

Rank rows with ROW_NUMBER, RANK, DENSE_RANK

Calculate running totals and moving averages

Compare rows across time with LAG and LEAD

6 lessons · ~220 minutes

Intro to Window Functions

25 min

Concept

OVER() and PARTITION BY

35 min

Code-Along

ROW_NUMBER, RANK, DENSE_RANK

35 min

Code-Along

Running Totals & Moving Averages

35 min

Code-Along

LAG & LEAD for Time Comparisons

35 min

Code-Along

Project: Sales Trend Analysis

55 min

Project

PostgreSQLBrowser SQL Editor

Continue Your Journey

Use SQL to build reports, answer business questions, and generate decision-ready insights.