Skip to main content
dbSyntax
Home CoursePracticeReferenceModelingInterview Prep
Start
  • Data Modeling
Foundations
  • OLTP vs OLAP and Grain
  • Medallion Architecture (Bronze / Silver / Gold)
  • Date and Time Modeling
  • Data Quality for Models
Dimensional Modeling
  • Star Schema Basics
  • Fact Table Patterns
  • SCD Type 1, 2, and 3
  • Bridge Tables and Many-to-Many Modeling
Data Vault
  • Data Vault Basics
Serving Layer
  • Serving Layer Patterns
  • Metric Layer Design
  • Incremental and Backfill Strategy
Tradeoffs
  • Star vs Data Vault vs 3NF
  • End-to-End Datamart Case Study
Capstone
  • Modeling Capstone Track
  • Capstone Bronze: Grain and Star Modeling
  • Capstone Silver: Quality and Serving Layer
  • Capstone Gold: Architecture and Migration
Home / Modeling / Capstone

Capstone

Learn SQL capstone with practical examples and guided drills on dbSyntax.

Start with Modeling Capstone Track

Modeling Capstone Track

This capstone track validates production-level modeling skills. Structure: Bronze: grain + star-model query correctness Silver: quality cont...

Capstone Bronze: Grain and Star Modeling

Objective: Design and validate a monthly insurance performance mart at product-line grain. Deliverables: 1. State explicit fact grain. 2. Bu...

Capstone Silver: Quality and Serving Layer

Objective: Build a serving-layer KPI query and define quality controls suitable for production. Deliverables: 1. Produce monthly claims rati...

Capstone Gold: Architecture and Migration

Objective: Design a migration from a legacy mixed-grain model to a governed serving architecture. Deliverables: 1. Recommend architecture (s...

dbSyntax Write and Run SQL in Your Browser
CoursePracticeReferenceModelingInterview PrepPrivacyTerms
© 2026 dbSyntax.