Course 20463: Implementing a Data Warehouse with Microsoft SQL Server

Course Description

Data warehousing is a solution organizations use to centralize business data for reporting and analysis. This five-day instructor-led course focuses on teaching individuals how to create a data warehouse with SQL Server 2016/2019, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Course Summary

Next Public Course Dates

UK & Europe:

  • 2 - 6 October 2023
  • 16 - 20 October 2023
  • 4 - 8 December 2023

US & Canada:

  • 25 - 29 September 2023
  • 23 - 27 October 2023
  • 13 - 17 November 2023
Prerequisites
  • None
Duration
  • 5 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
Audience
  • This 5-day course is intended for 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

Course Modules

  • Introduction to Data Warehousing
  • Data Warehouse Hardware
  • Designing and Implementing a Data Warehouse
  • Creating an ETL Solution with SSIS
  • Implementing Control Flow in an SSIS Package
  • Debugging and Troubleshooting SSIS Packages
  • Implementing an Incremental ETL Process
  • Incorporating Data from the Cloud into a Data Warehouse
  • Enforcing Data Quality
  • Using Master Data Services
  • Extending SQL Server Integration Services
  • Deploying and Configuring SSIS Packages
  • Consuming Data in a Data Warehouse

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

Book This Course

Other Training Areas of Interest

Get Notified of Upcoming Classes

Want to know when the next class will be offered? Sign up for notifications!

      To discuss your project requirements, send us a message

        For a free assessment, quick quote or training information, send us a message

          To book this course, please fill in your details and submit the form.

            To book this course, please fill in your details and submit the form.

              To discuss your training requirements or book a class, drop us a line