Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2/1Z0-447

Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2 Certification Training Course Overview

Oracle GoldenGate 12c: Fundamentals for Oracle Ed 1 training course focuses on Oracle-to-Oracle database replication. In Oracle GoldenGate 12c: Fundamentals for Oracle Ed 1 training you will learn deep dive into the Oracle GoldenGate architecture, walking you through various product features.

Who Should do this course?

  • Configuration Consultant
  • Data Warehouse Administrator
  • Data Warehouse Analyst
  • Data Warehouse Developer
  • Database Administrators
  • Database Designers
  • System Integrator
  • Technical Consultant
This course prepares you for Exam 1Z0-447. Test your current knowledge Qubits42

Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2 (32 Hours) Download Course Contents

Live Virtual Classroom
Group Training 2800
08 - 11 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 09 Dec 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 3250
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: Technology Overview
  • Creating Oracle GoldenGate Topologies
  • Reviewing Oracle GoldenGate Use Cases
  • Assembling Building Blocks
  • Listing Supported OS
  • Listing Supported Databases
  • Listing the Oracle GoldengGate Product Line
  • Describing GUI Management Options
  • Listing Non-Database Sources and Targets
Module 2: Oracle GoldenGate Architecture
  • Describing Oracle GoldenGate Process Groups
  • 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
Module 3: Installing Oracle GoldenGate
  • Listing System Requirements
  • Performing Installation
  • Configuring Environment Variables
  • Using GGSCI
  • Running Oracle GoldenGate from the OS shell.
Module 4: Configuration Overview and Preparing the Environment
  • Reviewing Configuration Overview
  • Configuring Manager Process
  • Creating Source Definitions
  • Preparing the Source Database
  • Assigning Oracle Database Roles/Privileges Required
  • Using DBMS_GOLDENGATE_AUTH Package
Module 5: Configuring Change Capture (Extract)
  • Reviewing Extract Overview
  • 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
Module 6: Configuring Change Delivery (Replicat)
  • Reviewing Replicat Overview
  • Configuring Replicat Tasks
  • Configuring a Sample Environment
  • Configuring New Integrated Replicat
Module 7: Configuring Extract Trails and Files (Data Pump)
  • Reviewing Extract Trails and Files Overview
  • Describing Trail Formats
  • Using Logdump for Viewing Trails
  • Reversing the Trail Sequence
  • Configuring and Using Data Pumps
Module 8: Performing Initial Load
  • Oracle GoldenGate Methods
  • 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
Module 9: Editing Configuration Parameters
  • Editing Parameter Files
  • Contrasting GLOBALS versus Process Parameters
  • Configuring GLOBALS Parameters
  • Configuring Manager Parameters
  • Configuring Extract Parameters
  • Configuring Replicat Parameters
Module 10: Filtering and Data Selection
  • Filtering and Data Selection
  • Mapping Columns Between Different Schemas
  • Using Built-in "@" (at) Functions
  • Using SQLEXEC to Interact Directly with a Database
  • Configuring New Coordinated Replicat
Module 11: Additional Transformation Concepts
  • Configuring and Using Macros
  • Configuring and Using User Tokens
  • Configuring and Using User Exits
  • Configuring and Using Oracle Sequences
Module 12: Configuration Options
  • Configuring and Using BATCHSQL
  • Configuring and Using Compression
  • Configuring and Using Encryption
  • Configuring and Using Event Actions
  • Configuring New Wallet Security
Module 13: Bidirectional Replication
  • Reviewing Bidirectional Considerations
  • Detecting Loops
  • Avoiding Conflicts
  • Configuring and Using Conflict Detection and Resolution
  • Describing Identity Types Issues
Module 14: DDL Replication
  • Reviewing Data Description Language Replication Overview
  • Configuring and Using Options for DDL Replication
  • Configuring and Using String Substitution in DDL
Download Course Contents

Request More Information

Course Prerequisites
  • Familiarity with Oracle Database and basic SQL using SQL*Plus
  • Familiarity with editing Linux text files using gedit or vi

On Completion of this course you will be able to:-

  • Technology Overview
  • Oracle GoldenGate Architecture
  • Installing Oracle GoldenGate
  • Configuration Overview and Preparing the Environment
  • Configuring Change Capture (Extract)
  • Configuring Change Delivery (Replicat)
  • Configuring Extract Trails and Files (Data Pump)
  • Performing Initial Load
  • Editing Configuration Parameters
  • Filtering and Data Selection
  • Additional Transformation Concepts
  • Configuration Options
  • Bidirectional Replication
  • DDL Replication