Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Oracle Goldengate 12c
Highest Rated
Rating: 4.6 out of 5(2,178 ratings)
9,130 students

Oracle Goldengate 12c

Oracle Goldengate
Created byAshish Agarwal
Last updated 5/2021
English

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

Course content

3 sections22 lectures20h 56m total length
  • Introduction to oracle Goldengate and Architecture of Oracle Goldengate56:55

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

  • Installation of Oracle Goldengate and Prerequisites to setup the replication59:44

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

  • DML Replication using Oracle Goldengate - Online Change Synchronization1:22:42

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

  • Description of ggserr.log and how to view report files1:06:59

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

  • Configuring and Comprehending Parameters of Oracle Goldengate1:01:47

    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.

  • Implementing Parameters and editing parameter files in Oracle Goldengate58:56

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

  • Avoiding collisions in Oracle Goldengate using HANDLECOLLISIONS50:56

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

  • Oracle Goldengate Capablities - Broadcast, Data Warehouse44:24

    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

  • Concepts and Components of Oracle Goldengate54:54

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

  • Strategy Zero Downtime Migration and Upgradation using OGG and OGG Initial Load1:07:09

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

  • Alter processes based on SCN, Timestamp and logs48:24

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

  • Performing Data Filteration in Oracle Goldengate1:01:41

    The session guides how to perform data filteration using Oracle Goldengate

  • Data Transformation and using COLMAP in Oracle Goldengate56:20

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

  • Covert deletes into updates and usage of Oracle Goldengate builtin functions46:10

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

  • Oracle Goldengate Performance - Monitoring Lag and Goldengate Checkpoint1:03:02

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

  • Bidirectional Replication using Oracle Goldengate1:04:11

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

  • DDL Replication and Oracle Goldengate Security1:01:51

    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

  • Logdump Utility - How to read trail files56:55

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

  • Goldengate on RAC - Strategy ,Goldengate Macors and Include FIle1:25:22

    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.

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