• Online, Self-Paced
Course Description

Each data warehouse consists of at least one fact table, which contains fundamental measurements of the business. This course covers the implementation of fact tables using partitions, data compression, and columnstore indexes.

Learning Objectives

Fact Tables in SQL Server 2014

  • start the course
  • describe data warehousing and its many relationships
  • appropriately index a fact table
  • describe columnstore indexes
  • demonstrate partitioning
  • recognize when to use additive and nonadditive measures
  • implement a fact table
  • determine the loading method for fact tables
  • design summary aggregation tables

Practice: Data Warehouse Database

  • implement a data warehouse database in SQL Server 2014

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.