Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Introduction to Oracle 12c Golden Gate for absolute beginner
Rating: 4.0 out of 5(129 ratings)
3,462 students

Introduction to Oracle 12c Golden Gate for absolute beginner

Setup your first single table replication using Oracle Golden Gate using the lab setup provided inside the course
Created byArun Kumar
Last updated 7/2018
English

What you'll learn

  • Install and configure Oracle 12c Golden Gate for Oracle database replication
  • Configure simple single table replication
  • Explain the difference between classic vs integrated capture
  • Explain Oracle Golden Gate architecture
  • Lean the difference between Oracle Data Guard vs Oracle Golden Gate

Course content

1 section9 lectures10h 53m total length
  • Before you start0:18
  • Introduction to Golden Gate1:23:47

    Explore Oracle Golden Gate as a real-time, heterogeneous data replication solution enabling cross-platform integration and bidirectional replication; learn prerequisites and setup for hands-on practice.

  • Golden Gate architecture1:53:46

    Explore the architecture of Oracle GoldenGate, including capture, data pump, and replicate components; compare integrated and classic capture, perform initial loads, and manage checkpoints for reliable replication.

  • Setup your practice lab at home1:41:46

    Set up your home practice lab for Oracle Golden Gate by importing two Oracle Linux virtual machines, configuring networking, and installing the quality database to practice replication.

  • Installing Oracle 12c Golden Gate on your practice lab2:19:24

    Install and configure Oracle GoldenGate 12c in a practice lab, including creating databases, enabling database-level supplemental logging, and setting up the manager and initial extract and data pump processes.

  • First single table oracle to oracle replication1:27:04

    Master the setup of a basic Oracle GoldenGate replication of a single table between two identical databases, including supplemental logging and end-to-end extract, pump, and replicate configuration.

  • Navigating Oracle Golden Gate1:41:22

    Navigate Oracle Golden Gate and learn to interpret process status, alert logs, and checkpoint mechanics; inspect parameter, report, and trail file directories to troubleshoot replication pipelines.

  • Before you exit0:18
  • Bonus Lecture25:45

    Master Oracle Golden Gate with a beginner-friendly master class that teaches lab-at-home setup, first replication, and performance tuning through real-time hybrid projects across Oracle, MySQL, and SQL Server.

Requirements

  • Oracle Database Administration
  • Oracle Virtual Box to setup lab at home

Description

Oracle Golden Gate is the best replication technology available in the market. It supports a wide variety of popular database platforms. Oracle Golden Gate being a robust replication technology, makes it A MUST LEARN technology for Database Administrators.

This video course focuses more on practice side of Oracle Golden Gate and is designed specifically for Oracle DBAs.

  • Install and configure Oracle 12c Golden Gate for Oracle database replication
  • Configure unidirectional and bidirectional replication
  • Explain the difference between classic vs integrated capture
  • Improve Golden Gate performance and troubleshoot common issues
  • Configure high availability using Oracle Golden Gate
  • Perform Oracle Golden Gate upgrade
  • Configure Oracle to MYSQL replication
  • Configure MS-SQL Server to Oracle replication
  • Prepare for Oracle Golden Gate interview

This video course is designed for Oracle DBAs who want to lean Oracle Golden Gate for configuring replication or job change but struggles to start learning and prepare a practice environment at home

Who this course is for:

  • Database administrators willing to lean Oracle 12c Golden Gate
  • Oracle DBA, MySQL DBA, MS SQL Server DBAs who want to learn database replication
  • Any other IT administrator to understand how Database replication works