Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Oracle Goldengate 19c - Learn and Master Oracle Goldengate

Name: Oracle Goldengate 19c - Learn and Master Oracle Goldengate
Rating: 4.5 (946 reviews)

Professionally learn to design & implement Goldengate setup for ur customer & enterprise

Created byAshish Agarwal

Last updated 6/2024

English

What you'll learn

Latest and Master Oracle Goldengate Version 19c with practicals and realtime activites
Install and Download Oracle GoldenGate 19c in realtime - Decide where to Install oracle Goldengate
Issue GGSCI commands.
What are the different architectures of Goldengate and how to setup Replication
Realtime Activities to setup Oracle Goldengate processes
Configure, start, stop and monitor Change Capture and Delivery processes in Realtime
Manage Extract trails, Remote trails and files using Data Pump and Replicat
How to design and analyse Oracle Goldengate for your projects - Things to consider and how to do seggregation
Prerequisites to download and setup Oracle Goldengate 19c
How to check Oracle Goldengate Certification matrix
Comprehend and Create Goldengate process parameter files
Different types of extracts and Replicats available for configuration in 19c
Oracle Goldengate how to perform Silent Installation
Setting up Oracle database and preparing source and target database for Goldengate Replication
Oracle Goldengate 19c New features
Oracle Goldengate 19c: Troubleshooting - OGG common issues troubleshooting,approach and strategy
Oracle Goldengate 19c: Tuning - Perform tuning of Manager, Extract and Replicate.
Identify what causes slow startups.
Monitor lag and statistics.
Oracle Goldengate Bidirectional Replication- Setup in realtime with considreations and things to keep in mind
Bidirectional Auto CDR - Oracle Goldengate new feature-
Diagnose and tune the Integrated Extract and Integrated Replicat and usage and benefits
Parallel Replicat - Oracle Goldengate new feature setup in realtime and usage and benefits
Heartbeat Table - Oracle Goldengate new feature setup in realtime and usage and benefits
Performane Matrix server(PMSRVR)- Oracle Goldengate new feature setup in realtime and usage and benefits
DDl Replication setup in realtime and usage and benefits
What is Supplemental logging - benefits and usage
Create Oracle Goldengate Credential Store
Goldengate architecture and Process data flow
Difference between Time since Checkpoint and Lag at Checkpoint
Goldengate process status and trail file switchover scenarios
How to autostart Goldengate processes realtime
Oracle Goldengate concepts and components
Oracle Goldengate Initial Load and File to Replicat initial load in realtime
Zero downtime upgradation and migration Strategy
Realtime usage and benefits to show how GG could be used as business intelligence tool along with informatica/ODI
Data Filteration and transformation
How to add new table into already running OGG configuration
Oracle Goldengatesecurity in realtime and how to perform trail file Encryption
How to read Goldengate trail files using Logdump utility in realtime
How to put description to Oracle Gldengate new and existing processes
Oracle Goldengate Macros,Obey Files and Include Files
Special sessions on project activites, how to HANDLE Collisions and different parameters
Enabling Command Line security

Course content

12 sections • 24 lectures • 23h 53m total length

Introduction, Overview, Different Types Of Architecture and extract and replicat1:04:33
In Day1 of Oracle GOldengate Classic Architecture training you will learn below:
A. Introduction to goldengate architecture
B. Types of Golden Gate architecture:
C. Why Goldengate?
D. Types of Extract Processes
E. Types of Replicat Processes
Oracle Goldengate Installation - Preparation and getting ready1:02:58
In this lecture you will learn below:
A. Oracle Goldengate Architecture - How data flows in Goldengate?
B. Before proceeding to installation:
i. How to check certification matirx
ii. Decide where to install
iii. Allocating space for GG Installation
Oracle Goldengate GUI and Silent installation and where to install Goldengate55:04
In this lecture you will learn below:
A. Oracle Goldengate GUI and Silent Installation
B. how to invoke GGSCI
C. What is Manager Process
D. Oracle Goldengate Processes
E. Options to Install Goldengate

