SQL
$2875
Per Participant
Note:This Course is retired.
55321: SQL Server Integration Services is the replacement course for 20767: Implementing a SQL Data Warehouse
20767: Implementing SQL Data Warehouse Training teaches professionals the leading methodologies to build a data warehouse with the help of MS SQL Server and Azure SQL Data Warehouse. This technical course demonstrates how to apply a data warehouse platform to support a BI solution. It provides comprehensive knowledge of the main hardware considerations for developing a data warehouse. Throughout this course, trainees will learn to implement a logical design and a physical design for a data warehouse. It also elaborates on the critical features of SSIS and teaches how to create dynamic packages, including parameters and variables. This training program is ideal for a data professional who works as a Business Intelligence Developer. This program covers all the essential topics from implementing control flow and debugging SSIS packages to applying to a master data services school.
This training is designed based on the objectives of the course variant 20767C.
The database professionals looking to upgrade to a BI developer role are the primary audience for the course. This course will teach them hands-on work to create Business Intelligence solutions that include implementing Data Warehouse, data cleansing and ETL.
Oops! For this course, there are currently no public schedules available. Clicking on "Notify Me" will allow you to express your interest.
For dates, times, and location customization of this course, get in touch with us.
You can also speak with a learning consultant by calling 800-961-0337.
For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.
This module describes data warehouse concepts and architecture consideration.
Lab: Exploring a Data Warehouse Solution
After completing this module, you will be able to:
This module describes the main hardware considerations for building a data warehouse.
Lab: Planning Data Warehouse Infrastructure
After completing this module, you will be able to:
This module describes how you go about designing and implementing a schema for a data warehouse.
Lab: Implementing a Data Warehouse Schema
After completing this module, you will be able to:
This module introduces Columnstore Indexes.
Lab: Using Columnstore Indexes
After completing this module, you will be able to:
This module describes Azure SQL Data Warehouses and how to implement them.
Lab: Implementing an Azure SQL Data Warehouse
After completing this module, you will be able to:
At the end of this module you will be able to implement data flow in a SSIS package.
Lab: Implementing Data Flow in an SSIS Package
After completing this module, you will be able to:
This module describes implementing control flow in an SSIS package.
Lab: Implementing Control Flow in an SSIS Package
Lab: Using Transactions and Checkpoints
After completing this module, you will be able to:
This module describes how to debug and troubleshoot SSIS packages.
Lab: Debugging and Troubleshooting an SSIS Package
After completing this module, you will be able to:
This module describes how to implement an SSIS solution that supports incremental DW loads and changing data.
Lab: Extracting Modified Data
Lab: Loading a data warehouse
After completing this module, you will be able to:
This module describes how to implement data cleansing by using Microsoft Data Quality services.
Lab: Cleansing Data
Lab: De-duplicating Data
After completing this module, you will be able to:
This module describes how to implement master data services to enforce data integrity at source.
Lab: Implementing Master Data Services
After completing this module, you will be able to:
This module describes how to extend SSIS with custom scripts and components.
Lab: Using scripts
After completing this module, you will be able to:
This module describes how to deploy and configure SSIS packages.
Lab: Deploying and Configuring SSIS Packages
After completing this module, you will be able to:
This module describes how to debug and troubleshoot SSIS packages.
Lab: Using a data warehouse
After completing this module, you will be able to:
Yes, it is. Then exam is 75% oriented to SQL Server 2016 on-premises. It is 25% oriented to Azure Big Data, Azure SQL Data Warehouse and other related topics.
It is similar to 70-463 exam; however, this exam now covers Integrate with Cloud data and big data chapter and some other updates.
Yes, it prepares you for MCSA: SQL 2016 BI Development and MCSE: Data Management and Analytics certifications.
The class room live lab course outline as described by Microsoft contains 17 exercises including - Exploring a Data Warehouse Solution, Planning Data Warehouse Infrastructure, Using Columnstore Indexes, Implementing a Data Warehouse Schema and Implementing an Azure SQL Data Warehouse etc.
I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.
Texas
I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.
Texas
I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.
MARTIN
TORONTO, CANADA