Capstone
Learn SQL capstone with practical examples and guided drills on dbSyntax.
Start with Modeling Capstone TrackModeling 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...