Home > Oracle > Oracle Data Warehouse Design

Oracle Data Warehouse Design

Course Code:	OWHDWD
Currency:	10g & 11g
Duration:	5 days
Audience:	DW architects and DBAs.
Prerequisites:	Completion of our course Data Warehouse Terms, Concepts & Architecture or equivalent knowledge.
Summary:	After presenting entity relationship (ER) and dimensional modelling (DM) as competing alternatives, the presentation will focus on the use of DM techniques when developing and implementing a very large data warehouse. Using real-world business scenarios, SALES, for example, the instructor will coach the participants from logical through physical design of a data warehouse involving at least five dimensions and one-or-more star schemas. Thus hands-on exercises include: Design and creation of dimensions Design and creation of star schemas Design and creation of hierarchies Design and creation of indexes Design and creation of integrity constraints Extract, Transform and Load (ETL) options Parallelism Design and create materialized views (summary tables) Throughout the foregoing, best practices and performance issues are discussed.
Objectives:	Upon completion of this course, the participant should be able to monitor and tune large data warehouses in a BI (Business Intelligence) or DS (Decision Support) environment.
Detailed Outline

Course Schedule