Oracle GoldenGate

• Understanding of database architecture and virtual machines
• Basic knowledge of Oracle databases

Audience

• Database Administrators
• Data Architects
• Developers

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.

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