Preparing Databse for OGG setup and meeting DB prerequisites to setup Goldengate56:16
In this lecture you will learn:
A. Pre-requisites for Goldengate Replication
B. Create Database for Goldengate replication
C. Creating Users and tables for Replication purpose
What is Supplem,ental Logging - Importance and how to add OGG Credentialstore55:52
In this lecture you will learn about below:
A. What & Why Supplemental Logging?
B. Types of Supplemental Logging
C. How to connect to database using GGSCI
D. OGG Credential Store
--What is Credentialstore
--How to add Credentialstore
Setting up OGG Processes - Create extract, Pump and Replicat for replication1:06:27
In this session u will learn below:
A. Create/define EXTRACT or CAPTURE process (Primary Extract Process)
B. Register extract process with database
C. Create/define pump process (Secondary Extract process)
D. Create replicat process on target
E. Goldengate process data flow

OGG process Data Flow, Troubleshooting commands & Understanding info all output56:35
In this lecture you will learn regarding below:
A. How Goldengate process data flow
B. How to checkk statistics of OGG processes
C. Few commands to note while doing the troubleshooting
D. How to make changes to parameter files
E. Difference between Time since CHPT and LAG At CHKPT
OGG Troubleshooting Tips and techniques and Topologies of OGG56:20
In this lecture you will learn :
A. oracle Goldengate troubleshooting tips and techniques
B. How to regenrate a trail file
C. Oracle Goldengate topologies
D. How to alter the processes in Goldengate
E. What is CSN in Goldengate
Goldengate process status, trail file switchover & Parameter file Golden Rules1:03:28
In this lecture you will learn below:
A. OGG Processes different status
B. Trail filse switchover scenarios
C. Strategy to follow to troubleshoot abended processes
D. OGG Parameter file rules

Different Parameters of Oracle Goldengate and learning how to Handle Collisions59:39
in this lecture you will learn below:
A. DML related parameters
B. Table truncate parameter
C. Collision related parameters
Manager Parameters- Autostart and Autorestart and demo of HANDLECOLLISIONS54:13
In this lecture you will learn below:
A. How to Auto start/restart the processses using manager process
B. How to perform Housekeeping of old trail files
C. Information related to parameters at GGSCI
D. Type of COLLISIONS

OGG Components and Performing Initial Load - File to Replicat55:04
In this lecture you will learn:
A. How to perform initial Load
B. Options available for Initial load.
C. Types of Goldengate initial load
D. Components of Oracle Goldengate Classic Architecture
Oracle Goldengate Common Issues - Troubleshooting, Approach & Strategy28:52
In this lecture you will learn below:
A. Goldengate Common issues:
B. Classification of Common Issues in golden gate :
C. How to troubleshoot issues in Goldengate
D. how to approach any issue in Goldengate

Zero Downtime Upgradation & Migration and Data filteration using WHERE clause51:42
In this lecture you will learn below:
A. Zero downtime Upgradation and migration strategy
B. Introduction to Data Filtration and Transformation
C. Goldengate built-in functions
Data Filteration using FILTER Clause and GG builtin function51:46
In this lecture you will learn below:
A. Data Filteration using FILTER Clause
B. Usage of Builtin Funstions in parameter Files
C. Using ONINSERT,ONUPDATE and ONDELETE in filter clause

Add a new Table in existing GG config, Data Transformation & Parallel Replicat1:05:48
In this lecture you will learn below:
A. How to add a new table in existing GG configuration
B. Column Mapping Overview
C. OGG Parallel Replicat
D. Types of Parallel Replicat
Convert UPDATE to DELETES, GG with ODI/Informatica and Monitoring OGG Lag1:01:05
In this lecture you will learn below:
A. OGG exercise on how to convert updates to Deletes
B. OGG Performance based on LAG
C. Monitoring OGG Lag

OGG Checkpoint and OGG Security features - Trail file encryption and CMDSEC1:01:09
In this lecture you will learn below:
A. How Goldengate ensures data Integrity using OGG Checkpoint
B. GoldenGate Security Features
C. Command-level Security
DDL Replication using OGG and how to read trail files using Logdump utility1:12:41
In this lecture you will learn below:
A. DDL Replication
B. LOGDUMP utility
C. Some useful commands in logdump utility

