Oracle Goldengate 12C Fundamentals

Oracle Goldengate 12C Fundamentals
Last updated 5/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz

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.
Overview

Section 1: Introducing the Oracle GoldenGate 12c Fundamentals course

Lecture 1 Introducing the Course

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 9 Practice 3 Preparing the Environment for GoldenGate

Lecture 10 Implementing Initial Load

Lecture 13 Configuring Change Capture

Lecture 14 Configuring Change Delivery

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

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 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

Section 13: Appendix

Lecture 60 Course Slides and Practices

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