Oracle Golden Gate Classroom Training

Oracle Golden Gate Training program with 100% COMPLETE PRACTICAL and REAL-TIME subject. Course starts from the Basics of SQL to Intermediate concepts like ARMAN Backups to Advanced concpets like RAC and Indepth Tuning Techniques. Course includes Resume Guidance, Interview and Certification Guidance. Register Today

Schedules for Oracle Golden Gate Training

 
Timings
Start Date Location
Trainer
 
1 6 AM to 7:30 AM Nov 27th SR Nagar Mr. Mishra Register

All Trainings are Completely Practical & Real-Time

Trainer : Mr G Mishra (8+ Yrs Exp)

Oracle Golden Gate Course Fee : 12,000/-

Duration : 3 Weeks / 4 Weekends


HIGHLIGHTS

Daily Tasks Weekly Interviews
Real-time Project Resume Guidance
Certification Guidance Placement Services
 

Oracle Golden Gate Training Course Contents:

Golden Gate Course

DAY 1 : Audience (Who can learn the Golden Gate):-

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

DAY 2 : What you will learn from expert & experienced Real Time Professionals?

  • Oracle - To - Oracle database & Oracle - To - SQL Server database replication.
  • Install Oracle Golden Gate on Linux and Windows platforms.
  • Prepare the source and target environments.
  • Oracle Golden Gate software command interface (GGSCI) commands to start, stop, alter, delete and monitor Golden Gate processes.
  • Create and configure parameter files to transform data.
  • Configure Change Capture (Extract), Pump (Transfer) and Delivery (Replicat) processes parameter files.
  • DDL and DML data replication in Uni- & Bi- Direction.
  • Manage Extract trails and files using Data Pump and logdump.
  • Difference between Classic & Integrated Golden Gate processes.
  • How to upgrade from classic/configure to Integrated Golden Gate processes.
  • Control network transmission using compression and encryption.
  • Manage multiple Oracle Golden Gate instances.

DAY 3 : Technology Overview

  • Creating Oracle Golden Gate Topologies
  • Reviewing Oracle Golden Gate Use Cases
  • Assembling Building Blocks
  • Listing Supported OS & Supported Databases
  • Listing the Oracle GoldengGate Product Line
  • Describing GUI Management Options
  • Listing Non-Database Sources and Targets

DAY 4 : Oracle Golden Gate Architecture

  • Describing Oracle Golden Gate Process Groups
  • Explaining Change Capture and Delivery (with and without a Data Pump)
  • Explaining Initial Data Load
  • Contrasting Batch and Online Operation
  • Explaining Oracle Golden Gate Checkpointing
  • Describing Commit Sequence Numbers (CSN)
  • Describing Oracle Golden Gate Files and Directories

DAY 5 : Installing Oracle Golden Gate

  • Listing System Requirements Performing Installation Configuring Environment Variables Using GGSCI
  • Running Oracle Golden Gate from the OS shell.

DAY 6 : Configuration Overview and Preparing the Environment

  • Reviewing Configuration Overview
  • Configuring Manager Process
  • Creating Source Definitions
  • Preparing the Source Database
  • Assigning Oracle Database Roles/Privileges Required
  • Using DBMS_GOLDEN GATE_AUTH Package

DAY 7 : Configuring Change Capture (Extract)

  • Reviewing Extract Overview
  • Accessing Logs on Oracle ASM
  • Accessing Logs Remotely
  • Configuring Extract Tasks
  • Adding Extract Group
  • Editing Extract Parameters
  • Extracting Use of Archived Transaction Logs
  • Adding Trails

DAY 8 : Configuring Extract Trails and Files (Data Pump)

  • Reviewing Extract Trails and Files Overview
  • Describing Trail Formats
  • Using Logdump for Viewing Trails
  • Reversing the Trail Sequence
  • Configuring and Using Data Pumps

DAY 9 : Configuring Change Delivery (Replicat)

  • Reviewing Replicat Overview
  • Configuring Replicat Tasks
  • Configuring a Sample Environment
  • Configuring New Integrated Replicat

DAY 10 : Performing Initial Load

  • Oracle Golden Gate Methods Listing Database-specific Methods Describing Resource Limitations
  • Listing Advantages of Oracle Golden Gate Methods Configuring File Load Methods
  • Configuring Direct Load Methods Handling Collisions with Initial Load

DAY 11 : Editing Configuration Parameters

  • Editing Parameter Files
  • Contrasting GLOBALS versus Process Parameters Configuring GLOBALS Parameters
  • Configuring Manager Parameters
  • Configuring Extract Parameters
  • Configuring Replicat Parameters

DAY 12 : Additional Transformation Concepts

  • Configuring and Using Macros
  • Configuring and Using User Tokens
  • Configuring and Using User Exits
  • Configuring and Using Oracle Sequences

DAY 13 : Configuration Options

  • Configuring and Using BATCHSQL
  • Configuring and Using Compression
  • Configuring and Using Encryption
  • Configuring and Using Event Actions
  • Configuring New Wallet Security

DAY 14 : Bidirectional Replication

  • Reviewing Bidirectional Considerations
  • Detecting Loops
  • Avoiding Conflicts
  • Configuring and Using Conflict Detection and Resolution
  • Describing Identity Types Issues

DAY 15 : DDL Replication

  • Reviewing Data Description Language Replication Overview Configuring and Using Options for DDL Replication Configuring and Using String Substitution in DDL

DAY 16 : Real world life of an Oracle Golden Gate administrator

  • Type of Oracle Golden Gate errors and warnings.
  • How to work with Oracle Support https://support.oracle.com to create Service Requests.
  • Parlance and terminology used by Oracle Golden Gate administrator.
  • Productivity tools required when you join the work place.

DAY 16 : Real world life of an Oracle Golden Gate administrator

  • Type of Oracle Golden Gate errors and warnings.
  • How to work with Oracle Support https://support.oracle.com to create Service Requests.
  • Parlance and terminology used by Oracle Golden Gate administrator.
  • Productivity tools required when you join the work place.

DAY 17 : Oracle Golden Gate 12c: Advanced Configuration for Oracle Course Topics/Objectives

  1. Explain Oracle Golden Gate advanced configuration options.
  2. Describe and take advantage of the Integrated Capture feature and the recently introduced Integrated Replicat feature to replicate complex data types and compressed data.
  3. Integrate the Database File System (DBFS) with Oracle Golden Gate to achieve Maximum Availability.
  4. Configure and implement the Oracle Golden Gate Event Marker system.
  5. Enable data transformation based on event records in the transaction logs or in the trail files.
  6. Perform zero-downtime database migration.
  7. Set up and manage advanced deployment models, like 3-node multi master replication configuration.
  8. Master Oracle Golden Gate facilities to detect and resolve data conflicts in active-to-active replication implementations.
  9. Use a simulated Oracle RAC configuration to experiment with the Oracle GoldenGate Clusterware-aware facilities, which ensure seamless data replication in case of node failure.

*Above course curriculum applicable for registrations from Sep 13TH, 2017

24x7 Support (Lab) with Real-time Databases. Course includes ONE Real-time Project. Register Today
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 Support.
 

Oracle RAC DBA Training - Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • Certification & Interview Guidance
 
 
  • Detailed SQL Server Architecture, DB Design
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, DAC and Contained Databases
  • Routine DBA Activities, Emergency DBA Activities
  • SQL Profiler, SQLDIAG, DTA and Litespeed Tools
  • High Availability, Disaster Recovery, Always-On
Register Today  Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T