Back to Search Results

Training Course Summary:

This course will study the fundamentals of Data Warehousing and the benefits it can bring to any Business Intelligence system. It will look into the planning, design and deployment of a Data Warehouse, and also deal with the reporting issues involved.

As well as an overview of the concepts behind Data Warehousing, Oracle Warehouse Builder and Oracle Discoverer will be used to examine some of the techniques available. This course is applicable to those using 9i as well as 10g versions.

Pre-Requisites:

PC Fundamentals

Who Should Attend:

Oracle Developers
Oracle DBA's

Training Course Overview/Content:

Introduction
An overview of Data Warehousing ideas
Decision Support systems
Executive Information Systems
Analytical vs. Transactional processing
back to top
Modelling
Star schema design
Entity relationships
Dimensions
Fact Tables
Data Cubes
MOLAP and ROLAP.
Data Warehouses vs. Data Marts.
Metadata Layers
back to top
ETL
Data Sources
Extracting data
Transforming data
Loading data into the Warehouse
SQL and PL/SQL techniques
External Tables
Materialised Views
back to top
Oracle Warehouse Builder
Building the Warehouse
Refreshing the Warehouse data
Managing the Warehouse
back to top
Reporting
Oracle Discoverer
Summary Tables
Oracle Reports
Analytical SQL
Tabular vs. Matrix reports
Other reporting tools.