Installation | Replication | Security | Troubleshooting

JOIN WAITLIST

Ready To Take Your Career to Next Level by Learning Dell Boomi? Join now to be the First One To Know When We Open Enrollments. 

Oracle Autonomous Database is the world’s only data management system to automatically patch, upgrade and tune itself. It handles routine database maintenance tasks while the system is running—without human intervention.

It is designed to support all standard SQL and business intelligence (BI) tools and provides all of the performance of the market-leading Oracle Database in an environment that is tuned and optimized for Data Warehouse & Transaction Processing Workload.



Hi, I am Atul Kumar, Oracle ACE & Cloud Expert.
With 20+ years of experience in Cloud Technologies, I help large corporates with the strategy to implement Cloud including Deployment & Migration.

I work on actual implementations and cover Design (High Level, Low Level), Architecture, Implementation, Deployment, and Migration (Lift & Shift)
I have trained more than 2000+ individuals like you and 50+ of corporate clients and have been Oracle University Trainer in past.

What Is Autonomous Database?

Step by Step Hands-On Guides

Module 1: Oracle Cloud Computing Service – Getting Started

Module 2: OCI – Identity and Access Management Service

Module 3: Networking

Module 4: OCI Compute: Bare Metal & Virtual Machine

Module 5: Storage (Block, Object, File Service)

Module 6: Load Balancer Service

Module 7: Launch Database & Advanced Database

Module 8: DNS

A Little Bit About Trainer 

Oracle ACE & Cloud Expert

Atul Kumar

I got Oracle Cloud Certified and I thank Trainer, Atul, and K21Academy for their support at Every Step. Very well structured and practical oriented course material. Absolutely fantastic! Glad that I took this step of getting certified as it makes a lot of difference in the CV if you mention that you have the knowledge of Oracle Cloud Vs that you are Oracle Cloud Certified.

What Students Say About Us

Copyright © 2021 K21 Academy | All rights reserved

Akhilesh Singh

Oracle Cloud Infrastructure Certified

Installation | Replication | Security | Troubleshooting

ENROLL NOW

 What You Will Learn In This Training?

Module 1: Autonomous Database Technical Overview

Module 2: Provisioning & Connectivity

Module 3: Migration & Data Loading into Autonomous Database

Module 4: Managing & Maintaining Autonomous Database

Module 5: Monitoring Autonomous Database

Module 6: Tools, Reporting and Analytics using Autonomous Data Warehouse 

Oracle Autonomous Database is the world’s only data management system to automatically patch, upgrade and tune itself. It handles routine database maintenance tasks while the system is running—without human intervention.

Atul Kumar

A Little Bit About Trainer

Atul Kumar

Author & Cloud Expert

Hi, I am Atul Kumar Oracle ACE & Cloud Expert.
With 20+ years experience in Oracle, I help large corporate with the strategy to implement Cloud including Deployment & Migration.

I work on actual implementations and cover Design (High Level, Low Level), Architecture, Implementation, Deployment, and Migration (Lift & Shift)
I have trained more than 2000+ individuals like you and 50+ of corporate clients and have been Oracle University Trainer in past.

What Is Autonomous Database?

Ready To Take Your Career to Next Level by Learning Oracle Cloud Infrastructure? 

Join now to be the First One To Know When We Open Enrollments.  

ENROL NOW

What our students say about
 K21Academy Course Training Material

AKHILESH SINGH
Oracle Cloud Infrastructure Certified

I got Oracle Cloud Certified and I thank Trainer, Atul, and K21Academy for their support at Every Step. Very well structured and practical oriented course material. Absolutely fantastic! Glad that I took this step of getting certified as it makes a lot of difference in the CV if you mention that you have the knowledge of Oracle Cloud Vs that you are Oracle Cloud Certified.

https://www.linkedin.com/in/akhilesh-singh-59baa11/

Copyright 2019  K21 Academy | Privacy Policy | Terms & Conditions  

Module 9: Advance Networking Concepts

Module 10: Advanced IAM

Module 11: Architecting Best Practices: HA, DR, Use Cases

Module 12: Certification Exam 1Z0-932

Akhilesh Singh

Oracle Cloud Infrastructure Certified

Enter your details below and be the first one to know when the enrollment for the training starts, with Earlybird offers.

What Our Students Say About K21Academy Training Material...

Prasanna Venkatesan Iyer
 Oracle Golden Gate  

I did have a FMW before training with K21 and the experience was encouraging to Enrol for OGG Training. I was about to join new employment requiring Golden Gate Expertise and joining this...READ FULL TESTIMONIAL
Sayantan Chakraborty 
Oracle Golden Gate 
 
