Description
Data Warehouse with Microsoft SQL Server (SSIS) training course will show you how to implement a data warehouse platform to support a BI solution. The training course is designed for those who are interested in learning SQL Server 2012 or SQL Server 2014 and covers the new features in SQL Server 2014 but also the important capabilities across the SQL Server data platform.
Learning Objectives:
This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to:
- Create a data warehouse with Microsoft SQL Server 2012/2014/2016
- Implement ETL with SQL Server Integration Services
- Validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Program Outline
Introduction to Data Warehousing
Planning Data Warehouse Infrastructure
Designing and Implementing a Data Warehouse
Columnstore Indexes
Implementing an Azure SQL Data Warehouse
Creating an ETL Solution
Implementing Control Flow in an SSIS Package
Debugging and Troubleshooting SSIS Packages
Implementing a Data Extraction Solution
Enforcing Data Quality
Master Data Services
Extending SQL Server Integration Services
Deploying and Configuring SSIS Packages
Consuming Data in a Data Warehouse
Prerequisite
This course is intended for database professionals who need to create and support a data warehousing solution. Primary responsibilities include:
- Implementing a data warehouse.
- Developing SSIS packages for data extraction, transformation, and loading.
- Enforcing data integrity by using Master Data Services.
Cleansing data by using Data Quality Services

Reviews
There are no reviews yet.