Career Starter Tracks
SQL Foundations for Analysts
Readable queries, joins that behave, and checkpoints so dashboards stay trustworthy.
Overview
You translate vague requests into explicit joins and reusable snippets. Sessions alternate between guided labs and short critiques so you see how small schema decisions alter executive-facing numbers. We include naming conventions for Korea-context reporting teams and a peer review rubric you can reuse at work.
What is included
- CTE patterns for month-on-month rollups without duplicate rows
- Index-aware query plans explained with before/after timings
- Data quality checks embedded at the source, not the dashboard
- Partner exercises with realistic CRM and inventory samples
- Exportable style guide for table and column naming
- Office hour blocks for stuck joins and slow-running jobs
- Capstone brief graded by working practitioners, not TAs
Outcomes
- Ship a documented query pack your team can adopt without rework
- Explain join logic to stakeholders without hand-waving
- Catch duplication bugs before they reach weekly KPI emails
Lead mentor
Haneul Park
Former retail analytics lead; still ships Looker models for boutique brands.
Logistics
Difficulty: Foundation · Schedule: Evenings · Mentor cadence: Standard
Tools referenced: BigQuery, dbt, Sheets
Participant questions
Do I need a computer science background?
Comfort with spreadsheets helps. We start from SELECT and build deliberately; pure beginners should budget extra self-study hours.
What software is included?
We provide cloud warehouse credentials for class exercises only. Personal licenses for BI tools are not bundled.
Is job placement included?
No. We offer portfolio feedback and interview labs as separate sessions, not packaged placement guarantees.
Cohort notes
“The week-three join clinic saved my cohort dashboard—finally stopped double-counting renewals.”
“Naming rubric from SQL Foundations is now our team default for ad hoc pulls.”