Loading...

Oracle 10g Data Warehousing Fundamentals

Course code: O1080

2 days

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.

Course content >

Who Should Attend?

Everybody

Prerequisites

None

Course Contents

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.

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.
Contact us for more information