The Data Warehouse ETL Toolkit

Catalog Home Databases, Business Intelligence & Data Science Data Mining & Data Warehousing
3.236.156.34
Your Training Location:  

The Data Warehouse ETL Toolkit

  Add Course To Watch List
  View Full Course Outline
  Request A Public Course
         In Your Area
  Request A Quote For A
        Private Class
Delivery Options & Status:
Building to GUARANTEED-TO-RUN
Instructor Led
Loading Course Dates...
Failed
No available dates in this city.

  Available by Request
{{date.date_begin | date:'M/d'}} - {{date.date_end | date:'M/d/yyyy'}}
   Free{{date.date_price}}
 
ViewHide Additional Dates

Summary

This course provides students with the skills necessary to plan, design, build, and run the ETL processes which are needed to build and maintain a data warehouse. It is based on the Ralph Kimball and Joe Caserta book The Data Warehouse ETL Toolkit published in 2004 by Wiley Publishing, Inc, ISBN: 0-7645-6757-8.

Prerequisites

Students should have good knowledge of how to design a database through at least third normal form (3NF) as well as good knowledge of how to design a star schema.

Duration

3-4 Days/Lecture & Lab

Audience

This course is targeted at technical staff, team leaders and project managers who need to understand how to plan, design, build, and run the Extract, Transformation, and Load (ETL) processes which are necessary to build and maintain a data warehouse.

Topics

  • Surrounding the Requirements
  • ETL Data Structures
  • Extracting
  • Cleaning and Conforming
  • Delivering Dimension Tables
  • Delivering Fact Tables
  • Development
  • Operations
  • Metadata
  • Responsibilities
  • Real-Time ETL Systems
  • Conclusions




Related Scheduled Courses

< >

Search our catalog of over 500 course titles!

Copyright © 2021 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media