Design and Implement a Data Warehouse

Practice Labs Module
Time
40 minutes
Difficulty
Intermediate

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.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or
Sign up with Google
Sign up with Apple
Sign up with Microsoft
View all SSO options

Already have an account? Sign In »

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
Learning Partner
Practice Labs

IT & Cybersecurity certification hands on practice labs and practice exams for certifications and skill development.

Comprehensive Learning

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

Courses