- United Arab Emirates
- Saudi Arabia
- Qatar
- Oman
- Kuwait
- Bahrain
- Pakistan
- Egypt
- Libya
- Afghanistan
- Sudan
- Cyprus
- Fiji
- Ethiopia
- Ghana
- Kenya
- Nigeria
- Mauritius
- South Africa
- Zambia
- Zimbabwe
- Mozambique
- Uganda
- Tanzania
- Angola
- And Growing up
Narrated ‘Ali bin Abi Talib (RA): The Prophet (RA) stood up for a funeral (to show respect) and thereafter he sat down. (Dawud)
This 5-day instructor led course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Module 1: Introduction to Data Warehousing
Describe data warehouse concepts and architecture considerations.
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
» Show More 👇
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 an Incremental ETL Process
This module describes how to implement an SSIS solution that supports incremental DW loads and changing data.
Lessons
Lab : Extracting Modified DataLab : Loading Incremental Changes
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 and Custom Components
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 Business Intelligence Tools
After completing this module, you will be able to:
» Show Less 👆
Audience Profile
The primary audience for this course are database professionals who need to fulfill 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.
Q: How is SSIS a data warehouse?
A: SSIS is designed for beginners and professionals with SQL Server Integration Service, a fast and easy data warehousing tool used for data extraction, transformation, and data loading. It makes it easy to load the data from one database to another database, such as SQL Server, Oracle, or Excel file, etc.
Q: Who is the target audience for the Implementing a SQL 2016 Data Warehouse (SSIS) course?
A: The target audience for the Implementing a SQL 2016 Data Warehouse (SSIS) course is database professionals, data warehousing professionals, BI developers, BI solutions professionals, software and ETdevdevelopers, and those with basic knowledge of SQL, seeking a career in business intelligence.
Q: How will this course help you achieve your goal?
A: This course will help you to achieve goals in certain ways, like understanding components of a data warehousing solution; implementing a logical and physical design to create a data warehouse; and most importantly, executing a physical design for a data warehouse.
Q: Does SQL Server work with a data warehouse?
A: Yes, SQL Server works with a data warehouse, but be careful of runaway costs. It can also be tough to tune your data warehouse performance and summarize the whole data from different database types in SQL Server.
Customized to your Team’s needs
Deliver at your Work Location
Connect Online from Anywhere