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

Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Book Data & Analytics for Instructional Designers

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Microsoft Azure Fundamentals: Software Development Services
Rating 4.5 of 208 users Rating 4.5 of 208 users (208)
Book CompTIA Security+ Certification Practice Exams, Fourth Edition (Exam SY0-601)
Course Developing a Mindset of Growth and Learning
Rating 4.7 of 3339 users Rating 4.7 of 3339 users (3339)