OGG 19c New_Features, GG_Bidirectional Setup, Add description to OGG processes1:18:44
in this lecture you will learn below:
A. Bidirectioanl Replication:
B. Preventing Data Looping
C. Bidirection replication Types
D. OGG Process description
Bidirectioanl Automatic Conflict Detection and Resolution - Auto CDR1:13:29
In this lecture you will learn below:
A. Automatic Conflict Detection and Resolution
B. Auto CDR-Requirements
C. Auto CDR - Configuration
D. Auto CDR- Types

Requirements

Basic knowledge of database architecture
Familiarity with Linux Basics
Familiarity with SQl Basics

Description

Oracle Goldengate 19c is the latest version of Oracle Goldengate with lot of new features and advantages. The new features include robustness,security,performance and loads of new features. This course is complete course which starts from download and installation of Goldengate and covers advanced topics.

I created this course because I want to encourage you to learn and build career in Goldengate. I want you to be an expert in Goldengate. Contrary to what we are being told and even technical "gurus", learning Goldengate is not difficult. Its very easy. Creating this course has been a journey - a journey of delivering my knowledge I've carried about Goldengate for a long time. i want to emphasise learning Goldengate is easy and being a Goldengate expert is not that tough. it just need some guidance,mentorship and practise. This course has all ingredients to make you learn Goldengate and pave your path towards becoming Goldengate expert.

This is the course with realtime activity course focussing on practicals. This course will make you interview ready and job ready. My assurance is at the end of the training you will be able to setup, manage,troubleshoot,configure Goldengate on ur own as well as able to provide solutions related to Goldengate on ur own to ur customer. If you are starting you carerr in Goldengate or new to Goldengate this is the correct course to pursue. Also if u have done my 12c course still there are lot of new topics introduced with this training.It is highly recommended that you enroll for this course. this course has all the topics. This is the best course available related to Goldengate.

The course is designed to meet best learning experience. With each session of the course you get notes/recap of the session and what practical implementaion to follow prior to next session to get you ready. With the course you get step by step activity guides,whatsapp group support and for any technical issues I am just an email away.

The course Oracle GoldenGate 19c training will help you gain a strong foundation as well as expertise in implementing Oracle GoldenGate solutions. The course will deep dive into Oracle Goldengate architecture, parameters, mapping, transformations, and much more with real-time examples. You’ll also gain hands-on expertise with the help of Oracle GoldenGate training. There are many new topics included in training:

1. Parallel Replicat

2. Bidirectional auto CDR

3. Heartbeat table

4. PMSRVR

5. Troubleshooting strategies

6. Goldengate security wallet

Who this course is for:

Administrator
Database Administrator
Implementer
System Integrator
Systems Administrator
Analyst
Architect
Developer
DBAs
Goldengate Administrators
technologists

Oracle Goldengate 19c - Learn and Master Oracle Goldengate

What you'll learn

Explore related topics

Course content

Introduction,installation of Oracle Goldengate & Different Architectures3 lectures • 3hr 3min

Oracle Goldengate replication setup -Prerequisites and Configuration3 lectures • 2hr 59min

Introduction to Troubleshooting technques in OGG and process Data Flow3 lectures • 2hr 56min

All about Goldengate parameters and Parameter files2 lectures • 1hr 54min

Initial Load using OGG and how to approach and strategize troubleshooting issues2 lectures • 1hr 24min

Zero Downtime Upgradation & Migration Strategy & Data Filteration in OGG2 lectures • 1hr 43min

Data Transformation, GG with Informatica, Parallel Replicat and OGG Lag2 lectures • 2hr 7min

OGG New features Automatic Heartbeat Table and Performance Metrics Server1 lecture • 1hr 3min

OGG Checkpoint, Configuring Security in OGG, DDL Replication and Logdump2 lectures • 2hr 14min

OGG Bbidirectional Replication and Bidirectional Auto CDR ,OGG 19c new features2 lectures • 2hr 32min

Requirements

Description

Who this course is for: