09/ 11·6 lessons·2 h 25 min

Analytics

Analytics right inside SQL: window functions (running total, ranking, top-N per group), lag/lead and frames (day-over-day, moving average), recursive CTEs (a category tree), LATERAL joins (top-3 per customer — the N+1 killer), and grouping sets/rollup/cube.

Start module→Continue · Window functions: the basics→Reread module→Next module →
/ lessons

Lessons

6 lessons · 2 h 25 min
  1. 01Window functions: the basics↳ continue from here#window-functions#partition-by#running-total25m
  2. 02Ranking and top-N per group↳ continue from here#window-functions#row-number#rank25m
  3. 03lag/lead and window frames↳ continue from here#window-functions#lag-lead#frames25m
  4. 04Recursive CTEs↳ continue from here#recursive-cte#tree#cycle25m
  5. 05LATERAL joins: top-N and the N+1 killer↳ continue from here#lateral#top-n#n-plus-125m
  6. 06GROUPING SETS, ROLLUP, and CUBE↳ continue from here#grouping-sets#rollup#cube20m