Data / Cohort
Warehouse Patterns for Modern SQL
Star schemas, late-arriving facts, and incremental loads framed for cloud warehouses.
Tuition (informational)
₫9,400,000
Confirm with admissions; see Money-Back Policy for windows.
Logistics
Lead mentor
Thien Do
Warehouse engineer who migrated on-prem SQL Server stacks to cloud analytics platforms.
Overview
Advanced practitioners compare Kimball-inspired models with newer lakehouse patterns. Labs emphasize idempotent loads and contract testing between ingestion and serving layers.
What is included
- Star schema lab with conformed dimensions
- Late-arriving fact drill with backfill strategy
- Idempotent load checklist
- Contract testing between staging and mart layers
- Cost guardrail worksheet for large scans
- Mentor review of your production anonymized schema (optional)
- Documentation standards for Vietnamese + English stakeholders
Outcomes you can show
- Publish a dimensional model diagram with load order notes.
- Demonstrate a backfill plan with explicit cutover risks.
- Present cost guardrails for a heavy aggregate job.
Experience notes
“Late-arriving facts lab mirrored our customs data—Thien’s backfill memo template is now team standard.”
“Cost guardrail worksheet convinced finance to approve clustered columns; course stayed technical, not salesy.”
FAQ
Specific warehouse vendor?
Labs use Snowflake-compatible SQL dialect samples; translate to BigQuery or Redshift with TA support.
Spark content?
Mentioned comparatively; SQL remains the graded artifact.
Limitations?
We do not provide enterprise support contracts for your warehouse vendor.