Home >
Oracle >
Oracle Data Warehouse Performance & Tuning
Oracle Data Warehouse Performance & Tuning
| Course Code: |
OWHDPT |
| Currency: |
10g & 11g |
| Duration: |
4 days |
| 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.
|
Detailed Outline |
|