Data · Online · 7 weeks
SQL for Analytics Engineers
₩1,120,000
Write efficient queries against star schemas, optimize execution plans, and document assumptions for analysts. Includes dbt-style modeling introduction.
Modules & labs
- Window functions and CTE patterns
- Query plan reading labs
- Incremental model strategies
- Data tests in warehouse projects
- Exposure layers for BI tools
- Mentor-reviewed modeling PRs
Outcomes
- Optimize a slow report query with measurable gains
- Model a mart layer with documented grain
- Present lineage for a business metric
Taeyang Kwon
Analytics engineer mentor on warehouse modeling.
FAQ
Labs use BigQuery-compatible SQL; syntax notes for Snowflake included.
Participant notes
Window function drills finally made retention cohorts readable for our PM.