SQL Basics · Live online + labs
SQL Foundations for Report Builders
Write SELECT, JOIN, and aggregate queries that replace manual Excel merges.
₩420,000 · informational
Duration: 4 weeks · 32 hours
Level: Beginner · Tool: PostgreSQL
Request information
Overview
Move from copy-paste reporting to repeatable SQL. You will query a practice warehouse modeled on retail operations data, build views for recurring reports, and document each query for handoff to teammates.
Included
- Practice warehouse with 12 normalized tables
- Weekly query review with written feedback
- JOIN and aggregation drills with timed sprints
- Template library for month-end close queries
- Version control basics for .sql files
- Office-hours access during cohort weeks
Outcomes
- Draft a 5-query pack for a recurring operational report
- Explain when to use INNER vs LEFT joins on real schemas
- Hand off documented SQL to a BI developer
Hana Yoo
Former ops analyst; 9 years teaching spreadsheet-to-SQL transitions.
FAQ
Learner notes
"The JOIN sprint on the returns table finally clicked. I rebuilt our weekly SKU report without VLOOKUP chains."
"Mentor notes were specific — line 14 of my query was the issue every time."