Designing a Fact Table

SQL Server 2014
  • 9 Videos | 1h 6m 59s
  • Includes Assessment
  • Earns a Badge
Likes 12 Likes 12
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

  • Playable
    1. 
    Data Warehousing
    6m 34s
    UP NEXT
  • Playable
    2. 
    Indexing a Fact Table
    6m 20s
  • Locked
    3. 
    Columnstore Indexes
    10m 50s
  • Locked
    4. 
    Partitioning
    9m 59s
  • Locked
    5. 
    Additive and Non-Additive Measures
    4m 42s
  • Locked
    6. 
    Implementing a Fact Table
    6m 47s
  • Locked
    7. 
    Fact Table Loading Methods
    4m 29s
  • Locked
    8. 
    Summary Aggregation Tables
    5m 39s
  • Locked
    9. 
    Exercise: Implement a Data Warehouse Database
    7m 38s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 5 Likes 5  
Likes 15 Likes 15  
Likes 9 Likes 9  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 26 Likes 26  
Likes 15 Likes 15