Overview
Oracle GoldenGate is a software product for real-time replication and migration across different databases. It provides a reliable, secure, and straightforward platform for transforming and integrating data on a large database.
This instructor-led, live training (online or onsite) is aimed at sysadmins and developers who wish to set up, deploy, and manage Oracle GoldenGate for data transformation.
By the end of this training, participants will be able to:
- Install and configure Oracle GoldenGate.
- Understand Oracle databases replication using the Oracle GoldenGate tool.
- Understand the Oracle GoldenGate architecture.
- Configure and perform a database replication and migration.
- Optimize Oracle GoldenGate performance and troubleshoot issues.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Requirements
- Understanding of database architecture and virtual machines
- Basic knowledge of Oracle databases
Audience
- Database Administrators
- Data Architects
- Developers
Course Outline
Introduction
- Overview of Oracle GoldenGate features and architecture
- Understanding Oracle GoldenGate processing methods and databases
Getting Started
- Setting up a practice lab
- Installing Oracle GoldenGate
- Navigating the Oracle GoldenGate user interface
Configuring Oracle GoldenGate
- Setting up processes and configurations
- Monitoring Oracle GoldenGate configurations
Setting up and Implementing Replication
- Implementing unidirectional replication
- Implementing DDL replication
- Implementing bidirectional replication
Filtering and Manipulating Data
- Implementing data filtration
- Transforming data in Oracle GoldenGate
Troubleshooting
Summary and Next Steps