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

Book Data Warehouse and Data Mining: Concepts, techniques and real life applications
Course Data Warehouse Essential: Concepts
Rating 4.4 of 292 users Rating 4.4 of 292 users (292)
Channel Project Management Essentials
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

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)
Course Power BI Bootcamp: Session 4 Replay (January, 2023)
Rating 4.7 of 79 users Rating 4.7 of 79 users (79)