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.
View full outline in PDF formatDetailed Outline

print  |  top of page