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

Download Course Contents

Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2 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 is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • • View video
  • • The course will be free if we are not able to start within 7 days of booking.
  • • Only applicable for courses on which this logo appears.

Your will learn:

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
  • 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
  • Listing System Requirements
  • Performing Installation
  • Configuring Environment Variables
  • Using GGSCI
  • Running Oracle GoldenGate from the OS shell.
  • Reviewing Configuration Overview
  • Configuring Manager Process
  • Creating Source Definitions
  • Preparing the Source Database
  • Assigning Oracle Database Roles/Privileges Required
  • Using DBMS_GOLDENGATE_AUTH Package
  • 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
  • Reviewing Replicat Overview
  • Configuring Replicat Tasks
  • Configuring a Sample Environment
  • Configuring New Integrated Replicat
  • Reviewing Extract Trails and Files Overview
  • Describing Trail Formats
  • Using Logdump for Viewing Trails
  • Reversing the Trail Sequence
  • Configuring and Using Data Pumps
  • 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
  • Editing Parameter Files
  • 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
  • Configuring New Coordinated Replicat
  • Configuring and Using Macros
  • Configuring and Using User Tokens
  • Configuring and Using User Exits
  • Configuring and Using Oracle Sequences
  • Configuring and Using BATCHSQL
  • Configuring and Using Compression
  • Configuring and Using Encryption
  • Configuring and Using Event Actions
  • Configuring New Wallet Security
  • Reviewing Bidirectional Considerations
  • Detecting Loops
  • Avoiding Conflicts
  • Configuring and Using Conflict Detection and Resolution
  • Describing Identity Types Issues
  • Reviewing Data Description Language Replication Overview
  • Configuring and Using Options for DDL Replication
  • Configuring and Using String Substitution in DDL
Live Online Training (Duration : 32 Hours) Fee On Request
Group Training Incl. Official Courseware
06 - 09 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 07 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training Incl. Official Courseware
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 32 hours. We can offer you an Ultra-Fast Track for 16 hours

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

Trending Technologies

 Cloud Computing
 Security
 Fundamentals
 Cloud Management
 CRM
 Cloud Architect
 Cloud Administration
 Data Analytics
 DevOps
 Virtualization

Request More Information

Add Name and Email Address of participant (If different from you)

Privacy Policy

FAQ's

Yes, fee excludes local taxes.
The Fee includes:
  • Official courseware
  • Testing Via Qubits
Yes, Koenig Solutions is a Oracle Learning Partner