Oracle Goldengate Essentials training course

  Oracle GoldenGate 12c Introduction
•    Describing Oracle GoldenGate Files
•    Contrasting Batch and Online Operation
•    Explaining Change Capture and Delivery (with and without a Data Pump)
•    Describing Commit Sequence Number (CSN)
•    Describing Oracle GoldenGate Process Groups
•    Explaining Initial Data Load
•    Explaining Oracle GoldenGate Checkpointing
Installing Oracle GoldenGate
•    Get help information on GGSCI commands
•    Installing Oracle GoldenGate on Linux
•    Identify the types of GGSCI commands available
•    Using Obey Files and OS Shell
•    Preparing the Operating System
•    Running GoldenGate Commands from the GGSCI Prompt,
Configuration Overview and Preparing the Environment
•    Describing the High-level Configuration Steps
•    Preparing a Source Database for Transaction Capture
•    Generating a Source Definitions File
•    Configuring and Starting the Manager Process
Configuring Extracts
•    Configuring and Starting an Extract Process
•    Adding Local and Remote Trails
•    Marking Tables with TRANDATA
•    Configuring and Starting an Extract Data Pump
•    Describing the Extract Process
Configuring Initial Load
•    Describing Oracle GoldenGate Initial Load Methods
•    Describing a Variety of Database-specific Methods
•    Explaining the Advantages of Oracle GoldenGate Methods
•    Configuring an Initial Load using Oracle GoldenGate
Configuring Replicat
•    Describing Avoid and Handle Collisions Between Changes and the Initial Load Data
•    Explaining the Replicat Process
•    Explaining Adding, Configuring and Starting a Replicat Process
Extracting Trails and Files
•    Reversing the Sequence of Operations in an Extract Trail or File to Back out Changes
•    Investigating Different Formats
•    Describing and Contrast Extract Trails and Files
•    Viewing Extract Trails and Files with Logdump
Working with Parameters
•    Describing Commonly-used Parameters for GLOBALS, Manager, Extract and Replicat
•    Editing Parameter Files
•    Contrasting GLOBALS with Process Parameters
Using Data Selection and Filtering
•    Using SQLEXEC to Interact Directly with a Database
•    Selecting and Filtering Data for Replication
•    Using Built-in Functions
•    Mapping Columns Between Different Schemas
Using Additional Transformation Concepts
•    Setting and retrieving User Tokens
•    Replicating Oracle Sequences
Setting Up DDL Replication
•    Explaining DDL String Substitution
•    Understanding the Concept of DDL Replication
•    Explaining the Requirements for Oracle DDL Replication
•    Describing GoldenGate Options for DDL Replication