Implementing a SQL Data Warehouse (90 Day) (E-Learning)
$895.00
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)
If you have 3 or more students that need to be trained and don't see a course or location near you, call your Borderless Learning representative at 760-688-4045 to discuss getting another public session added to our schedule.
Choose | Year | Start | End | Location | GTR |
---|