Design and Implement a Data Warehouse
The "Design and Implement a Data Warehouse" module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises: 1) Working with Dimensions, 2) Working with Fact Tables.
Already have an account? Sign In »

Introduction
The Design and Implement a Data Warehouse module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:
-
Working with Dimensions
-
Working with Fact Tables
Exercise 1 - Working with Dimensions
In this exercise, you will learn the following in Microsoft SQL Server 2012:
- Demonstrate the creation of Type 2 Slowly Changing Dimensions (SCD) with the appropriate surrogate key
- Demonstrate adding data lineage for a dimension table
Exercise 2 - Working with Fact Tables
In this exercise, you will learn the following in Microsoft SQL Server 2012:
- Demonstrate the creation of a fact table
- Partition a fact table
- Create a column store index on a fact table
- Demonstrate adding data lineage for a fact table
See the full benefits of our immersive learning experience with interactive courses and guided career paths.