Planning BI Infrastructure
SQL Server 2014
| Expert
- 7 Videos | 51m 10s
- Earns a Badge
To get the most out of your data, it is important that the data warehouse is properly designed. Learn about planning the physical design of the data warehouse, including file storage, table partitioning, and indexes.
WHAT YOU WILL LEARN
-
describe causes of data warehouse I/O activity and the considerations for placement of database filesdescribe table partitioning, including benefits, and create a partitioned tabledescribe the considerations for using indexes and the types of indexescreate indexes and assess their performance
-
describe data compression and its benefitsimplement compressiondescribe the guidelines for planning views and create views based on them
IN THIS COURSE
-
1.Planning Database File Storage7m 12sUP NEXT
-
2.Planning Table Partitioning10m 24s
-
3.Planning Indexes for Queries6m 55s
-
4.Creating Indexes and Assessing their Performance7m 58s
-
5.Planning Data Compression4m 58s
-
6.Implementing Data Compression7m 44s
-
7.Planning Views5m 59s
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.