Planning BI Infrastructure

SQL Server 2014    |    Expert
  • 7 Videos | 51m 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
    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 Database Fundamentals: Getting Started with SQL
COURSE Designing a Fact Table
Likes 12 Likes 12  
COURSE Microsoft Azure Infrastructure Solutions: Blob Management

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Extract, Transform, & Load
Likes 103 Likes 103  
BOOK Business Intelligence with SQL Server Reporting Services
COURSE SOLID & GRASP
Likes 3218 Likes 3218