Oracle 10g Data Warehousing Fundamentals

PT6016
Summary
In this class, students will learn the issues in planning, designing, implementing, populating, and managing a data warehouse in Oracle10g. The advantages and issues in implementing a successful data warehouse will be studied. Students will learn the key Oracle data warehousing features used in implementing, and running a data warehouse.
Prerequisites
There are no prerequisites for this course.
Duration
3 Days/Lecture & Lab
Audience
This class is designed for Oracle developers and DBAs who need to learn the key features in Oracle10g that support data warehousing.
Topics
  • Reviewing Data Warehouse Basics
  • Defining the Business & Logical Models
  • Creating the Dimensional Model
  • Creating the Physical Model
  • Storage Considerations for the Physical Model
  • Strategies for Extracting, Transforming, and Transporting
  • Summary Management
  • Analytical Capabilities

Related Scheduled Courses