K21Academy is one of the best Online Training Portals. Ashish, Amit are really very good trainer for Golden Gate, SSO, OCI, as they explain everything in an easy way. The blog contents on the... READ FULL TESTIMONIAL.
Leon Poyau 
Oracle GoldenGate 
 
I like the zero downtime migration and upgrade feature of Goldengate. This is a most(if not extremely) important feature. It is very attractive to businesses who have a need to most uptime and high availability of the services they provide.I have tremendous amount knowledge, skill set and more importantly confidence with Oracle Goldengate. As a result of the training and support I received from Ashish Argawal and K21Academy, I gained the confidence and knowledge that I needed to ace an initial interview...READ FULL TESTIMONIAL.
sanjukta
Activity Guide I
Step-By-Step Guide to Register for Oracle Cloud Trial Account
Activity Guide III
Create virtual cloud network (VCN), Subnets, Security List, Gateway & Route Table
Activity Guide IV 
Create & Access User Managed Database On OCI
Activity Guide VI
Managing DB System (Start, Stop Scale-Up/Down) & DBCLI
Activity Guide VII
Monitoring Database on OCI using EM Express
Activity Guide VIII
Backup & Restore DB System

Ready To Take Your Career to Next Level by Learning DBA To Oracle Cloud DBA? 

ENROLL NOW !

What You Will Learn In This Training?

Module 1: GoldenGate Architecture, Component & Concepts

Lesson 1:  Oracle Database Architecture
Lesson 2: Competitors, Why GoldenGate and Options
Lesson 3: GoldenGate Architecture Supported Database OS
Lesson 4: Integrated Capture

Activity Guide II
Step-By-Step Guide to Register for Oracle Cloud Trial Account
Activity Guide V
Create Connect Load Data Administer & Autonomous Database
Activity Guide IX
Migrate (Lift & Shift) On-Premise Database to Cloud (OCI)

Course Breakdown

What You Will Learn In This Training?

Step by Step Hands-On Guides

Double-click to edit this text

Module 1: GoldenGate Architecture, Component & Concepts
Lesson 1: Oracle Database Architecture
Lesson 2: Competitors, Why GoldenGate and Options
Lesson 3: GoldenGate Architecture Supported Database OS
Lesson 4: Integrated Capture 


Module 2: Pre-Requisite, Download & Install GoldenGate
Lesson 1: Oracle GoldenGate Download Install
Lesson 2: GoldenGate Directory Structure & GGSCI Manager Process
Lesson 3: Oracle GoldenGate Target Install Configure Manage
Lesson 4: Load Data Source Target Database
Lesson 5: Configure Source Target Pre Requisite


Module 3: Process,Configuration & DML Setup
Lesson 1: GoldenGate Source & Target Database Installation Review
Lesson 2: GGSCI Database Login & Enable Supplemental Logging
Lesson 3: Check and Delete Supplemental Logging Information
Lesson 4: Configure, Capture Process and Register with Database
Lesson 5: Define Local Trail, Data Pump & Remote Trail
Lesson 6: Parameter Files and How to Edit File
Lesson 7: Starting Extract Processes and View Report
Lesson 8: Configure and Start Replicat Process on Target
Lesson 9: Test Replication from Source to Target, Flow and Statistics
Lesson 10: Capture & Replicat process is on the Same Host, What Could be Going on Here? 


Module 4: Parameter, Topologies, Components, Collisions
Lesson 1: Recap Processes and Report File
Lesson 2: GoldenGate Topologies
Lesson 3: GoldenGate Components: Extract, Manager, Replicat, Collector, DataPump & Trail Files
Lesson 4: GoldenGate Parameter Files
Lesson 5: Parameter Description & Other Parameters
Lesson 6: Collision Handling
Lesson 7: Troubleshooting of Insert collision in GoldenGate
Lesson 8: How to Handle Update Collision
Lesson 9: InsertMissing Collision and Delete Collision 


Module 5: Initial Load & Zero Downtime Migration and Upgradation
Lesson 1: Process, Global and OBEY Parameter File
Lesson 2: INITIAL load in GoldenGate
Lesson 3: Why Zero Downtime Upgradation and Migration is Important
Lesson 4: Advantages of Initial Load
Lesson 5: Zero DownTime Upgradtion and Migration 


Module 6: Overview of Data Filtration and Transformation
Lesson 1: Overview of Data Filtration and Transformation
Lesson 2: Goldengate Data Filtration with Where Clause
Lesson 3: Troubleshooting of Data Filtration Where Clause
Lesson 4: Data Filtration with filter clause and Example 


