• Course
  • Vendor

Learn how to implement a data warehouse platform to support a business intelligence (BI) solution. Discover how to create a data warehouse, how to implement extract, transform, & load (ETL) with SQL Server Integration Services (SSIS)& how to validate...

  • Course Start Date: 2020-11-09
  • Time: 08:30:00 - 16:30:00
  • Duration: 5 days 08:30 AM - 04:30 PM
  • Location: Virtual
  • Delivery Method(s): Virtual Instructor Led
$2,396.00
REGULAR PRICE $2,995.00 Save $599.00
2 discount seats left!
or make an offer

Course Outline

Pre-Requisites

Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases. Some experience with database design Querying Data with Transact-SQL (M20761)

Lessons

In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. You will discover how to create a data warehouse, how to implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and how to validate and cleanse data with Data Quality Services (DQS) and Master Data Services.

This course uses Microsoft SQL Server 2016 and incorporates material from the Official Microsoft Learning Product 20767: Implementing a SQL Data Warehouse.

What You'll Learn
  • Overview of data warehousing
  • Considerations for building a data warehouse
  • Design and implementation for a data warehouse
  • Columnstore indexes
  • Azure SQL Data Warehouse
  • ETL with SSIS
  • Implement control flow in an SSIS package
  • Debug and troubleshoot SSIS packages
  • Incremental ETL and modified data extraction
  • Microsoft DQS
  • Master Data Services concepts and implementation
  • Extend SSIS
  • Deploy and configure SSIS packages
  • BI tools with Azure SQL Data Warehouse
Prerequisites
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Some experience with database design
  • Querying Data with Transact-SQL (M20761)
Who Needs To Attend
  • Database professionals who need to fulfill a BI developer role focused on hands-on work by creating BI solutions, including data warehouse implementation, ETL and data cleansing
  • Database professionals responsible for implementing a data warehouse, developing SSIS packages for data ETL, enforcing data integrity using Microsoft Data Services and cleansing data using Data Quality Services
Related Certifications
  • MCSA: SQL 2016 Business Intelligence Development
Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Retakes
  • Digital Courseware

Course Outline

1. Introduction to Data Warehousing

  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution

2. Planning Data Warehouse Infrastructure

  • Considerations for Building a Data Warehouse
  • Data Warehouse Reference Architectures and Appliances

3. Designing and Implementing a Data Warehouse

  • Logical Design for a Data Warehouse
  • Physical Design for a Data Warehouse

4. Columnstore Indexes

  • Introduction to Columnstore Indexes
  • Creating Columnstore Indexes
  • Working with Columnstore Indexes

5. Implementing an Azure SQL Data Warehouse

  • 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

6. Creating an ETL Solution

  • ETL with SSIS
  • Exploring Source Data
  • Implementing Data Flow

7. Implementing Control Flow in an SSIS Package

  • Introduction to Control Flow
  • Creating Dynamic Packages
  • Using Containers

8. Debugging and Troubleshooting SSIS Packages

  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package

9. Implementing an Incremental ETL Process

  • Introduction to Incremental ETL
  • Extracting Modified Data
  • Temporal Tables

10. Enforcing Data Quality

  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match Data

11. Using Master Data Services

  • Master Data Services Concepts
  • Implementing a Master Data Services Model
  • Managing Master Data
  • Creating a Master Data Hub

12. Extending SQL Server Integration Services (SSIS)

  • Using Custom Components in SSIS
  • Using Scripting in SSIS

13. Deploying and Configuring SSIS Packages

  • Overview of SSIS Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution

14. Consuming Data in a Data Warehouse

  • Business Intelligence
  • Reporting
  • Data Analysis
  • Analyzing Data with Azure SQL Data Warehouse
Labs

Lab 1: Exploring a Data Warehouse Solution
Lab 2: Planning Data Warehouse Infrastructure
Lab 3: Implementing a Data Warehouse Schema
Lab 4: Using Columnstore Indexes
Lab 5: Implementing an Azure SQL Data Warehouse
Lab 6: Implementing Data Flow in an SSIS Package
Lab 7: Implementing Control Flow in an SSIS Package
Lab 8: Using Transactions and Checkpoints
Lab 9: Debugging and Troubleshooting an SSIS Package
Lab 10: Extracting Modified Data
Lab 11: Loading Incremental Changes
Lab 12: Cleansing Data
Lab 13: De-duplicating Data
Lab 14: Implementing Master Data Services
Lab 15: Using Scripts and Custom Components
Lab 16: Deploying and Configuring SSIS Packages
Lab 17: Using Business Intelligence Tools


Cancellation Policy

We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted. Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.

Training Location

Online Classroom
your office

your city, your province
your country   

About Global Knowledge

x

Global Knowledge is the world's leading learning services and professional development solutions provider. We deliver learning solutions to support customers as they adapt to key business transformations and technological advancements that drive the way that organizations around the world differentiate themselves and thrive. Our learning programs, whether designed for a global organization or an individual professional, help businesses close skills gaps and foster an environment of continuous talent development.

Training Provider Rating

This vendor has an overall average rating of 4.38 out of 5 based on 430 reviews.

No comment
No comment
Instructor was great
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
No comment
Wasn’t as advanced as I thought it would be. There was an issue when the day my course was the first time they used a new platfo ... Read more
x

Wasn’t as advanced as I thought it would be. There was an issue when the day my course was the first time they used a new platform.. from adobe to something called zoom; I had to call support line cause it stated our instructor wasn’t present. Thankfully I called cause everyone online was in the adobe virtual classroom waiting for what looked like a teacher who didn’t show up for class (IT didn’t get anything resolved until 10mins after start time). I felt like he was really getting hung up on very basic knowledge for the first half of the course (talking about how to create tabs and drag formulas as an example). I completed files a few times before he was done explaining. There was a scheduled fire drill for them (roughly 30mins)that also cut into our time, which wasn’t deducted from the hour lunch break or the two, fifteen min breaks. I also really wish he touched base more on the automating workbook functions portion which we barely did. I'm happy there were/are those study guides (learning videos) and exams to take on my own time that I hope after I've had the class are still available for me to learn from.

No comment

Course Reviews

No Reviews Yet

More Courses from Global Knowledge

GLOBAL KNOWLEDGE
2020-11-23
Virtual
GLOBAL KNOWLEDGE
2021-01-25
Virtual

More Courses in 'Microsoft SQL Training' Category

GLOBAL KNOWLEDGE
2020-12-07
Virtual
GLOBAL KNOWLEDGE
2020-11-30
Virtual
GLOBAL KNOWLEDGE
2021-01-25
Virtual