Overview

This Oracle GoldenGate 12c: Fundamentals for Oracle training focuses on Oracle-to-Oracle database replication. Expert Oracle University instructors will deep dive into the Oracle GoldenGate product suite, walking you through various product features. Oracle GoldenGate 12.3 for Oracle introduces the Microservices architecture, which allows for browser-based, REST interaction with Oracle GoldenGate. Both Classic and Microservices architectures are covered by the course, which starts by explaining replication concepts using the familiar, Classic architecture.

After solid replication foundations and concepts are explained and explored, the course delves into Microservices, and students are made quickly familiar with the new architecture. Hands-on practices help solidify the theoretical knowledge acquired during the lessons. Students will implement end-to-end replication environments using both architectures, testing the established replication channels with real data, to verify that replication is taking place.

Skills Covered

On completion of this course you will be able to:-

  • Technology Overview
  • Oracle GoldenGate Architecture
  • Installing Oracle GoldenGate
  • Configuration Overview and Preparing the Environment
  • Configuring Change Capture (Extract)
  • Configuring Change Delivery (Replicat)
  • Configuring Extract Trails and Files (Data Pump)
  • Performing Initial Load
  • Editing Configuration Parameters
  • Filtering and Data Selection
  • Additional Transformation Concepts
  • Configuration Options
  • Bidirectional Replication
  • DDL Replication

Who Should Attend

  • Configuration Consultant
  • Data Warehouse Administrator
  • Data Warehouse Analyst
  • Data Warehouse Developer
  • Database Administrators
  • Database Designers
  • System Integrator
  • Technical Consultant

Course Curriculum

Prerequisites

  • Familiarity with Oracle Database and basic SQL using SQL*Plus
  • Familiarity with editing Linux text files using gedit or vi

Download Syllabus

Course Modules