Oracle Database 11g: Data Warehousing and Oracle Warehouse Builder
Duration: 5 Days
This course focuses on the features within the Oracle database that support data warehouses and data mining operations. The students will learn about data warehousing concepts and the requirements to initially configure a data warehouse installation. They will also learn 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.
Topics Covered In This Course
Data Warehouse Design & Schemas
Creating Materialized Views
Maintaining Materialized Views
Materialized View Refresh
Controlling the Query Rewrite Facility
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 & Correction Mappings
Process Flows & Schedules
What You Can Expect
At the end of this course, students will be able to:
Who Should Take This Course
This course is designed for database administrators, data warehouse administrators and application developers who will be responsible for implementing applications using data warehouse technology.
Data Warehouse Overview Class or equivalent, and good SQL experience.
Instructor led with 50% lecture and 50% lab.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]