Oracle Data Warehousing: ETL Specifically

Course

In Gatwick

£ 1,425 + VAT

Description

  • Type

    Course

  • Location

    Gatwick

  • Duration

    4 Days

Upon completion of this presentation, the participant should understand the ETL phase of the data warehouse development life cycle. Suitable for: DW administrators, DBAs, data architects, DW PL/SQL developers.

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



Currency:
10g & 11g

Audience:
DW administrators, DBAs, data architects, DW PL/SQL developers.

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

Summary:
This course focuses on the extract, transform and load (ETL) phase of the data warehouse (DW) development life cycle. After discussing ETL as it relates to all DBMSs (DB2, MS SQL Server, Sybase, etc.) we elaborate on Oracle's ETL offering:

  • Change Data Capture
  • SQL*Loader
  • Data Pump
  • External tables
  • Transportable tables
  • SQL MERGE
  • Table Functions
  • Etc.


Objectives:
Upon completion of this presentation, the participant should understand the ETL phase of the data warehouse development life cycle.

Oracle Data Warehousing: ETL Specifically

£ 1,425 + VAT