Foundations
Learn SQL foundations with practical examples and guided drills on dbSyntax.
Start with OLTP vs OLAP and GrainOLTP vs OLAP and Grain
Use this page as a practical reference for choosing the right modeling shape between OLTP and OLAP systems, and for defining grain correctly...
Medallion Architecture (Bronze / Silver / Gold)
Use this page to understand how raw data is refined into trustworthy, business-ready models through the medallion architecture — the bronze/...
Date and Time Modeling
Use this page to model time correctly across facts, dimensions, and serving outputs. Goal: standardize date/time semantics avoid timezone an...
Data Quality for Models
Use this page to establish a production-quality test framework for modeled datasets. Goal: detect correctness defects before BI users do sta...