Data Science
Course
DEMO MODE
SQL for Analysts
From SELECT to window functions in six lessons
by Priya Raman5.0 about 3 hours
A hands-on path from basic queries to the window functions that power real reporting, with exercises on a fictional sales dataset.
What you'll learn
- Write joins and aggregations confidently
- Use window functions for running totals
- Read and improve slow queries
Free preview
The opening lesson has you query a fictional bookstore's sales table in the first five minutes.
Curriculum6 lessons
- Your first query25 minPreview
- Joins without fear30 min
- Aggregation and GROUP BY30 min
- Window functions35 min
- Video: reading a query planVideo placeholder — not hosted yet30 min
- The capstone report30 min
Learner reviews
Noah Tremblay5.0
Window functions finally clicked. The bookstore dataset makes every lesson concrete.