first it started with tables and how to make er diagram.

then it differentiated between OLTP and OLAP.

then it differentiated between traditional databases , datawarehouses , datalakes.

then the core of the toturial which is datawarehouse design and dimensional modelling , dimension keys ,dimension types , fact types , star and snowflake schema.

normal forms.

table partitioning.