Overview

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:

  1. Working with Dimensions
  2. 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

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.