Connect with us:
Client Testimonials
"I have learned all the SQL commands needed to access the database and pretty confident to solve any kind of problems in DB2."
Student - DBDB-100 DB2 Application Programming and DesignView More Testimonials
Data Warehouse Training Courses
| Course # | Course Name | Duration |
|---|---|---|
DBDB-400 
|
Data Modeling Training This training course is designed to introduce students to the process of logical database design which is also known as logical data modeling. The course presents topics such as the advantages of logical data modeling, how to incorporate business requirements into a logical data model by using use cases, the components of a logical data model and how to create an Entity-Relationship Diagram (ERD) using the open source software called DBDesigner. The course also shows students how to normalize data through third normal form and how to handle complex data relationships. |
3 days |
| DBDB-405
|
Dimensional Modeling for the Data Warehouse Training This training course is designed to provide students with the skills necessary to design a successful data warehouse using multi-dimensional data modeling techniques. It is based on Ralph Kimball’s book The Data Warehouse Toolkit, Second Edition, Wiley, ISBN: 0471200247, published in April, 2002 with additional topics and commentary from Daniel J Hall. The class uses either DB Designer V4 (free), MS Access, or ER/win as the data modeling software tool. Other data modeling tools may be used if you check with our instructor first. This training course can be taught using the ERwin® modeling tool. |
4 days |
| DBDB-410
|
The Data Warehouse Lifecycle Toolkit Training This training course is designed to provide students with the skills necessary to design a successful data warehouse. The course is based on the new Data Warehouse Lifecycle Toolkit, Second Edition, by Ralph Kimball, Margy Ross, Warren Thornthwaite, Joe Mundy, and Bob Becker, ISBN: 0470149779, which was published January 10, 2008 by Wiley. |
4 days |
| DBDB-415
|
The Data Warehouse ETL Toolkit Training This training course is designed to provide 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. The course also uses the following book: Mastering Data Warehouse Aggregates published in 2006 by Wiley Publishing, ISBN: 0-471-77709-9. If the students will be using SQL Server 2005 Integration Services (SSIS) the following book may be substituted for the Ralph Kimball book: The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset by Joy Mundy, Warren Thornthwaite, and Ralph Kimball published by Wiley, February 13, 2006, ISBN 0471267155 |
4 days |
| DBDB-420
|
Mastering Relational and Dimensional Data Warehouse Design Training This training course is designed to provide students with the skills necessary to design a successful data warehouse using both relational and dimensional data modeling techniques. It is based on the book Mastering Data Warehouse Design: Relational and Dimensional Techniques, by Claudia Imhoff, Nicholas Galemmo, and Jonathan G. Geiger published by Wiley Publishing, Inc in 2003, ISBN: 0-471-32421-3 |
4 days |
| DBDB-425
|
Data Mining Overview Training This training course is designed to provide students with the skills necessary to set up, execute, and interpret the output from data mining analysis tools. This training course is based on the book: Mastering Data Mining by Michael J. A. Berry and Gordon S. Linoff published in 2000. |
3 days |
| DBDB-430
|
Mastering Data Warehouse Aggregates Training This training course is designed to provide students with the skills necessary to plan, design, and build star schema aggregates. It is based on the Christopher Adamson book Mastering Data Warehouse Aggregates published in 2006 by Wiley Publishing, Inc, ISBN: 0-471-77709-9. The book contains examples of Materialized Query Tables (MQTs) from DB2 and Materialized Views from Oracle. |
3 days |
| DBDB-435
|
Delivering Business Intelligence With Microsoft SQL Server 2005 Training This training course is designed to provide students with the skills necessary to deliver business intelligence. It is based on the Brian Larson book Delivering Business Intelligence with Microsoft SQL Server 2005 published in 2006 by McGraw-Hill Osborne Media, ISBN: 0072260904. |
3 days |
| DBDB-440
|
Delivering Business Intelligence Fundamentals Training This training course is designed to provide students with the skills necessary to deliver business intelligence. It is based on the Larissa T. Moss and Shaku Atre book Business Intelligence Roadmap published in 2003 by Addison-Wesley Pearson Education, ISBN: 0-201-78420-3. |
5 days |
| DBDB-445
|
Balanced Scorecards and Operational Dashboards with Microsoft Excel Training This training course is designed to provide students with the skills necessary to design and implement scorecards and dashboards. It is based on the Ron Person book Balanced Scorecards and Operational Dashboards With Microsoft Excel published in 2009 by Wiley Publishing, Inc, ISBN: 978-0-470-38681-1. |
5 days |
