Oracle Data Warehouse Performance Tuning
Course
In Gatwick
Description
-
Type
Course
-
Location
Gatwick
-
Duration
4 Days
Upon completion of this course, the participant should understand Oracle DB and application tuning options and how they may be used to optimise data warehousing performance. Suitable for: Database administrators, system administrators and developers.
Facilities
Location
Start date
Start date
About this course
Completion of our course Oracle Data Warehouse Design or equivalent knowledge.
Reviews
Course programme
Currency:
10g & 11g
Audience:
Database administrators, system administrators and developers.
Prerequisites:
Completion of our course Oracle Data Warehouse Design or equivalent knowledge.
Summary:
After reviewing Dimensional Modelling fundamentals, this course focuses on tuning the Oracle DB engine and DW application interfaces with especial emphasis on:
- Star schema design
- Indexes
- Materialized views
- Partitioning
- DB parameters
Objectives:
Upon completion of this course, the participant should understand Oracle DB and application tuning options and how they may be used to optimise data warehousing performance.
Oracle Data Warehouse Performance Tuning