INFO-H-419 : Exercises

Multidimensional databases

Dimensional Fact Model

From Operational to Multidimensional Databases

Relational OLAP

Bridge Tables and Changing Dimensions

Extraction Transformation Loading

Exercises
- SQL Server Integration Services: Creating a Project
Update Exercises
- SQL Server Integration Services: SCD Component
- Updates of the Northwind operational database (SQL Server)
Advanced Exercises
- External data for extending the Geography dimension

Indexing

View Materialization

Reporting

Exercises