Module 7: Data Transformation using COLMAP & Performance of GoldenGate
Lesson 1: Data Transformation using COLMAP with Hands-on Exercise
Lesson 2: How to Alter Processes In Oracle GoldenGate
Lesson 3: How to Replicate Colum having Different Colum Name
Lesson 4: Hands-on with Oracle GoldenGate Built-in Functions
Lesson 5: Q/A Session
Lesson 6: Capabilities and Syntax of GoldenGate
Lesson 7: Performance Overview of Oracle GoldenGate
Lesson 8: Monitoring the LAG in GoldenGate
Lesson 9: GoldenGate Checkpoints 


Module 8: DDL Replication
Lesson 1: Reviewing Data Description Language & Replication Overview
Lesson 2: Configuring and Using Options for DDL Replication
Lesson 3: Configuring and Using String Substitution in DDL 


Module 9: Bidirectional Replication
Lesson 1: Reviewing Bidirectional Considerations
Lesson 2: Detecting Loops
Lesson 3: Avoiding Conflicts
Lesson 4: Configuring and Using Conflict Detection and Resolution
Lesson 5: Description Identity Types Issues
Lesson 6: Automatic CDR Feature In Bidirectional Replication in GoldenGate 


Module 10: Performance of Oracle GoldenGate – Lag & Checkpoint
Lesson 1: Parameters of Oracle GoldenGate – lag and Checkpoint 

Module 11: Oracle GoldenGate Security
Lesson 1: Overview of Security Option
Lesson 2: Implement security Feature
Lesson 3: Trail_File_Encyption 


Module 12: Troubleshoot Goldengate Issues
Lesson 1: How to Troubleshoot any Issue in GoldenGate 

Module 13: Logdump
Lesson 1: Logdump Overview
Lesson 2: Logdump Open Trail File and Hands-on


Module 14: Data Definition File
Lesson 1: Defgen Utility Overview
Lesson 2: How Defgen Utility Works
Lesson 3: Defgen Generate Source Definition 


Module 15: Upgradation of GoldenGate from 12c to 19c

Module 16: GoldenGate 19c New Features
Lesson 1: GoldenGate Remote Capture Support For Cross Endian Formats 

COURSE BREAKDOWN

A Little Bit About Trainer

Atul Kumar

Oracle ACE

ENROLL NOW!

Oracle ACE & Cloud Expert

Benefits Of K21Academy Membership!

Learn From Basic Concepts

Monthly Subscription Model

Training Variety Added Every Month

Learn Anytime & Anywhere

Step By Step Activity Guides

Bonus Live Sessions

Dedicated Live WhatsApp Group

Pay Now & Get Instant Access To The Course!

Benefits Of K21Academy Membership!

Learn From Basic Concepts

Learn Anytime & Anywhere

Monthly Subscription Model

Variety Of Training Added Every Month

Bonus Live Sessions

Step By Step Activity Guides

Dedicated Live WhatsApp Group 

Pay Now & Get Instant Access Of The Course!

Atul Kumar

Copyright © 2021 K21 Academy | All rights reserved

LIMITED TIME OFFER
Claim Now!

Use Discount Code For Monthly:  EARLY50

Use Discount Code For Yearly:  EARLY

Flat 

TAKE ACTION NOW!

FLAT

LIMITED TIME OFFER
Claim Now!

Module 2: Pre-Requisite, Download & Install GoldenGate

Lesson 1: Oracle GoldenGate Download Install
Lesson 2: GoldenGate Directory Structure & GGSCI Manager Process
Lesson 3: Oracle GoldenGate Target Install Configure Manage
Lesson 4: Load Data Source Target Database
Lesson 5: Configure Source Target Pre Requisite

Module 3: Process,Configuration & DML Setup

Lesson 1: GoldenGate Source & Target Database Installation Review
Lesson 2: GGSCI Database Login & Enable Supplemental Logging
Lesson 3: Check and Delete Supplemental Logging Information
Lesson 4: Configure, Capture Process, and Register with Database
Lesson 5: Define Local Trail, Data Pump & Remote Trail
Lesson 6: Parameter Files and How to Edit File
Lesson 7: Starting Extract Processes and View Report
Lesson 8: Configure and Start Replicat Process on Target
Lesson 9: Test Replication from Source to Target, Flow and Statistics
Lesson 10: Capture & Replicat process is on the Same Host, What Could be Going on Here?

Module 4: Parameter, Topologies, Components, Collisions

