How to model a data warehouse with a star schema

Learn to model a data warehouse with a star schema: fact table, dimensions and surrogate keys, with SQL examples.