Planning BI Infrastructure

SQL Server 2014    |    Expert
  • 7 Videos | 51m 10s
  • Earns a Badge
Likes 72 Likes 72
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
    FREE ACCESS
  • Locked
    4. 
    Creating Indexes and Assessing their Performance
    7m 58s
    FREE ACCESS
  • Locked
    5. 
    Planning Data Compression
    4m 58s
    FREE ACCESS
  • Locked
    6. 
    Implementing Data Compression
    7m 44s
    FREE ACCESS
  • Locked
    7. 
    Planning Views
    5m 59s
    FREE ACCESS

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

COURSE Data Warehouse Essential: Architecture Frameworks & Implementation
Likes 166 Likes 166  
COURSE Data Engineering on Microsoft Azure: Storage Accounts
Likes 1 Likes 1  
AUDIOBOOK Designing Cloud Data Platforms

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Designing BI Data Models
Likes 72 Likes 72  
COURSE Implementing BI Infrastructure
Likes 44 Likes 44  
COURSE Data Warehousing & Business Intelligence Deployment
Likes 87 Likes 87