Oracle Goldengate 19c Learn and Master Oracle Goldengate
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
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 Replicat2. Bidirectional auto CDR3. Heartbeat table4. PMSRVR5. Troubleshooting strategies6. Goldengate security wallet
Overview
Section 1: Introduction,installation of Oracle Goldengate & Different Architectures
Lecture 1 Introduction, Overview, Different Types Of Architecture and extract and replicat
Lecture 2 Oracle Goldengate Installation – Preparation and getting ready
Lecture 3 Oracle Goldengate GUI and Silent installation and where to install Goldengate
Section 2: Oracle Goldengate replication setup -Prerequisites and Configuration
Lecture 4 Preparing Databse for OGG setup and meeting DB prerequisites to setup Goldengate
Lecture 5 What is Supplem,ental Logging – Importance and how to add OGG Credentialstore
Lecture 6 Setting up OGG Processes – Create extract, Pump and Replicat for replication
Section 3: Introduction to Troubleshooting technques in OGG and process Data Flow
Lecture 7 OGG process Data Flow, Troubleshooting commands & Understanding info all output
Lecture 8 OGG Troubleshooting Tips and techniques and Topologies of OGG
Lecture 9 Goldengate process status, trail file switchover & Parameter file Golden Rules
Section 4: All about Goldengate parameters and Parameter files
Lecture 10 Different Parameters of Oracle Goldengate and learning how to Handle Collisions
Lecture 11 Manager Parameters- Autostart and Autorestart and demo of HANDLECOLLISIONS
Section 5: Initial Load using OGG and how to approach and strategize troubleshooting issues
Lecture 12 OGG Components and Performing Initial Load – File to Replicat
Lecture 13 Oracle Goldengate Common Issues – Troubleshooting, Approach & Strategy
Section 6: Zero Downtime Upgradation & Migration Strategy & Data Filteration in OGG
Lecture 14 Zero Downtime Upgradation & Migration and Data filteration using WHERE clause
Lecture 15 Data Filteration using FILTER Clause and GG builtin function
Section 7: Data Transformation, GG with Informatica, Parallel Replicat and OGG Lag
Lecture 16 Add a new Table in existing GG config, Data Transformation & Parallel Replicat
Lecture 17 Convert UPDATE to DELETES, GG with ODI/Informatica and Monitoring OGG Lag
Section 8: OGG New features Automatic Heartbeat Table and Performance Metrics Server
Lecture 18 OGG Automatic Heartbeat table and Performance Metrics Server (PMSRVR)
Section 9: OGG Checkpoint, Configuring Security in OGG, DDL Replication and Logdump
Lecture 19 OGG Checkpoint and OGG Security features – Trail file encryption and CMDSEC
Lecture 20 DDL Replication using OGG and how to read trail files using Logdump utility
Section 10: OGG Bbidirectional Replication and Bidirectional Auto CDR ,OGG 19c new features
Lecture 21 OGG 19c New_Features, GG_Bidirectional Setup, Add description to OGG processes
Lecture 22 Bidirectioanl Automatic Conflict Detection and Resolution – Auto CDR
Section 11: OGG Performance Tuning, OGG Macros, OGG Include_Files and using Obey Command
Lecture 23 OGG Performance Tuning, OGG Macros, OGG Include_Files and using Obey Command
Administrator,Database Administrator,Implementer,System Integrator,Systems Administrator,Analyst,Architect,Developer,DBAs,Goldengate Administrators,technologists
Course Information:
Udemy | English | 23h 12m | 9.70 GB
Created by: Ashish Agarwal
You Can See More Courses in the IT & Software >> Greetings from CourseDown.com