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

Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Book Data & Analytics for Instructional Designers
Course Querying SQL Databases: Learning SQL Using Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Book CompTIA Security+ Certification Practice Exams, Fourth Edition (Exam SY0-601)
Course Data Warehouse Essential: Architecture Frameworks & Implementation
Rating 4.5 of 199 users Rating 4.5 of 199 users (199)
Book Business Leadership: Becoming Management Material Study Guide, Student Edition