Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Cloud

Optimizing a Data Warehouse on the Microsoft SQL Server Platform

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.

Thomas LeBlanc - Pluralsight course - Optimizing a Data Warehouse on the Microsoft SQL Server Platform
by Thomas LeBlanc

What you'll learn

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.

Table of contents

About the author

Thomas LeBlanc - Pluralsight course - Optimizing a Data Warehouse on the Microsoft SQL Server Platform
Thomas LeBlanc

Microsoft Data Platform MVP specializing in SQL Server, Microsoft Business Intelligence (SSIS, SSAS & SSRS) and Power BI.

More Courses by Thomas