On the first Monday of every month, we offer
a 20% discount on selected IT courses!
Want to develop your IT skills and looking for an opportunity
to do so more cheaply? Check out our IT Week Deals!
ATTENTION! Training withdrawn from the offer.
To get updated information about Microsoft trainings, please contact our consultant: szkolenia@dagma.pl or 800 080 322.
This five-day instructor-led 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.
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:
Module 1: Introduction to Data Warehousing
This module describes data warehouse concepts and architecture consideration.
Lessons
Lab : Exploring a Data Warehouse Solution
After completing this module, you will be able to:
Module 2: Planning Data Warehouse Infrastructure
This module describes the main hardware considerations for building a data warehouse.
Lessons
Lab : Planning Data Warehouse Infrastructure
After completing this module, you will be able to:
Module 3: Designing and Implementing a Data Warehouse
This module describes how you go about designing and implementing a schema for a data warehouse.
Lessons
Lab : Implementing a Data Warehouse Schema
After completing this module, you will be able to:
Module 4: Columnstore Indexes
This module introduces Columnstore Indexes.
Lessons
Lab : Using Columnstore Indexes
After completing this module, you will be able to:
Module 5: Implementing an Azure SQL Data Warehouse
This module describes Azure SQL Data Warehouses and how to implement them.
Lessons
Lab : Implementing an Azure SQL Data Warehouse
After completing this module, you will be able to:
Module 6: Creating an ETL Solution
At the end of this module you will be able to implement data flow in a SSIS package.
Lessons
Lab : Implementing Data Flow in an SSIS Package
After completing this module, you will be able to:
Module 7: Implementing Control Flow in an SSIS Package
This module describes implementing control flow in an SSIS package.
Lessons
Lab : Implementing Control Flow in an SSIS Package
Lab : Using Transactions and Checkpoints
After completing this module, you will be able to:
Module 8: Debugging and Troubleshooting SSIS Packages
This module describes how to debug and troubleshoot SSIS packages.
Lessons
Lab : Debugging and Troubleshooting an SSIS Package
After completing this module, you will be able to:
Module 9: Implementing a Data Extraction Solution
This module describes how to implement an SSIS solution that supports incremental DW loads and changing data.
Lessons
Lab : Extracting Modified Data
Lab : Loading a data warehouse
After completing this module, you will be able to:
Module 10: Enforcing Data Quality
This module describes how to implement data cleansing by using Microsoft Data Quality services.
Lessons
Lab : Cleansing Data
Lab : De-duplicating Data
After completing this module, you will be able to:
Module 11: Using Master Data Services
This module describes how to implement master data services to enforce data integrity at source.
Lessons
Lab : Implementing Master Data Services
After completing this module, you will be able to:
Module 12: Extending SQL Server Integration Services (SSIS)
This module describes how to extend SSIS with custom scripts and components.
Lessons
Lab : Using scripts
After completing this module, you will be able to:
Module 13: Deploying and Configuring SSIS Packages
This module describes how to deploy and configure SSIS packages.
Lessons
Lab : Deploying and Configuring SSIS Packages
After completing this module, you will be able to:
Module 14: Consuming Data in a Data Warehouse
This module describes how to debug and troubleshoot SSIS packages.
Lessons
Lab : Using a data warehouse
After completing this module, you will be able to:
Call Us: +48 800 080 322
Do you have any questions?
Do you need more information?
Do you want to pre-book the place?
Call Us!
+48 32 259 11 80