back to Course Categories | back | print
Oracle9i: Intro to Data Warehousing and ETL          

Duration: 5 days

Description 
This class is designed for Oracle developers and DBAs who need to learn the key features in Oracle9i that support data warehousing. This is intended to be a bootstrap course for experienced Oracle technologists to teach them the key features of Oracle9i data warehousing features. A heavy emphasis will be placed on Extraction, Transformation and Loading (ETL) techniques. In this class, attendees will learn the issues in planning, designing, implementing, populating, and managing a data warehouse in Oracle9i. The advantages and issues in implementing a successful data warehouse will be studied. Attendees will learn the key Oracle data warehousing features used in implementing, and running a data warehouse. A detailed study of ROLAP and analytical functions is included. Data warehousing tuning issues will also be covered.

Topics

  • Issues in designing and implementing systems for complex analysis
  • Management Information Systems
  • Decision Support Systems (DSS)
  • Understanding business needs and requirements
  • Data warehouse concepts and terminology
  • Data Warehouse Properties
  • Data Warehousing Terminology
  • Key components of a data warehouse
  • Data Warehouse Fundamental Elements
  • Oracle Warehouse Technology Initiative (WTI)
  • Data Warehouse Storage
  • Accessing large tables in an Oracle data warehouse
  • Range, hash, composite, list and range-list partitioning
  • Accessing large indexes in an Oracle data warehouse
  • Global versus local indexes
  • Function-based, reverse-key, bitmap and bitmap-join indexes
  • ROLAP operators
  • SAMPLE operator
  • Top 'N Analysis
  • Extracting, Transforming, and Loading Data
  • External functions
  • Table functions
  • Star schema
  • Snowflake schema
  • Materialized views
  • Query rewrites
  • Online Analytical Processing (OLAP) Models
  • Query Access Architectures
  • Parallel query and parallel DML operations
  • Tuning parallel operations
  • Transformation Techniques
  • Refreshing Warehouse Data
  • Capturing Changed Data
  • Oracle streams
  • Advanced Queuing
  • External tables
  • Managing metadata
  • Business Intelligence
  • Multidimensional Query Techniques
  • Data Mining
  • Tuning for a data warehouse

Prerequisites

  • A strong background in Oracle development or database administration.

  • This class combines the Data Warehousing Fundamentals and the Oracle9i Data Warehousing features into a single 5 day class.

 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design