|
ora11g205-ver1
Oracle Database 11g: Data Warehousing & Oracle Warehouse Builder (5 day)
Description
This Oracle 11g courseware training guide book will highlight 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.
Audience
Target audience for this course are database administrators, data warehouse administrators and application developers who will be responsible for implementing applications using data warehouse technology.
Prerequisites
A mandatory prerequisite to this course is the Sideris course 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
Objectives
Among the specific topics considered within this course are:
• Understanding star and snowflake schemas and other data warehouse physical and logical database objects.
• Understanding and encouraging optimization of star queries.
• Creating and maintaining materialized views to enhance ad-hoc query performance against enormous volumes of transactional data.
• Manage materialized views to effectively and efficiently maintain their structure over the course of time.
• Creating and maintaining dimensions and hierarchies to enhance ad-hoc query performance and support sophisticated data mining.
• Performing dimensional analysis of data warehouse information and building cubes.
• Configuration of the Oracle Warehouse Builder (OWB) repository and consideration of OWB capabilities.
• Implementing data quality assurance using data rules and the OWB Data Profiler to evaluate data quality within transactional source databases and warehouse target databases.
• Using mappings and process flows for data correction and augmentation, as well as building Extraction, Transformation and Transformation (ETT) or Loading (ETL) processes within OWB.
 Download
PDF outline here!
|
|
|
|
