Home > Data Warehousing > Data Warehousing Terms, Concepts & Architecture

Data Warehousing Terms, Concepts & Architecture

Course Code:	DWHTCA
Platform:	Multi-platform: DB2 for z/OS, DB2 UDB for Linux/UNIX/Windows, Oracle, SQL Server, etc.
Duration:	1 day
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.
Detailed Outline

Course Schedule