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

Journey Learn Tableau for Data Visualization
Rating 3.5 of 2 users Rating 3.5 of 2 users (2)
Course Traditional Data Architectures: Data Warehousing and ETL Systems
Rating 4.5 of 364 users Rating 4.5 of 364 users (364)
Channel Big Data Core Concepts
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Developing a Mindset of Growth and Learning
Rating 4.7 of 3339 users Rating 4.7 of 3339 users (3339)
Book CompTIA Security+ Certification Practice Exams, Fourth Edition (Exam SY0-601)
Course Designing BI Infrastructure
Rating 4.5 of 86 users Rating 4.5 of 86 users (86)