Data Warehousing Terms, Concepts Architecture

Platform: Multi-platform: DB2 for z/OS, DB2 UDB for Linux/UNIX/Windows, Oracle, SQL Server, etc.


Audience: IT developers, database administrators or anyone responsible for a data warehouse or related discipline. Prerequisites: At least six (6) months of IT developer and/or technical experience. Summary: This DW terminologies and concepts course addresses the following topics:

• 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?
• What are common statistics, analytic and OLAP SQL queries?

Objectives: Upon completion of this course, the participant should be conversant with terms and concepts as these relate to 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.