Take your SQL skills beyond the basics with hands-on analysis of online shop data. Build readable queries with CTEs, uncover revenue trends with window functions, rank customers and products, and compare orders over time with LEAD and LAG to turn transaction data into actionable insights.
Overview
Syllabus
- Course 1: Structuring Queries with Common Table Expressions
- Course 2: Window Functions Fundamentals
- Course 3: SQL Ranking Functions: ROW_NUMBER, RANK, DENSE_RANK, and NTILE
- Course 4: Comparing Rows with LEAD and LAG