SQL Basics · Live online
Advanced SQL for Analysts
Window functions, CTEs, and performance-aware queries for growing datasets.
₩720,000 · informational
Duration: 5 weeks · 40 hours
Level: Advanced · Tool: PostgreSQL
Request information
Overview
Go beyond basics with window functions, recursive CTEs, and explain plans. Optimize queries that power dashboards without waiting on engineering tickets.
Included
- Window function drill set (12 scenarios)
- CTE refactoring labs
- EXPLAIN workshop on sample warehouse
- Indexing primer for analysts
- Code review rubric
- Pair programming sessions
Outcomes
- Rewrite a slow report query with measurable improvement
- Use window functions for cohort and ranking reports
- Read an explain plan at a high level
Hana Yoo
Former ops analyst; 9 years teaching spreadsheet-to-SQL transitions.
FAQ
Learner notes
"CTE lab on sessionized events was tough but the explain plan clinic made indexes less mysterious."
"Still reference the window function cheat sheet from week 3."