Main MenuMain Menu
Course Code: IT 204
3914 Course Visits
Implementing SQL Data Warehouse
Course Sector:
Information Technology
Course Dates and Locations
Choose a date and location to book your seat
No.
Date
Days
Location
Fees
Enrollment
01
3 Days
Online, Virtual $1,550
02
3 Days
Riyadh, KSA $3,250
03
3 Days
Dubai, UAE $3,250
Introduction
Training course introducion / brief
In today's data-driven world, a well-structured data warehouse plays a pivotal role in transforming raw data into actionable insights. This training course is designed to equip you with the skills and knowledge required for the successful implementation of a robust data warehouse platform that serves as the backbone of a Business Intelligence (BI) solution. In this course, we will delve into the intricacies of building, managing, and optimizing data warehouses, empowering you to create a strong foundation for informed decision-making within your organization.
This course will guide you through a step-by-step journey that covers the core aspects of implementing a data warehouse platform. By the end of this course, you will have acquired the essential skills to create data warehouses using both Microsoft® SQL Server® 2016 and Azure SQL Data Warehouse, while seamlessly integrating ETL processes using SQL Server Integration Services (SSIS).
Course Objectives
At the end of the training course, participants will be able to
- Describe the key elements of a data warehousing solution
- Describe the main hardware considerations for building a data warehouse
- Implement a logical design for a data warehouse
- Implement a physical design for a data warehouse
- Create columnstore indexes
- Implementing an Azure SQL Data Warehouse
- Describe the key features of SSIS
- Implement a data flow by using SSIS
- Implement control flow by using tasks and precedence constraints
- Create dynamic packages that include variables and parameters
- Debug SSIS packages
- Describe the considerations for implement an ETL solution
- Implement Data Quality Services
- Implement a Master Data Services model
- Describe how you can use custom components to extend SSIS
- Deploy SSIS projects
- Describe BI and common BI scenarios
Course Audience
Who is this course for, and can benefit the most
- Cloud Computing Engineer
- Computer Network Specialist
- Computer Support Specialist
- Database Administrator
- Information Technology Analyst
- Information Technology Leadership
- Information Security Specialist
- Software/Application Developer
- Web Developer
- Technology sales consultant
Course Outline
The course aims and learning outcomes
Module 1: Introduction to Data Warehousing
- Overview of Data Warehousing
- Considerations for a Data Warehouse Solution
- Lab : Exploring a Data Warehouse Solution
- Considerations for Building a Data Warehouse
- Data Warehouse Reference Architectures and Appliances
- Lab: Planning Data Warehouse Infrastructure
- Logical Design for a Data Warehouse
- Physical Design for a Data Warehouse
- Lab : Implementing a Data Warehouse Schema
- Introduction to Columnstore Indexes
- Creating Columnstore Indexes
- Working with Columnstore Indexes
- Lab : Using Columnstore Indexes
- Advantages of Azure SQL Data Warehouse
- Implementing an Azure SQL Data Warehouse
- Developing an Azure SQL Data Warehouse
- Migrating to an Azure SQ Data Warehouse
- Lab : Implementing an Azure SQL Data Warehouse
Module 6: Creating an ETL Solution
- Introduction to ETL with SSIS
- Exploring Source Data
- Implementing Data Flow
- Lab : Implementing Data Flow in an SSIS Package
- Introduction to Control Flow
- Creating Dynamic Packages
- Using Containers
- Lab : Implementing Control Flow in an SSIS Package
- Lab : Using Transactions and Checkpoints
- Debugging an SSIS Package
- Logging SSIS Package Events
- Handling Errors in an SSIS Package
- Lab : Debugging and Troubleshooting an SSIS Package
- Introduction to Incremental ETL
- Extracting Modified Data
- Temporal Tables
- Lab : Extracting Modified Data
- Lab : Loading Incremental Changes
- Introduction to Data Quality
- Using Data Quality Services to Cleanse Data
- Using Data Quality Services to Match Data
- Lab : Cleansing Data
- Lab : De-duplicating Data
Module
11: Using Master Data Services
- Master Data Services Concepts
- Implementing a Master Data Services Model
- Managing Master Data
- Creating a Master Data Hub
- Lab : Implementing Master Data Services
- Using Custom Components in SSIS
- Using Scripting in SSIS
- Lab : Using Scripts and Custom Components
- Overview of SSIS Deployment
- Deploying SSIS Projects
- Planning SSIS Package Execution
- Lab : Deploying and Configuring SSIS Packages
- Introduction to Business Intelligence
- Introduction to Reporting
- An Introduction to Data Analysis
- Analyzing Data with Azure SQL Data Warehouse
- Lab : Using Business Intelligence Tools
Providers and Associations
Providing the best training services and benefits to our valued clients
Boost certificate of completion
BOOST's Professional Attendance Certificate “BPAC” is always given to the delegates after completing the training course, and depends on their attendance of the program at a rate of no less than 80%, besides their active participation and engagement during the program sessions.
ENDORSED EDUCATION PROVIDER
Flexible deadlines
Customized dates accordance to your schedule
Shareable Certificate
Earn certificate upon completion
COURSE METHODOLOGY
Our Training programs are implemented by combining the participants' academic knowledge and practical practice (30% theoretical / 70% practical activities).
At The end of the training program, Participants are involved in practical workshop to show their skills in applying what they were trained for. A detailed report is submitted to each participant and the training department in the organization on the results of the participant's performance and the return on training. Our programs focus on exercises, case studies, and individual and group presentations.
Since 2001, we have been pioneering the training field in the middle east, we managed to unlock potential and help individuals, teams and organisations to be the best that they can be with our full and integrated solutions.
Quick Links
Our sister companies in Egypt and United Arab Emirates
MOST TRENDING
And Recommended Training Courses
trending
Emotional Intelligence and Advanced Communication Skills for Leaders
Date: Aug 10, 2025
Location:Salalah, Oman
trending
ISO 55001 2014 Lead Auditor (Asset Management Systems) – Lead Auditor
Date: Aug 18, 2025
Location:Muscat, Oman
trending
Professional in Business Analysis (PMI-PBA Exam Preparation)
Date: May 18, 2025
Location:Jeddah, KSA
We believe in progress for everyone.
We helped more than 10.000 clients over 20 countries on 4 continents in boosting their knowledge, skills and careers.
Boost Training And Consulting © All Copyrights Reserved 2025