Implementing a SQL Data Warehouse (M20767)
Learn to implement a data warehouse platform with Microsoft SQL Server 2016.
GK# 4398 Vendor# M20767
Learn to implement a data warehouse platform with Microsoft SQL Server 2016.
GK# 4398 Vendor# M20767
In this course, provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. 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.
Learn more about this topic. View the recorded webinar Overview of Microsoft SQL Server and High Availability Options
1. Introduction to Data Warehousing
2. Planning Data Warehouse Infrastructure
3. Designing and Implementing a Data Warehouse
4. Columnstore Indexes
5. Implementing an Azure SQL Data Warehouse
6. Creating an ETL Solution
7. Implementing Control Flow in an SSIS Package
8. Debugging and Troubleshooting SSIS Packages
9. Implementing a Data Extraction Solution
10. Enforcing Data Quality
11. Using Master Data Services
12. Extending SQL Server Integration Services (SSIS)
13. Deploying and Configuring SSIS Packages
14. Consuming Data in a Data Warehouse
Lab 1: Exploring a Data Warehouse Solution
Lab 2: Planning Data Warehouse Infrastructure
Lab 3: Implementing a Data Warehouse Schema
Lab 4: Using Columnstore Indexes
Lab 5: Implementing an Azure SQL Data Warehouse
Lab 6: Implementing Data Flow in an SSIS Package
Lab 7: Implementing Control Flow in an SSIS Package
Lab 8: Using Transactions and Checkpoints
Lab 9: Debugging and Troubleshooting an SSIS Package
Lab 10: Extracting Modified Data
Lab 11: Loading a data warehouse
Lab 12: Cleansing Data
Lab 13: De-duplicating Data
Lab 14: Implementing Master Data Services
Lab 15: Using Scripts
Lab 16: Deploying and Configuring SSIS Packages
Lab 17: Using a Data Warehouse
Redeeming your Microsoft Software Assurance Training Vouchers:
For more information on Microsoft SATVs, click here.
This course comes with 12 months access to the following benefits:
This course is available in the following formats:
Receive face-to-face instruction at one of our training center locations.
Experience live, expert-led online training from the convenience of your home, office or anywhere with an internet connection.