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.