Oracle 10g DW Fundamentals (O1080) Training Course

Training Course Objectives

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.

Who Should Attend

• Oracle Developers
• Oracle DBA's

Training Course Prerequisites

• PC Fundamentals
• View Learning Path

Training Course Duration

2 Days

Training Course Contents

Introduction

• An overview of Data Warehousing ideas
• Decision Support systems
• Executive Information Systems
• Analytical vs. Transactional processing

Modelling

• Star schema design
• Entity relationships
• Dimensions
• Fact Tables
• Data Cubes
• MOLAP and ROLAP.
• Data Warehouses vs. Data Marts.
• Metadata Layers

ETL

• Data Sources
• Extracting data
• Transforming data
• Loading data into the Warehouse
• SQL and PL/SQL techniques
• External Tables
• Materialised Views

Oracle Warehouse Builder

• Building the Warehouse
• Refreshing the Warehouse data
• Managing the Warehouse

Reporting

• Oracle Discoverer
• Summary Tables
• Oracle Reports
• Analytical SQL
• Tabular vs. Matrix reports
• Other reporting tools.

Next Available Dates

iTrain delivers this course as company specific training. Please contact us for more information or course dates.