Course 20463: Implementing a Data Warehouse with Microsoft SQL Server

You are here: / / / 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

Book Now

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
Ask About Private Classes Ask About Group Rates

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

Link to: Microsoft BI Training

Microsoft

Learn how to implement Microsoft SQL servers and how to use Microsoft BI for analytics and reporting.

Link to: Tableau Training

Tableau

Whether you are a novice or an experienced user, we offer courses that allows you to get the most out of this application.

Link to: Informatica Training

Informatica

ExistBI is an approved Informatica University training partner. We offer official or custom curriculums in your office or online via live instructor-led virtual classroom.

View all training areas offered by ExistBI

Get Notified of Upcoming Classes

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

    Consulting

    Training

    About ExistBI

    Contact Us

    U.S. Headquarters
    Century Plaza Towers,
    2029 Century Park E Suite 400,
    Los Angeles, CA 90067
    (866) 965-6332 (Toll-Free)
    (310) 683-0115

    UK Office
    Hamilton House,
    Mabledon Place,
    London WC1H 9BB, UK
    +44 (0)207 554 8568

    Other Locations

    Jersey City Office
    101 Hudson Street, 21st Floor,
    Jersey City, NJ 07302
    (866) 965-6332 (Toll-Free)
    (347) 229-9507

    Washington DC Office
    1050 Connecticut Ave NW, Suite 500,
    Washington, DC 20036
    (202) 301-4679

    German Office
    Europaplatz 2, 8th Floor,
    Berlin, 10557, Germany
    +49 302 204 3994

    Cleveland Office
    600 Superior Ave, 3rd Floor,
    Cleveland, OH 44114
    (216) 242-4125

    Denver Office
    1600 Broadway Suite 1600,
    Denver, CO 80202
    (720) 399-4525

    Croatia Office
    Bencekovićeva 33,
    10000 Zagreb, Croatia
    +44 (0)207 554 8568

    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 discuss your training requirements or book a class, drop us a line