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

  • 7m 12s
    After completing this video, you will be able to describe the causes of data warehouse I/O activity and the considerations for placement of database files. FREE ACCESS
  • 10m 24s
    Upon completion of this video, you will be able to describe table partitioning, including benefits, and create a partitioned table. FREE ACCESS
  • Locked
    3.  Planning Indexes for Queries
    6m 55s
    Upon completion of this video, you will be able to describe the considerations for using indexes and the types of indexes. FREE ACCESS
  • Locked
    4.  Creating Indexes and Assessing their Performance
    7m 58s
    Find out how to create indexes and assess their performance. FREE ACCESS
  • Locked
    5.  Planning Data Compression
    4m 58s
    Upon completion of this video, you will be able to describe data compression and its benefits. FREE ACCESS
  • Locked
    6.  Implementing Data Compression
    7m 44s
    In this video, you will compress something. FREE ACCESS
  • Locked
    7.  Planning Views
    5m 59s
    Upon completion of this video, you will be able to describe the guidelines for planning views and create views based on those guidelines. 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 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

Channel SQL Database Development & Design
Likes 316 Likes 316  
Book Power BI Data Modeling: Build Interactive Visualizations, Learn DAX, Power Query, and Develop BI Models
Course Database Fundamentals: Getting Started with SQL

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Expert Insights on Career Planning
Likes 1887 Likes 1887  
Course Business Analysis Overview
Likes 1551 Likes 1551  
Course Implementing BI Infrastructure
Likes 44 Likes 44