The Microsoft 20767B Implementing a SQL Data Warehouse Certification Course is part 1 of the series of two courses of MCSA 2016: SQL Business Intelligence Development, that validates your skills to create and deploy a data warehouse with Microsoft SQL Server 2016 and Azure SQL Data Warehouse for efficiently implementing the ETL as well as SQL Services.

This course qualifies you for the exam 70-767: Implementing a SQL Data Warehouse Certification.

20767B Implementing SQL data Warehouse Course Details-->> http://www.mercurysolutions.co/training/20767-implementing-sql-data-warehouse-certification-course?nairaland

Training Mode:

- Live Online

COURSE OUTLINE:

Module 1: Introduction to Data Warehousing
Module 2: Planning Data Warehouse Infrastructure
Module 3: Designing and Implementing a Data Warehouse
Module 4: Column store Indexes
Module 5: Implementing an Azure SQL Data Warehouse
Module 6: Creating an ETL Solution
Module 7: Implementing Control Flow in an SSIS Package
Module 8: Debugging and Troubleshooting SSIS Packages
Module 9: Implementing an Incremental ETL Process
Module 10: Enforcing Data Quality
Module 11: Using Master Data Services
Module 12: Extending SQL Server Integration Services (SSIS)
Module 13: Deploying and Configuring SSIS Packages
Module 14: Consuming Data in a Data Warehouse

PRE-REQUISITES:

At least 2 years’ experience of relevant experience with relational databases.

Why Mercury Solutions?

- Flexible Training Schedule
- Customized IT Training
- Official Courseware
- Group Training
- 1-on-1 Training
- Hands-on-Labs
- E-kit

For More Details, Contact At

P: +91 8882233777
E: training@mercury.co.in