Oracle9i: Intro to Data Warehousing and ETL

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, students 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. Students 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.
Students must have 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.
5 Days/Lecture & Lab
  • 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

Related Scheduled Courses