Designing a Fact Table
SQL Server 2014 | Intermediate
- 9 videos | 1h 2m 59s
- Includes Assessment
- Earns a Badge
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 relationshipsappropriately index a fact tabledescribe columnstore indexesdemonstrate partitioningrecognize when to use additive and non-additive measures
implement a fact tabledetermine the loading method for fact tablesdesign summary aggregation tablesimplement 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
PEOPLE WHO VIEWED THIS ALSO VIEWED THESE
Course Data Transformation & Flow