Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

Optimizing a Data Warehouse on the Microsoft SQL Server Platform

via Pluralsight

Overview

Once a data warehouse is initially created, performance and maintainability come into question. In this course, you'll explore SQL Server and the tools and resources needed to efficiently optimize a data warehouse.

The resources offered by Microsoft SQL Server are geared towards architects, developers, and administrators in the database realm. In this course, Optimizing a Data Warehouse on the Microsoft SQL Server Platform, you'll delve into the tools and resources available in SQL Server for optimizing a data warehouse. First, you'll explore the options for indexing in a data warehouse. Next, you'll learn how to use Integration Services (SSIS) to import source data into your destination. Then, you'll discover what the database engine includes, such as, table partitioning, various indexes like clustered and columnstore, and bulk insert. Finally, you'll explore documentation options that includes data flows complementing a data dictionary. By the end of this course, you'll have the necessary knowledge needed to effectively optimize your data warehouse on the Microsoft SQL Server platform.

Topics:
  • Course Overview
  • Managing Data Warehouse with Best Practices
  • Partitioning Data Warehouse Fact Tables
  • Indexing Data Warehouse Tables
  • Extracting, Transforming, and Loading (ETL) a Data Warehouse
  • Cleansing Data in a Data Warehouse
  • Centralizing Data with Master Data Management Processes
  • Documenting a Data Warehouse

Taught by

Thomas LeBlanc

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Optimizing a Data Warehouse on the Microsoft SQL Server Platform

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free