LAG and LEAD: Advanced SQL: Window Functions | EdLight Code

Advanced SQL: Window FunctionsLAG and LEAD

6 / 9In progressIn progress

0/9

Advanced SQL: Window Functions

Course Progress0/9

1

Window Function Basics

What are Window Functions?
PARTITION BY Basics

2

Ranking Functions

ROW_NUMBER
RANK and DENSE_RANK

3

Running Totals and Row Comparison

Running Totals
LAG and LEAD

4

Advanced Window Techniques

FIRST_VALUE and LAST_VALUE
Percentiles and Distribution

5

Capstone Project

Capstone: Advanced Analytics Dashboard

Loading lesson…

Loading lesson…