Home > Oracle > Oracle Physical Data Warehouse Design & Performance

Oracle Physical Data Warehouse Design & Performance

Course Code:	OWHPDP
Currency:	10g & 11g
Duration:	4 days (hands-on machine workshop)
Level:	Intermediate-to-advanced
Audience:	Database administrators and system administrators.
Prerequisites:	Completion of our course Data Warehouse Terms, Concepts & Architecture or equivalent knowledge.
Summary:	After discussing the components of the data warehouse and data warehousing, this course elaborates on the essential physical design and phases of an Oracle data warehouse (DW). Particular emphasis is placed on the following: DW partitioning Index options (e.g., bitmaps) Integrity and constraints Materialized views (summary tables) DW objects (dimensions, hierarchies, etc.) The ETL process Performance and good practices
Objectives:	Upon completion of this course, the participant should be able to translate logical DW design specifications into an Oracle physical design model; and in turn, create the necessary scripts (e.g., DDL) to install a large scale partitioned DW, using, amongst other things, bitmap indexes.
Detailed Outline

Course Schedule