Oracle Goldengate 12C Fundamentals
Last updated 5/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.41 GB | Duration: 12h 37m
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
RapidGator
NitroFlare
DDownload
