Oracle® GoldenGate 11g: Fundamentals for Oracle® Training

3896 Learners

Oracle® GoldenGate 11g: Fundamentals for Oracle® Training from PR Tech Skills imparts aspirants with skills and knowledge related to installation of Oracle GoldenGate, along with preparing the source and target environment. Oracle GoldenGate 11g Fundamentals focuses on Oracle-to-Oracle data replication and is considered as one of the best data replication software or an ETL tool.

Learn at length the architecture and features of Oracle GoldenGate with this Oracle GoldenGate 11g certification course, with complete know-how of using command line interface. The aspirants get acquainted with Installation of Oracle® GoldenGate on Linux and Windows platforms, Oracle GoldenGate instances, Change Configure, Change Delivery, and several other advanced features.

Upon the completion of Oracle® GoldenGate 11g: Fundamentals for Oracle® training in Noida, the candidates will become proficient in the following skills:

  • Install Oracle GoldenGate
  • Configure Change Capture, Change Delivery and Initial Load
  • Understand, use and manage GoldenGate utilities, instances
  • Understand GoldenGate architecture, solutions
  • Oracle-to-Oracle data replication
  • Data transformation
  • Extracting files and trails
Target audience

Candidates suitable for opting Oracle GoldenGate 11g certification course include Data Warehouse Administrator, Data Warehouse Developer, Data Warehouse Analyst, System Integrator, Database Designers and Database Administrators.

Prerequisites

Aspirants opting for this course should be familiar with Oracle Database and basic SQL, along with familiarity in Linux text editors.

Download Course Brochure

Oracle® GoldenGate 11g: Fundamentals for Oracle® Training from PR Tech Skills imparts aspirants with skills and knowledge related to installation of Oracle GoldenGate, along with preparing the source and target environment. Oracle GoldenGate 11g Fundamentals focuses on Oracle-to-Oracle data replication and is considered as one of the best data replication software or an ETL tool.

Learn at length the architecture and features of Oracle GoldenGate with this Oracle GoldenGate 11g certification course, with complete know-how of using command line interface. The aspirants get acquainted with Installation of Oracle® GoldenGate on Linux and Windows platforms, Oracle GoldenGate instances, Change Configure, Change Delivery, and several other advanced features.

Upon the completion of Oracle® GoldenGate 11g: Fundamentals for Oracle® training in Noida, the candidates will become proficient in the following skills:

  • Install Oracle GoldenGate
  • Configure Change Capture, Change Delivery and Initial Load
  • Understand, use and manage GoldenGate utilities, instances
  • Understand GoldenGate architecture, solutions
  • Oracle-to-Oracle data replication
  • Data transformation
  • Extracting files and trails
Target audience

Candidates suitable for opting Oracle GoldenGate 11g certification course include Data Warehouse Administrator, Data Warehouse Developer, Data Warehouse Analyst, System Integrator, Database Designers and Database Administrators.

Prerequisites

Aspirants opting for this course should be familiar with Oracle Database and basic SQL, along with familiarity in Linux text editors.

Oracle® GoldenGate 11g: Fundamentals for Oracle® Training Course Content

1. Oracle GoldenGate 11gR1 Introduction

  • Introducing Oracle GoldenGate Features and Functionality
  • Describing Oracle Middleware for Business Intelligence
  • Describing Oracle GoldenGate High Availability and Disaster Tolerance Solutions
  • Describing Oracle GoldenGate Real-time Data Integration Solutions

2. Understanding Oracle GoldenGate: Overview

  • Describing Oracle GoldenGate Functionality and Components
  • Listing Supported Databases and Platforms
  • Describing the Oracle GoldenGate Product Line

3. 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 Number (CSN)
  • Describing Oracle GoldenGate Files

4. Installing Oracle GoldenGate

  • Installing Oracle GoldenGate on Linux
  • Preparing the Operating System
  • Running GoldenGate Commands from the GGSCI Prompt,
  • Using Obey Files and OS Shell
  • Get help information on GGSCI commands
  • Identify the types of GGSCI commands available

