Planning BI Infrastructure

SQL Server 2014    |    Expert
  • 7 videos | 51m 10s
  • Earns a Badge
Rating 4.6 of 44 users Rating 4.6 of 44 users (44)
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

Course Non-relational Data: Non-relational Databases
Rating 4.5 of 41 users Rating 4.5 of 41 users (41)
Course Big Data Concepts: Getting to Know Big Data
Rating 4.5 of 445 users Rating 4.5 of 445 users (445)
Course Data Warehouse Essential: Architecture Frameworks & Implementation
Rating 4.5 of 202 users Rating 4.5 of 202 users (202)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Power BI Bootcamp: Session 4 Replay (January, 2023)
Rating 4.7 of 79 users Rating 4.7 of 79 users (79)
Course Data Engineering on Microsoft Azure: Logical Data Structures
Rating 4.7 of 34 users Rating 4.7 of 34 users (34)
Course Smart Narratives, Q&A Visuals, & Copilot in Power BI
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)