Oracle Database 11g: Data Warehousing & Oracle Warehouse Builder (5 day)

Description

This Oracle 11g training textbook 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.

This textbook can be used for advanced self-study, or for instructor-led training in both in-class or virtual-class environments. Textbooks can also be used for ongoing reference long after the course is completed.

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 R2: NEW & ADVANCED FEATURES FOR DEVELOPERS
• ORACLE DATABASE 11g R1 & R2: NEW FEATURES FOR ADMINISTRATORS

Instructor Resources

Instructor resources from the Sideris Training Portal combined with Sideris custom print courseware make distance-learning and virtual training more effective than ever! Available for download when you purchase this title. Please turn on your audio, make sure you have the latest version of Adobe Reader and then watch the demo to see how these new instructor resources improve your instructor’s presentations!

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!