Home > Data Warehousing > DB2 Data Warehousing Fundamentals

DB2 Data Warehousing Fundamentals

Course Code:	DWHFUN
Duration:	3 days
Audience:	IT developers, database administrators or anyone responsible for a data warehouse or related discipline.
Prerequisites:	At least six (6) months in a DB2 environment or its equivalent.
Summary:	This data modelling techniques course is designed to answer questions, such as the following: What is data warehousing? What is a data mart? What are the data modelling options? What are the terms and concepts specific to data warehousing and OLAP design? How to plan and implement a data warehouse with high availability, simplified manageability and optimal performance What are common statistics, analytic and OLAP SQL queries?
Objectives:	Upon completion of this course, the participant should be able to design a data warehouse using both star and snowflake schemas. And the delegate should understand the implication of such terms as cubes, dimensions, attributes, joins, hierarchies, measures, etc.
Detailed Outline

Course Schedule