Data / Cohort (evenings ICT)
SQL Foundations for Data Roles
Write readable queries, model small relational datasets, and explain execution plans without guesswork.
Overview
This course anchors Flux Blaze’s data track. You move from SELECT basics to joins, aggregates, and window functions using realistic Vietnamese retail and logistics scenarios. Weekly mentor reviews keep queries tidy and index-aware.
What is included
- PostgreSQL 16 lab environment with sample VN market data
- Explain plans and cardinality exercises each sprint
- Peer code review rubric aligned to hiring screen expectations
- Checkpoint quizzes with annotated answer keys
- Capstone dataset: normalized invoices plus slowly changing dimensions
- Office hours covering bilingual documentation habits
- Portfolio artifact: documented schema plus ten representative queries
Outcomes you can show
- Ship a normalized schema brief with integrity constraints spelled out.
- Produce a query pack that mixes CTEs, filters, and defensive NULL handling.
- Present a five-minute walkthrough of two explain plans you improved.
Experience notes
“The invoice capstone forced me to document keys the way Lan asks in mentor sessions—my WHERE clauses finally stopped drifting.”
“Week four explain-plan lab was dense; still, I now catch sequential scans before they hit production dashboards.”
FAQ
Do I need programming experience first?
Comfort with spreadsheets helps. We do not teach application programming here—only SQL and relational thinking.
What software is provided?
You receive a cloud PostgreSQL workspace; local install guides are optional reading, not required.
What is not included?
We do not cover proprietary warehouse appliances or vendor-specific certification exams. Those require separate budgets.