Designing a Fact Table

SQL Server 2014    |    Intermediate
  • 9 videos | 1h 2m 59s
  • Includes Assessment
  • Earns a Badge
Rating 4.3 of 18 users Rating 4.3 of 18 users (18)
Each data warehouse consists of at least one fact table, which contains fundamental measurements of the business. Explore the implementation of fact tables using partitions, data compression, and columnstore indexes.

WHAT YOU WILL LEARN

  • Describe data warehousing and its many relationships
    Appropriately index a fact table
    Describe columnstore indexes
    Demonstrate partitioning
    Recognize when to use additive and non-additive measures
  • Implement a fact table
    Determine the loading method for fact tables
    Design summary aggregation tables
    Implement a data warehouse database in sql server 2014

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.7 of 117 users Rating 4.7 of 117 users (117)
Channel Big Data
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 364 users Rating 4.5 of 364 users (364)
Rating 4.1 of 38 users Rating 4.1 of 38 users (38)