Oracle 11g: Data Warehousing & Oracle Warehouse Builder

    

Summary:
This course highlights the features within the Oracle database specifically intended to support data warehouses and data mining operations. It is presented as a two-volume set. The first volume considers data warehousing concepts and the requirements to initially configure a data warehouse installation. The second volume discusses how the Oracle Warehouse Builder (OWB) product may be used to implement and maintain both transactional and warehouse databases, and the movement of data between those two different types of installations.

Duration:
5 Days/Lecture & Lab

Audience:
The target audience for this course is database administrators, data warehouse administrators and application developers who will be responsible for implementing applications using data warehouse technology.

Topics:

• Data Warehouse Design & Schemas
• Creating Materialized Views
• Maintaining Materialized Views
• Materialized View Refresh
• Controlling the Query Rewrite Facility
• Dimensions
• Dimensional Analysis of Data
• Star Queries & the Optimizer
• ETL Loading from External Tables
• ETL Transformation with Table Functions
• About Oracle Warehouse Builder
• Configure Oracle Warehouse Builder
• Using the Design Center & Building the Infrastructure
• Define Modules & Import Metadata
• Maintaining the Relational Model
• Data Quality Assurance & Management
• Data Rules & Corrections Mappings
• ETL Mappings
• Process Flows & Schedules

Prerequisites:
A mandatory prerequisite to this course is Oracle Database 11g: Implement Parallel SQL & Partitioning for Data Warehouses. Additionally, it is recommended that one have attended one of the following advanced courses provided for either database developers or database administrators:* Oracle Database 11g: New & Advanced Features for Developers * Oracle Database 11g: New Features for Administrators

Last Update: May 25, 2013