The Data Warehouse ETL Toolkit
The Data Warehouse ETL Toolkit
View Full Course Outline
Request A Public Course
In Your Area
Request A Quote For A
Private Class
Delivery Options & Status:
Let us know if you would like a date for this course added to our schedule
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
