0
  • An empty cart

    You have no item in your shopping cart

0
  • An empty cart

    You have no item in your shopping cart

Enter your keyword

Oracle GoldenGate 11g: Fundamentals

Oracle GoldenGate 11g: Fundamentals

Course Overview

This course teaches on Oracle GoldenGate 11g: Fundamentals and focuses Oracle-to-Oracle database replication. This course introduces the Oracle GoldenGate architecture as well as various product features. You will learn to install Oracle GoldenGate and prepare the source and target environments. The course teaches how to configure Change Capture (Extract), Change Delivery (Replicat), and Initial Load and use the Oracle Golden Gate command line interface (GGSCI) efficiently. You will learn to extract trails and files using Data Pump, create parameter files, and to manage Oracle GoldenGate instances.

COURSE START DATES

Start DateTimeDaysDurationLocation
18/05/202010.00-17.00Mon to Tue4 DaysBrentford
20/07/202010.00-17.00Mon to Thu4 DaysBrentford
21/09/202010.00-17.00Mon to Thu4 DaysBrentford
23/11/202010.00-17.00Mon to Thu4 DaysBrentford

Prerequisites

  • Dimensional modeling
  • Basic SQL
  • Data warehouse design
  • Database design

Target Audience

  • Business Intelligence Developer
  • Data Warehouse Administrator
  • Business Analysts
  • Data Warehouse Analyst
  • Data Modelers
  • Reports Developer
  • Data Warehouse Developer
  • Application Developers

Course Content

Oracle GoldenGate 11g: Fundamentals

  • Discussing Required versus Suggested Knowledge
  • Listing Course Objectives
  • Discussing Course Non-Objectives (available as other follow-on courses)
  • Technology Overview

  • Reviewing Oracle GoldenGate Use Cases
  • Assembling Building Blocks
  • Listing Supported OS
  • Listing Supported Databases
  • Listing the Oracle Goldengate Product Line
  • Describing GUI Management Options
  • Listing Non-Database Sources and Targets
  • Oracle GoldenGate Architecture

  • Explaining change Capture and Delivery (with and without a data pump)
  • Explaining Initial Data Load
  • Contrasting Batch and Online Operation
  • Explaining Oracle GoldenGate Checkpointing
  • Describing Commit Sequence Numbers (CSN)
  • Describing Oracle GoldenGate Files and Directories
  • Installing Oracle GoldenGate

  • Performing Installation
  • Configuring Environment Variables
  • Using GGSCI
  • Running Oracle GoldenGate from the OS shell.
  • Configuration Overview and Preparing the Environment

  • Configuring Manager Process
  • Creating Source Definitions
  • Preparing the Source Database
  • Assigning Oracle Database Roles/Privileges Required
  • Configuring Change Capture (Extract)

  • Accessing Logs on Oracle ASM
  • Accessing Logs Remotely
  • Configuring Extract Tasks
  • Adding Extract Group
  • Editing Extract Parameters
  • Extracting Use of Archived Transaction Logs
  • Adding Trails
  • Configuring Change Delivery (Replicat)

  • Configuring Replicat Tasks
  • Configuring a Sample Environment
  • Configuring Extract Trails and Files (Data Pump)

  • Describing Trail Formats
  • Using Logdump for Viewing Trails
  • Reversing the Trail Sequence
  • Configuring and Using Data Pumps
  • Performing Initial Load

  • Listing Database-specific Methods
  • Describing Resource Limitations
  • Listing Advantages of Oracle GoldenGate Methods
  • Configuring File Load Methods
  • Configuring Direct Load Methods
  • Handling Collisions with Initial Load
  • Editing Configuration Parameters

  • Contrasting GLOBALS versus Process Parameters
  • Configuring GLOBALS Parameters
  • Configuring Manager Parameters
  • Configuring Extract Parameters
  • Configuring Replicat Parameters
  • Filtering and Data Selection

  • Mapping Columns Between Different Schemas
  • Using Built-in “@” (at) Functions
  • Using SQLEXEC to Interact Directly with a Database
  • Additional Transformation Concepts

  • Configuring and Using User Tokens
  • Configuring and Using User Exits
  • Configuring and Using Oracle Sequences
  • Configuration Options

  • Configuring and Using Options for DDL Replication
  • Configuring and Using String Substitution in DDL

  • Detecting Loops
  • Avoiding Conflicts
  • Configuring and Using Conflict Detection and Resolution
  • Describing Identity Types Issues
  • DDL Replication

Reviews Statistic

0
0 out of 0
0 Ratings
5 Start 0
4 Start 0
3 Start 0
2 Start 0
1 Start 0

Reviews

There are no reviews yet.

Be the first to review “Oracle GoldenGate 11g: Fundamentals”

Duration 4 Days
Price £1,290.00

Start Date *

Location map

Share our course