Oracle Goldengate 12C Fundamentals

Become professional at configuring and implementing Oracle GoldenGate in the Enterprise (upgrade to 19c included)

What you'll learn

Install Oracle GoldenGate

Configure unidirectional and bidirectional replication

Implement classic and integrated Oracle GoldenGate processes

Perform data filtering and manipulation

Implement encryption in Oracle GoldenGate

Monitor Oracle GoldenGate using GGSCI and SQL

Use LogDump utility

Troubleshoot an Oracle GoldenGate configuration

Apply Oracle GoldenGate Patches

Requirements

Familiarity with Oracle Database and basic SQL

Familiarity with Linux basics

Description

Learn how to build, manage, monitor, and troubleshoot an Oracle GoldenGate configuration.Upgrade to Oracle GoldenGate 19c IncludedNot only the course will demonstrate the concepts for you, you will also gain practical experience on implementing the them.
Set up a unidirectional and bidirectional replicationPerform data filtering and manipulationImplementing DDL ReplicationImplement integrated processesImplementing Coordinated ReplicatMonitor and troubleshoot an Oracle GoldenGate configuration,Implement the security optionsApply Oracle GoldenGate patchesContent and Overview Suitable for Oracle Database Administrators, through this course of 42 lectures and more than 10 hours of video-based sessions, you’ll learn all of the Oracle GoldenGate 12c fundamentals. After every concepts lecture, you will implement a hands-on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents.Starting with introducing Oracle GoldenGate, this course will take you all the away from installing the software on a Linux platform, building up a unidirectional and bidirectional configurations, managing an Oracle GoldenGate configuration, up to applying the patch sets.This is an opportunity for the students to gain practical  experience from the author who has implemented a number of Oracle GoldenGate projects in real life.Upon completing this course, you will be able to build up an Oracle GoldenGate configuration that  works in real life scenario.Join the author in this learning journey to gain the knowledge on this amazing technology!

Overview

Section 1: Introducing the Oracle GoldenGate 12c Fundamentals course

Lecture 1 Introducing the Course

Section 2: Starting with Oracle GoldenGate

Lecture 2 Introduction to Oracle GoldenGate

Lecture 3 Oracle GoldenGate Architecture

Lecture 4 Practice 1 Preparing the Practice Environment

Lecture 5 Installing Oracle GoldenGate

Lecture 6 Practice 2 Installing Oracle GoldenGate

Section 3: Implementing Unidirectional Replication

Lecture 7 Preparing Oracle GoldenGate Environment (Part 1 of 2)

Lecture 8 Preparing Oracle GoldenGate Environment (Part 2 of 2)

Lecture 9 Practice 3 Preparing the Environment for GoldenGate

Lecture 10 Implementing Initial Load

Lecture 11 Practice 4 Implementing Initial Load (Part 1 of 2)

Lecture 12 Practice 4 Implementing Initial Load (Part 2 of 2)

Lecture 13 Configuring Change Capture

Lecture 14 Configuring Change Delivery

Lecture 15 Practice 5 Configuring Change Synchronization Part I

Lecture 16 Practice 6 Configuring Change Synchronization Part II

Lecture 17 Practice 7 Starting up and Shutting Down the Systems

Section 4: Monitoring Oracle GoldenGate Configuration

Lecture 18 Monitoring Oracle GoldenGate

Lecture 19 Practice 8 Monitoring Oracle GoldenGate

Lecture 20 Using LOGDUMP Utility

Lecture 21 Practice 9 Using LOGDUMP Utility

Section 5: Data Filtering and Manipulation

Lecture 22 Data Filtering and Manipulation Part I

Lecture 23 Practice 10 Implementing Data Filtering and Manipulation Part I

Lecture 24 Data Filtering and Manipulation Part II

Lecture 25 Practice 11 Implementing Data Filtering and Manipulation Part II

Section 6: More Oracle GoldenGate Configurations

Lecture 26 Using Macros and User Tokens

Lecture 27 Practice 12 Using Macros and User Tokens

Lecture 28 More Configuration Options

Lecture 29 Practice 13 Using Event Marker System

Lecture 30 Encryption in Oracle GoldenGate

Lecture 31 Practice 14 Implementing Encryption in Oracle GoldenGate

Lecture 32 Implementing Integrated Processes

Lecture 33 Practice 15 Implementing Integrated Processes

Lecture 34 Implementing Coordinated Replicat

Lecture 35 Practice 16 Implementing Coordinated Replicat

Section 7: Implementing DDL Replication

Lecture 36 Implementing DDL Replication

Lecture 37 Practice 17 Implementing DDL Replication

Section 8: Implementing Bidirectional Replication

Lecture 38 Bidirectional Replication Part I

Lecture 39 Bidirectional Replication Part I (continue)

Lecture 40 Bidirectional Replication Part II

Lecture 41 Bidirectional Replication Part II (continue)

Lecture 42 Practice 18 Setting up Bidirectional Replication ( Part 1 of 2 )

Lecture 43 Practice 18 Setting up Bidirectional Replication ( Part 2 of 2 )

Lecture 44 Handling Errors

Lecture 45 Practice 19 Using Exceptions Table

Section 9: Oracle GoldenGate Maintenance

Lecture 46 Troubleshooting Oracle GoldenGate

Lecture 47 Practice 20 Applying Oracle GoldenGate Patch Sets

Section 10: Oracle GoldenGate Further Learning

Lecture 48 More About Oracle GoldenGate

Section 11: Upgrading Oracle GoldenGate to 19c

Lecture 49 Upgrading Oracle GoldenGate to 19c

Lecture 50 Practice 21 Upgrading Oracle GoldenGate to 19c ( 1 of 3)

Lecture 51 Practice 21 Upgrading Oracle GoldenGate to 19c ( 2 of 3)

Lecture 52 Practice 21 Upgrading Oracle GoldenGate to 19c ( 3 of 3)

Section 12: Using GG in Oracle PDBs and Upgrading Databases with Nearly Zero Downtime

Lecture 53 Using Oracle GoldenGate in a Multitenant Container Database (part 1 of 2)

Lecture 54 Using Oracle GoldenGate in a Multitenant Container Database (part 2 of 2)

Lecture 55 Practice 22 Using Oracle GoldenGate in a Multitenant Database (part 1 of 5)

Lecture 56 Practice 22 Using Oracle GoldenGate in a Multitenant Database (part 2 of 5)

Lecture 57 Practice 22 Using Oracle GoldenGate in a Multitenant Database (part 3 of 5)

Lecture 58 Practice 22 Using Oracle GoldenGate in a Multitenant Database (part 4 of 5)

Lecture 59 Practice 22 Using Oracle GoldenGate in a Multitenant Database (part 5 of 5)

Section 13: Appendix

Lecture 60 Course Slides and Practices

Database Administrators,System Integrator,Data Warehouse Analyst,Data Warehouse Developer