01Data Modelling & SQL
12 hoursThe warehouse fundamentals the tools sit on
- Advanced SQL & window functions
- Dimensional modelling: star & snowflake
- Slowly changing dimensions
- Columnar formats: Parquet & ORC
- Partitioning & compression strategy
- Data quality & schema evolution
