Planning BI Infrastructure

SQL Server 2014
  • 7 Videos | 53m 10s
  • Earns a Badge
Likes 41 Likes 41
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 files
    describe table partitioning, including benefits, and create a partitioned table
    describe the considerations for using indexes and the types of indexes
    create indexes and assess their performance
  • describe data compression and its benefits
    implement compression
    describe the guidelines for planning views and create views based on them

IN THIS COURSE

  • Playable
    1. 
    Planning Database File Storage
    7m 12s
    UP NEXT
  • Playable
    2. 
    Planning Table Partitioning
    10m 24s
  • Locked
    3. 
    Planning Indexes for Queries
    6m 55s
  • Locked
    4. 
    Creating Indexes and Assessing their Performance
    7m 58s
  • Locked
    5. 
    Planning Data Compression
    4m 58s
  • Locked
    6. 
    Implementing Data Compression
    7m 44s
  • Locked
    7. 
    Planning Views
    5m 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.

YOU MIGHT ALSO LIKE

Likes 9 Likes 9  
Likes 13 Likes 13  
Likes 9 Likes 9  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 39 Likes 39  
Likes 78 Likes 78  
COURSE Data Analysis
Likes 101 Likes 101