KT-3111 Oracle GoldenGate 11g: Fundamentals for Oracle Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Oracle GoldenGate 11g: Fundamentals for Oracle


Description: 

The Oracle GoldenGate 11g: Fundamentals for Oracle Edition 2 course focuses on Oracle-to-Oracle database replication. This course introduces the Oracle GoldenGate architecture as well as various product features. Participants learn to install Oracle GoldenGate and prepare the source and target environments. The course teaches how to use the Oracle GoldenGate command line interface (GGSCI) efficiently. Participants configure Change Capture (Extract), Change Delivery (Replicat), and Initial Load. They learn to extract trails and files using Data Pump, create parameter files, and to manage Oracle GoldenGate instances. Capture of both DML and DDL will be configured for both uni- and bi-directional replication.

Learn To:

  • Install Oracle GoldenGate on Linux and Windows platforms
  • Issue GGSCI commands
  • Configure, start, stop, and monitor Change Capture and Delivery processes
  • Manage Extract trails and files using Data Pump and logdump
  • Create parameter files to transform data
  • Manage multiple Oracle GoldenGate instances

This course is based on Oracle GoldenGate version 11.2.1.

Course Objectives:

  • Design replication solutions using Oracle GoldenGate products and environments
  • Install Oracle GoldenGate on Linux and Windows platforms (the labs are Linux)
  • Prepare the source and target database environments (assumes Oracle-to-Oracle replication)
  • Issue GGSCI commands (batch Obey scripts and command-line interactive)
  • Configure, start, stop, and monitor Change Capture (Extract)
  • Configure, start, stop, and monitor Change Delivery (Replicat)
  • Configure, start, stop, and monitor Initial Load
  • Manage Extract trails and files using Data Pump and utilities such as logdump
  • Control network transmission using compression and encryption
  • Create parameter files
  • Transform data
  • Manage multiple Oracle GoldenGate instances

Audience:

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

 
Click here to view the Course Outline
     
Prerequisite: 

Required Prerequisites:

  • Familiarity with Oracle Database and basic SQL using SQL*Plus.

Suggested Prerequisites:

  • Familiarity with Linux text editors such as vi or gedit
 
   
     
Duration: 
4 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.