SQL · Intermediate

SQL for Analysis

CTEs, pivots and window functions on the shop, dates and period-over-period change on two years of store sales, then checking a messy payments export before trusting it.

2 h 17 min8 of 8 lessons live8 coding challenges

Curriculum

4 modules, 8 lessons, built to be done in order.

01AnalysisBuild in steps, check the grain, then window.3 lessons
02Over timeBucket dates, fill the gaps, compare periods fairly.3 lessons
03Checking the dataDuplicates, orphans and totals that don't add up.1 lessons
04Independent projectAnswer a real question end to end.1 lessons