Oracle Goldengate 12c
4.4 (916 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,732 students enrolled

Oracle Goldengate 12c

Oracle Goldengate
Bestseller
4.4 (916 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,732 students enrolled
Created by Ashish Agarwal
Last updated 10/2019
English
Price: $139.99
30-Day Money-Back Guarantee
This course includes
  • 19.5 hours on-demand video
  • 1 article
  • 32 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Installaton of Oracle Goldengate
  • Architecture of Oracle Goldengate - Process Data Flow
  • Implementation and Configuration of Goldengate processes - Integrated and Classic modes
  • Configure unidirectional and bidirectional setup
  • Goldengate on RAC - Strategy and Installation
  • Logdump utility
  • Zero Downtime migration and upgradation using Oracle Goldengate
  • DDL Replication
  • Troubleshooting strategy
  • Understanding and Configuration of Parameter files
  • HANDLECOLLISIONS
  • Data Filteration and Transformation
  • Goldengate Macros
  • Include File in Goldengate
Requirements
  • We assume the audience have the basic knowledge of the Oracle Database Administration fundamentals.
  • Database developers and data integration specialist could also benefit from this course
Description

Learn Oracle Goldengate and be Oracle Goldengate Specialist..

  The course contains the topics from basics to advanced level. The course is designed in such a way that it caters to everyones need. The course is descriptive and practical. The course will help you in achieving expertise on Oracle Goldengate.

With this course you will learn:

  • Oracle Goldengate Architecture

  • Oracle Goldengate Introduction,Download and Installation 

  • Strategizing Goldengate on RAC

  • Set up a unidirectional and bidirectional replication

  • Understanding Parameter files

  • Perform data filteration and transformation

  • Implementing DDL Replication

  • Implement integrated Extract 

  • Implementing Integrated Replicat

  • Strategy for Monitoring and troubleshooting an Oracle GoldenGate configuration,

  • Configuring Oracle Goldengate security to meet customer needs

  • Understanding and Configuring Oracle Goldengate Parameter Files

  • Preparing for the interview

  • Test cases

  • Oracle Goldengate 12c new features

  • Hands on Activity Guides

  • Interview Questions for GG

  • Upgrade and patching

  • guidance for Certification

Post the completion of this course attend the Goldengate certification course (Certification Oracle Goldengate Implementation Essentials) from Ashish Agarwal and be Oracle Goldengate certified. So u will have expertise and certification both with this and certification course!


Content and Overview 

This course is suitable for for Database Administrators and Developers., The course has descriptive and demonstrated 18 hours video sessions which will help you learn Oracle GoldenGate 12c fundamentals. The lectures are supported with exercises and documentations.

The course starts with description of Oracle Goldengate Architecture and installation of Oracle Goldengate on Linux Platform. The course has a wonderful presentation on all the topics including parameter files of Oracle Goldengate. The course also guides you on how to crack the interview. With the course you get Goldengate Interview Q and A.  Also you can get the guide to setup the lab with this course.

This course give you the chance to grab the oppurtunity to work with instructor with such a wide experience and gaining real time scenarios.

Upon completing this course, you will be able to configure Oracle Goldengate and support Goldengate in customer environment. So, come join in the amazing journey of learning this hot technology.

Who is the target audience?

  • Database Administrators

  • Database Analysts

  • Solution Architects

  • Technical Architects

  • Database Architects

  • Configuration Consultant

  • Data Warehouse Administrator

  • Data Warehouse Analyst

  • Data Warehouse Developer

  • Database Administrators

  • Database Designers

  • System Integrator

  • Technical Consultant


Who this course is for:
  • DBA's
  • Developers
  • Solution Architects
  • Database Administrators
  • Data Architects
  • Data Replication
  • Disaster Recovery
Course content
Expand all 21 lectures 19:23:42
+ Course lectures and guides
19 lectures 19:08:22

The lecture includes Introduction to Oracle Goldengate and Architecture of Oracle Goldengate

Preview 56:55

The lecture will help students to Install Oracle Goldengate 12c and Prerequisites required to setup the Goldengate replication.

Preview 59:44

The session will help students in configuring Goldengate replication. This will guide you how to create Extract,Data pump and Replicat processes.

DML Replication using Oracle Goldengate - Online Change Synchronization
01:22:42

The lecture will guide how to approcach a issue in Goldengate. The section will help in developing the troubleshooting strategy in learners mind..

Description of ggserr.log and how to view report files
01:06:59

Goldengate Parameters files are the heartbeat of Oracle Goldengate. The lesson will guide how to configure new Prameter file or how to understand existing Parameter file. This will help both Goldengate developers and the ones who are supporting oracle Goldengate environment.

Configuring and Comprehending Parameters of Oracle Goldengate
01:01:47

The lecture is handon describing how to edit existing file or how to view the parameter file for Goldengate processes.

Implementing Parameters and editing parameter files in Oracle Goldengate
58:56

The lecture will help students in understanding the collisions and how to avoid the collisions using HANDLECOLLISIONS parameter.

Avoiding collisions in Oracle Goldengate using HANDLECOLLISIONS
50:56

The lecture will help how to use Goldengate capablities. the section will help in developing concepts regarding one-one replication, one-many replication and many-one replication

Oracle Goldengate Capablities - Broadcast, Data Warehouse
44:24

The lecture details the concepts and components involved in Goldengate Configuration.

Concepts and Components of Oracle Goldengate
54:54

The session will help student in developing the strategy for zero downtime migration and up-gradation using Oracle Goldengate. 

Strategy for Zero Downtime Migration and Upgradation using Oracle Goldengate
01:07:09

After the lession student will have the knowledge on how to alter the Goldengate processes based on Timestamp,SCN and logs.

Alter processes based on SCN, Timestamp and logs
48:24

The session guides how to perform data filteration using Oracle Goldengate

Performing Data Filteration in Oracle Goldengate
01:01:41

The session helps in developing the concept of Data Transformation using Oracle Goldengate as per business need

Data Transformation and using COLMAP in Oracle Goldengate
56:20

The session describes how to use Goldengate functions in Goldengate environment and converting deletes into update statement.

Covert deletes into updates and usage of Oracle Goldengate builtin functions
46:10

The session helps in understanding how Goldengate performance is measured and how to achieve maximum performance of Oracle Goldengate.

Oracle Goldengate Performance - Monitoring Lag and Goldengate Checkpoint
01:03:02

At the end of this session student will have understanding on how to setup Bidirectional setup using Oracle Goldengate

Bidirectional Replication using Oracle Goldengate
01:04:11

At the end of this session students will be able to Implement DDL Replication using Oracle Goldengate. Also the session describes method of implementing security in Goldengate Environment

DDL Replication and Oracle Goldengate Security
01:01:51

The session helps in understanding how to read trail files and what is defgen.

Logdump Utility - How to read trail files
56:55

The lecture discusses on strategy related to Goldengate setup on RAC. Also we have discussed regarding Goldengate Macros and Goldengate include files as well. At the end of the session we have taken question and answers of the students and also there is feedback available as well.

Goldengate on RAC - Strategy ,Goldengate Macors and Include FIle
01:25:22
+ Post course completion guidance
2 lectures 15:20

in the session we have discussed regarding what to learn next. Future of Oracle Goldengate, Other courses being offered by the trainer and what more to learn for becoming Goldengate technology master.

Preview 10:04
Oracle Goldengate Interview Q and A
05:16

Test your Oracle GOldengate learning

Testing the Oracle Goldengate knowledge
3 questions