back to Course Categories | back | print
Fundamentals of Data Transformations using Oracle Golden Gate          

Duration: 3 days

Description 
This course will show attendees data movement techniques and best practices using Golden Gate. The different techniques for implementing data replication will be covered. GGSCI commands and utilities will be used. Installation, configuration, management and tuning will be covered.

Topics

  • Features and Benefits of Golden Gate
  • Golden Gate Architecture
  • What is Golden Gate Director?
  • What is Golden Gate Veridata?
  • Golden Gate versus Oracle Streams
  • Data Pump Change Capture
  • Data Pump Delivery
  • Installing Golden Gate
  • Checkpointing
  • Utilities
  • Configuration
  • Understanding Golden Gate Commands
  • GGSCI commands
  • Data transformations
  • Configuring Manager Process
  • Setting up Change Capture
  • Understanding the Extract Process
  • Extract Trails
  • Setting up Initial Load
  • Data Mappings
  • Transformations
  • Understanding the Replicat Process
  • Functions
  • SQLEXEC
  • Working with Tokens
  • Configuring User Tokens
  • Setting User Exits
  • Understanding tokens and user exists
  • Oracle Sequences
  • Configurations
  • Data Compression
  • Encryption
  • DDL Replication
  • Triggering actions with event records
  • Automation
  • Security
  • Using Macros
  • Management
  • Bi-directional detection and resolution
  • Understanding lags
  • Monitoring
  • Troubleshooting
  • Reporting
  • Available statistics
  • Working with BATCHSQL

Prerequisites

  • Attendees should have a solid understanding of Oracle 10g/11g Database Server.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design