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.
Course info
Level
Intermediate
Updated
Apr 1, 2020
Duration
3h 3m
Table of contents
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
Description
Course info
Level
Intermediate
Updated
Apr 1, 2020
Duration
3h 3m
Description

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.

About the author
About the author

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

More from the author
Building Your First SSIS Package
Beginner
1h 55m
Jun 26, 2020
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is Thomas Oblong and welcome to my course, optimizing a data warehouse on the sequel server platform. I'm a product manager at idea. I worked with the wear escape products for data warehouse automation tools. Working with data warehouses and sequel server tools has been ongoing with me for over 20 years. In this course, we're gonna look at the tools and resource is available in sequel server for optimizing a data warehouse. The tools are geared towards architect's developers and administrators in the database round the enterprise information management terminology was created for items like master data, data quality and extract. Transform and load Our e t l. This was all created for data warehouses. Some of the major topics that we're going to cover in this course include options for indexing in a data warehouse using integration Service's are S S, I s for importing of source data into a destination. Master data management with Master Data Service is cleansing data with data quality service is and documentation options, including a data diagram. By the end of this course, you will know how to cleanse data with S s. I s including a data quality service component. You will also use Excel toe Add data. You'll be able to diagram a database or data warehouse structure and show the source and target columns. You will also be able to enhance indexes on a data warehouse database before beginning this course. You should be familiar with these sequel server management studio sequel server data tools, creating indexes and tables, as well as data warehouse structure concepts. I hope you'll join me to learn more about data warehouse tools when we go through the course, optimizing a data warehouse on the Microsoft sequel server platform.