Maxtrain.com - [email protected] - 513-322-8888 - 866-595-6863
Implementing a SQL Data Warehouse is a 5-day instructor-led SQL training course that teaches you how to implement a data warehouse platform to support a BI solution. You will learn how to create a data warehouse with Microsoft® SQL Server® 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. You will get hands-on with the new information you will obtain with guided labs that reinforce your learning.
You can take this Implementing a SQL Data Warehouse Training either online or in our Cincinnati area office.
After completing this course, you will be able to:
This module describes data warehouse concepts and architecture consideration.
Lab : Exploring a Data Warehouse Solution
After completing this module, you will be able to:
.This module describes the main hardware considerations for building a data warehouse.
Lab : Planning Data Warehouse Infrastructure
This module describes how you go about designing and implementing a schema for a data warehouse.
Lab : Implementing a Data Warehouse Schema
This module introduces Columnstore Indexes.
Lab : Using Columnstore Indexes
This module describes Azure SQL Data Warehouses and how to implement them.
Lab : Implementing an Azure SQL Data Warehouse
At the end of this module you will be able to implement data flow in a SSIS package.
Lab : Implementing Data Flow in an SSIS Package
This module describes implementing control flow in an SSIS package.
Lab : Implementing Control Flow in an SSIS Package
Lab : Using Transactions and Checkpoints
This module describes how to debug and troubleshoot SSIS packages.
Lab : Debugging and Troubleshooting an SSIS Package
This module describes how to implement an SSIS solution that supports incremental DW loads and changing data.
Lab : Extracting Modified Data
Lab : Loading a data warehouse
This module describes how to implement data cleansing by using Microsoft Data Quality services.
Lab : Cleansing Data
Lab : De-duplicating Data
This module describes how to implement master data services to enforce data integrity at source.
Lab : Implementing Master Data Services
This module describes how to extend SSIS with custom scripts and components.
Lab : Using scripts
This module describes how to deploy and configure SSIS packages.
Lab : Deploying and Configuring SSIS Packages
Lab : Using a data warehouse
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
The primary audience for this course are database professionals who need to fulfill a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.
5 Days Course