Providing Technology Training and Mentoring For Modern Technology Adoption
This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
After completing this course, students will be able to:
The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
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
This module describes how you go about designing and implementing a schema for a data warehouse.
Lab : Implementing a Data Warehouse Schema
This module introduces Columnstore Indexes.
Lab : Using Columnstore Indexes
This module describes Azure SQL Data Warehouses and how to implement them.
Lab : Implementing an Azure SQL Data Warehouse
Describe the advantages of Azure SQL Data Warehouse
Implement an Azure SQL Data Warehouse
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
This module describes implementing control flow in an SSIS package.
Lab : Implementing Control Flow in an SSIS Package
Lab : Using Transactions and Checkpoints
This module describes how to debug and troubleshoot SSIS packages.
Lab : Debugging and Troubleshooting an SSIS Package
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
This module describes how to implement data cleansing by using Microsoft Data Quality services.
Lab : Cleansing Data
Lab : De-duplicating Data
This module describes how to implement master data services to enforce data integrity at source.
Lab : Implementing Master Data Services
This module describes how to extend SSIS with custom scripts and components.
Lab : Using scripts
This module describes how to deploy and configure SSIS packages.
Lab : Deploying and Configuring SSIS Packages
Lab : Using a data warehouse