Implementing a SQL Data Warehouse (90 Day) (E-Learning)
$895.00
In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. This course incorporates material from the Official Microsoft Learning Product 20767: and it can assist you in your preparation for Exam 70-767: Implementing a SQL Data Warehouse.
Request a class below.
Course Overview
Course Duration: 5 days
In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. You will discover how to create a data warehouse, how to implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and how to validate and cleanse data with Data Quality Services (DQS) and Master Data Services. This course incorporates material from the Official Microsoft Learning Product 20767: and it can assist you in your preparation for Exam 70-767: Implementing a SQL Data Warehouse.
What You'll Learn
- Overview of data warehousing
- Considerations for building a data warehouse
- Design and implementation for a data warehouse
- Columnstore indexes - Azure SQL Data Warehouse
- ETL with SSIS
- Implement control flow in an SSIS package
- Debug and troubleshoot SSIS packages
- Incremental ETL and modified data extraction
- Microsoft DQS
- Master Data Services concepts and implementation
- Extend SSIS
- Deploy and configure SSIS packages
- BI tools with Azure SQL Data Warehouse
What You'll Get
90 day access.
Prerequisite
- Basic knowledge of the Microsoft Windows operating system and its core functionality
- Working knowledge of relational databases
- Some experience with database design
- Querying Data with Transact-SQL (M20761)
| Choose | Year | Start | End | Location | GTR |
|---|
This is an E-learning On-Demand course. You can access it at your own convenience, just click Add to Cart and follow the instructions.
Request A Class
You must create an account and log in before making a request.