5. Configuration Overview and Preparing the Environment

  • Describing the High-level Configuration Steps
  • Configuring and Starting the Manager Process
  • Generating a Source Definitions File
  • Preparing a Source Database for Transaction Capture

6. Configuring Change Capture

  • Describing the Extract Process
  • Marking Tables with TRANDATA
  • Configuring Extract to Access Logs on Oracle ASM
  • Configuring and Starting an Extract Process
  • Addind Local and Remote Trails
  • Configuring and Starting an Extract Data Pump

7. 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

8. Configuring Change Delivery

  • Explaining the Replicat Process
  • Explaining Adding, Configuring and Starting a Replicat Process
  • Describing Avoid and Handle Collisions Between Changes and the Initial Load Data

9. Extracting Trails and Files

  • Describing and Contrast Extract Trails and Files
  • Investigating Different Formats
  • Viewing Extract Trails and Files with Logdump
  • Reversing the Sequence of Operations in an Extract Trail or File to Back out Changes

10. Working with Parameters

  • Editing Parameter Files
  • Contrasting GLOBALS with Process Parameters
  • Describing Commonly-used Parameters for GLOBALS, Manager, Extract and Replicat

11. Using Data Selection and Filtering

  • Selecting and Filtering Data for Replication
  • Mapping Columns Between Different Schemas
  • Using Built-in Functions
  • Using SQLEXEC to Interact Directly with a Database

12. Using Additional Transformation Concepts

  • Creating and Invoking Macros
  • Setting and retrieving User Tokens
  • Running User Exits in GoldenGate Processes
  • Replicating Oracle Sequences

13. Introducing Configuration Options

  • Using BATCHSQL to Speed Delivery
  • Understanding Data Compress Across the Network
  • Enabling Message, Trail and Password Encryption
  • Using Event Records to Automatically Trigger Actions

14. Configuring Bidirectional Replication

  • Understanding Bidirectional Configuration
  • Detecting and Avoid Loops
  • Avoiding, Detecting, and Handling Conflicts
  • Handling Identity Types

15. Setting Up DDL Replication

  • Understanding the Concept of DDL Replication
  • Explaining the Requirements for Oracle DDL Replication
  • Describing GoldenGate Options for DDL Replication
  • Explaining DDL String Subsitution

16. Tuning and Troubleshooting

  • Controlling Command Persionns
  • Managing Trail Files
  • Automating Process Setup
  • Restarting Oracle GoldenGate
  • Handling TCP/IP Errors
  • Using Reporting and Statistics
  • Monitoring Processes, Lags and Error Messages
  • Features of GoldenGate Management Pack

Drop Us a Query

+91 95550 06479

Available 24x7 for your queries

Oracle® GoldenGate 11g: Fundamentals for Oracle® Corporate Training & Certification Prog

Employee training and development programs are essential to the success of businesses worldwide. With our best-in-class corporate trainings you can enhance employee productivity and increase efficiency of your organization. Created by global subject matter experts, we offer highest quality content that are tailored to match your company’s learning goals and budget.

Learn from the experts

Customized Training

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements of your workforce. You can even choose a trainer from our team of certified industry experts.

Learn from the experts

Expert Mentors

Get trained from our team of highly skilled and certified trainers, who are officially accredited professionals with relevant industry experience and adept in providing the knowledge and skills required to be successful.

Learn from the experts

360º Learning Solution

Engage your employees with our all-inclusive learning platform. Avail benefits of 24/7 access to the learning management system, industry-certified mentors, assessments & mock tests, real-time learning and more.

Learn from the experts

Learning Assessment

Check test score and performance with our skills analysis tools. Our detail scoreboard displays scores, areas of strength, detailed answer of questions and more for each employee.

Download Corporate Brochure

+91 9555006479

Available 24x7