Oracle GoldenGate 12c: Fundamentals Training

Download Course Brochure

Instructor-Led Training Parameters

Course Highlights

  • Instructor-led Online Training
  • Project Based Learning
  • Certified & Experienced Trainers
  • Course Completion Certificate
  • Lifetime e-Learning Access
  • 24x7 After Training Support

Instructor-led Training Live Online Classes

Suitable batches for you

Mar, 2024 Weekdays Mon-Fri Enquire Now
Weekend Sat-Sun Enquire Now
Apr, 2024 Weekdays Mon-Fri Enquire Now
Weekend Sat-Sun Enquire Now

Share details to upskills your team



Build Your Own Customize Schedule



Oracle GoldenGate 12c: Fundamentals Training Course Overview

The Oracle GoldenGate 12c Fundamentals training is all about developing the understanding on the configuration as well as implementation of Oracle GoldenGate along with enhancing the decision-making skills while handling the various database issues across the organization. Moreover, this Oracle GoldenGate 12c Fundamentals course has a plethora of knowledge that helps the candidates in demonstrating  the use of command line interface (GGSCI) of Oracle GoldenGateefficiently along with concepts of Extract, replicate and initial load.

The Oracle GoldenGate 12c Fundamentals Training Certifications aim at:

  • Making the candidates aware about the effective use of the GoldenGate products to design replication solutions
  • Provides opportunity to scrutinize the Change Delivery (Replicat), Change Capture (Extract), and Initial Load
  • Develop understanding of dealing with the network transmission while compressing and encrypting data
  • Gives complete overview of the data transformation
  • Make the candidates understand how to execute the GGSCI commands
  • How to use the various utilities and data dumps in managing Extract trails and files
  • The Installation of the Oracle GoldenGate and prepare the source and target database (assumes Oracle-to-Oracle replication
  • How to Transform data
Target audience
  • Configuration Consultant
  • Data Warehouse Administrator
  • System Integrator
  • Technical Consultant
  • Data Warehouse Analyst
  • Data Warehouse Developer
  • Database Administrators
  • Database Designers
Prerequisites

The candidates would be familiar with the Oracle Database and basic SQL using SQL*Plus and how to perform editing Linux text files using gedit or vi

Oracle GoldenGate 12c: Fundamentals Training Course Content

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

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

3. Installing Oracle GoldenGate

  • Listing System Requirements
  • Performing Installation
  • Configuring Environment Variables
  • Using GGSCI
  • Running Oracle GoldenGate from the OS shell.

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

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

6. Configuring Change Delivery (Replicat)

  • Reviewing Replicat Overview
  • Configuring Replicat Tasks
  • Configuring a Sample Environment
  • Configuring New Integrated Replicat

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

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

9. Editing Configuration Parameters

  • Editing Parameter Files
  • Contrasting GLOBALS versus Process Parameters
  • Configuring GLOBALS Parameters
  • Configuring Manager Parameters
  • Configuring Extract Parameters
  • Configuring Replicat Parameters

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

11. Additional Transformation Concepts

  • Configuring and Using Macros
  • Configuring and Using User Tokens
  • Configuring and Using User Exits
  • Configuring and Using Oracle Sequences

12. Configuration Options

  • Configuring and Using BATCHSQL
  • Configuring and Using Compression
  • Configuring and Using Encryption
  • Configuring and Using Event Actions
  • Configuring New Wallet Security

13. Bidirectional Replication

  • Reviewing Bidirectional Considerations
  • Detecting Loops
  • Avoiding Conflicts
  • Configuring and Using Conflict Detection and Resolution
  • Describing Identity Types Issues

14. DDL Replication

  • Reviewing Data Description Language Replication Overview
  • Configuring and Using Options for DDL Replication
  • Configuring and Using String Substitution in DDL

video-img

Request for Enquiry

assessment_img

Free GoldenGate 12c: Fundamentals Training Assessment

This assessment tests understanding of course content through MCQ and short answers, analytical thinking, problem-solving abilities, and effective communication of ideas. Some Multisoft Assessment Features :

  • User-friendly interface for easy navigation
  • Secure login and authentication measures to protect data
  • Automated scoring and grading to save time
  • Time limits and countdown timers to manage duration.
Try It Now

GoldenGate 12c: Fundamentals Corporate Training

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.


500+
Global Clients
4.5 Client Satisfaction
Explore More

Customized Training

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

Expert
Mentors

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

360º Learning Solution

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

Learning Assessment

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

Certification Training Achievements: Recognizing Professional Expertise

Multisoft Systems is the “one-top learning platform” for everyone. Get trained with certified industry experts and receive a globally-recognized training certificate. Some Multisoft Training Certificate Features :

  • Globally recognized certificate
  • Course ID & Course Name
  • Certificate with Date of Issuance
  • Name and Digital Signature of the Awardee
Request for Certificate

What Attendees are Saying

Our clients love working with us! They appreciate our expertise, excellent communication, and exceptional results. Trustworthy partners for business success.

Share Feedback
  Chat On WhatsApp

+91-9810-306-956

Available 24x7 for your queries