SQL Foundations for Data Roles

Write readable queries, model small relational datasets, and explain execution plans without guesswork.

SQL Foundations for Data Roles

Tuition (informational)

₫4,900,000

Confirm with admissions; see Money-Back Policy for windows.

Logistics

  • Duration — 6 weeks
  • Schedule — Evenings
  • Skill level — Beginner
  • Certification — Certificate of completion
  • Languages — EN primary, VN study notes
Lan Phan

Lead mentor

Lan Phan

Former analytics lead for a regional logistics platform; focuses on legible SQL and mentor feedback loops.

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

  1. Ship a normalized schema brief with integrity constraints spelled out.
  2. Produce a query pack that mixes CTEs, filters, and defensive NULL handling.
  3. 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.”
Minh — Operations analyst · survey · 5/5
“Week four explain-plan lab was dense; still, I now catch sequential scans before they hit production dashboards.”
Hoa — Regional retailer

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.

Request information Back to catalog