Back to courses

SQL Window Functions

data intermediate

SQL Window Functions

Master SQL window functions from basics to advanced analytics - ROW_NUMBER, RANK, LAG, LEAD, and window frames

6 lessons

~6 hours

⭐ 1200 XP total

Your Progress 0/6 lessons

What you'll learn

SQL Data Analysis Analytics PostgreSQL

Course Content

Introduction to Window Functions

Ranking Functions

Aggregate Window Functions

Value Functions: LAG, LEAD, FIRST_VALUE

Window Frames: ROWS and RANGE

Window Functions Assessment