Lesson 1: Recap Processes and Report File
Lesson 2: GoldenGate Topologies
Lesson 3: GoldenGate Components: Extract, Manager, Replicat, Collector, DataPump & Trail Files
Lesson 4: GoldenGate Parameter Files
Lesson 5: Parameter Description & Other Parameters
Lesson 6: Collision Handling
Lesson 7: Troubleshooting of Insert collision in GoldenGate
Lesson 8: How to Handle Update Collision
Lesson 9: InsertMissing Collision and Delete Collision

Oracle GoldenGate 19c Administration

PAY MONTHLY

 99  $59

PER MONTH

Recurring payment - cancel anytime in just 
2 clicks of your mouse!

JOIN NOW

PAY ANNUALLY

 899  $499

PER YEAR

BEST VALUE: Save $289 when you join
on an annual subscription!

JOIN NOW

PAY MONTHLY

PER MONTH

Recurring payment - cancel anytime in just 
2 clicks of your mouse

JOIN NOW

$ 99  $59

PAY ANNUALLY

PER YEAR

JOIN NOW

 BEST VALUE: Save $289 when you join
on an annual subscription!

$ 899  $499

PAY MONTHLY

 99  $59

PER MONTH

Recurring payment - cancel anytime in just 
2 clicks of your mouse!

JOIN NOW

PAY ANNUALLY

 899  $499

PER YEAR

BEST VALUE: Save $289 when you join
on an annual subscription!

JOIN NOW

PAY MONTHLY

PER MONTH

Recurring payment - cancel anytime in just 
2 clicks of your mouse

JOIN NOW

$ 99  $59

PAY ANNUALLY

PER YEARLY

JOIN NOW

 BEST VALUE: Save $289 when you join
on an annual subscription!

$ 899  $499

Flat 

Atul Kumar

Author & Cloud Expert

Oracle GoldenGate 19c Administration

Module 5: Initial Load & Zero Downtime Migration and Upgradation

Lesson 1: Process, Global, and OBEY Parameter File
Lesson 2: INITIAL load in GoldenGate
Lesson 3: Why Zero Downtime Upgradation and Migration is Important
Lesson 4: Advantages of Initial Load
Lesson 5: Zero DownTime Upgradtion and Migration

Module 6: Overview of Data Filtration and Transformation

Lesson 1: Overview of Data Filtration and Transformation
Lesson 2: Goldengate Data Filtration with Where Clause
Lesson 3: Troubleshooting of Data Filtration Where Clause
Lesson 4: Data Filtration with filter clause and Example

Module 7: Data Transformation using COLMAP & Performance of GoldenGate

Lesson 1: Data Transformation using COLMAP with Hands-on Exercise
Lesson 2: How to Alter Processes In Oracle GoldenGate
Lesson 3: How to Replicate Colum having Different Colum Name
Lesson 4: Hands-on with Oracle GoldenGate Built-in Functions
Lesson 5: Q/A Session
Lesson 6: Capabilities and Syntax of GoldenGate
Lesson 7: Performance Overview of Oracle GoldenGate
Lesson 8: Monitoring the LAG in GoldenGate
Lesson 9: GoldenGate Checkpoints

Module 8: DDL Replication

Lesson 1: Reviewing Data Description Language & Replication Overview
Lesson 2: Configuring and Using Options for DDL Replication
Lesson 3: Configuring and Using String Substitution in DDL

Module 9: Bidirectional Replication

Lesson 1: Reviewing Bidirectional Considerations
Lesson 2: Detecting Loops
Lesson 3: Avoiding Conflicts
Lesson 4: Configuring and Using Conflict Detection and Resolution
Lesson 5: Description Identity Types Issues
Lesson 6: Automatic CDR Feature In Bidirectional Replication in GoldenGate

Module 10: Performance of Oracle GoldenGate – Lag & Checkpoint

Lesson 1: Parameters of Oracle GoldenGate – lag and Checkpoint

Module 11: Oracle GoldenGate Security

Lesson 1: Overview of Security Option
Lesson 2: Implement security Feature
Lesson 3: Trail_File_Encyption

Module 12: Troubleshoot Goldengate Issues

Lesson 1: How to Troubleshoot any Issue in GoldenGate

Module 13: Logdump

Lesson 1: Logdump Overview
Lesson 2: Logdump Open Trail File and Hands-on

Module 14: Data Definition File

Lesson 1: Defgen Utility Overview
Lesson 2: How Defgen Utility Works
Lesson 3: Defgen Generate Source Definition

Module 15: Upgradation of GoldenGate from 12c to 19c

Module 16: GoldenGate 19c New Features

Lesson 1: GoldenGate Remote Capture Support For Cross Endian Formats