Oracle Physical Data Warehouse Design Performance

Wise

Course

In Gatwick

£ 1,425 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Location

    Gatwick

  • Duration

    4 Days

Upon completion of this course, the participant should be able to translate logical DW design specifications into an Oracle physical design model; and in turn, create the necessary scripts (e.g., DDL) to install a large scale partitioned DW, using, amongst other things, bitmap indexes. Suitable for: Database administrators and system administrators.

Facilities

Location

Start date

Gatwick (London)
Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, RH6 0NT

Start date

On request

About this course

Completion of our course Data Warehouse Terms, Concepts & Architecture or equivalent knowledge.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

After discussing the components of the data warehouse and data warehousing, this course elaborates on the essential physical design and phases of an Oracle data warehouse (DW).
Particular emphasis is placed on the following:

  • DW partitioning
  • Index options (e.g., bitmaps)
  • Integrity and constraints
  • Materialized views (summary tables)
  • DW objects (dimensions, hierarchies, etc.)
  • The ETL process
  • Performance and good practices

See related categories

Oracle Physical Data Warehouse Design Performance

£ 1,425 + VAT

The best Oracle courses

See all

See all