01Data Modelling & SQL
12 hoursThe warehouse fundamentals the tools sit on
- Advanced T-SQL & window functions
- Dimensional modelling: star & snowflake
- Slowly changing dimensions
- Normalisation vs denormalisation
- Partitioning & distribution strategy
- Data quality & constraint design
