Oracle Goldengate

Xoom Trainings provides Oracle Golden Gate Online & Classroom Training course by excellent experienced IT professionals. Our trainer has good training experience so that best quality output will be delivered.


    About the Course

    Xoomtrainings offers instructor led live interactive sessions for Oracle Golden Gate Online training on oracle 11g & 12c, learn from the best instructors known to have trained both experienced and beginners in the field of Database Administration. End users can enroll for the oracle golden gate 12c training and have the benefits of our LMS which is learning management system where you will have access to all the pre-recorded videos, ppt’s, interview questions, case studies, pdf’s and projects.

    Oracle Golden Gate Online Training

    After completion of the Oracle Golden Gate 11g course as mentioned below, the participant can understand the use of software to capture, routing, transformation, and the delivery of transactional data across heterogeneous oracle databases in real time.

    Oracle golden gate online training 12c: Oracle DBA’s can now add Oracle Golden Gate experience to their profile by learning Golden Gate 11g/12c at XoomTrainings. Our online training, tutorials provided by highly skilled trainers who have experience on basic to advanced topics related to DBA.This Golden gate Oracle database is the best replication software providing zero downtime when migrating; this course for sure will be an added advantage to get a job in world top companies. Enroll quickly to enhance your knowledge and values as DBA, check out new batches to grab a new job opportunity.

    Today’s transaction-driven applications do need a real-time log-based replication software platform where oracle golden gate 11g can serve the purpose completely. In order to meet this demand, Xoom Trainings has designed online course to upgrade your real time analytics knowledge and skills in the understanding of this technology. On deployment of Oracle Golden Gate, a user can achieve continuous availability for critical systems and real-time data integration for fast, easy access to current and accurate data.

    Oracle Golden Gate Online Trainings:

    • Oracle tutorial basics: download, install, and run commands using Oracle Golden Gate, Oracle golden gate basics.
    • How to access logs on Oracle Automatic Storage Management (ASM).
    • Learn about the Initial Load Data, and troubleshoot a started solution.
    • Configuration of Initial Load.
    • Configure Replicate, Troubleshoot a started solution, Oracle data guard.
    • How to Reverse the sequence of operations in an Extract trail or file.
    • Use SQLEXEC to interact directly with a database.
    • Handle bidirectional issues, Detect and resolve conflicts, Handle identity types.
    • DDL Replication, Oracle golden gate commands.

    Companies Using Oracle Golden Gate:

    IBM, eBay, CISCO, Aol, Intel, Salesforce.

    Oracle GoldenGate Training Career Opportunities:

    Get placement in IT companies which runs Oracle DBA 11g.


      • Discussing Required versus Suggested Knowledge
      • Listing Course Objectives
      • Discussing Course Non-Objectives (available as other follow-on courses)

    Technology Overview

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

    Oracle GoldenGate Architecture

          • Describing Oracle GoldenGate Process Groups
          • Explaining change Capture and Delivery (with and without a data pump)
          • Explaining Initial Data Load
          • Contrasting Batch and Online Operation
          • Explaining Oracle GoldenGate Checkpointing
          • Describing Commit Sequence Numbers (CSN)
          • Describing Oracle GoldenGate Files and Directories

    Installing Oracle GoldenGate

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

    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

    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

    Configuring Change Delivery (Replicat)

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

    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

    Performing Initial Load

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

    Editing Configuration Parameters

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

    Filtering and Data Selection

          • Filtering and Data Selection
          • Mapping Columns Between Different Schemas
          • Using Built-in “@” (at) Functions
          • Using SQLEXEC to Interact Directly with a Database

    Additional Transformation Concepts

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

    Configuration Options

          • Configuring and Using BATCHSQL
          • Configuring and Using Compression
          • Configuring and Using Encryption
          • Configuring and Using Event Actions

    Bidirectional Replication

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

    DDL Replication

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

    Tuning and Troubleshooting

          • Controling Command Persionns
          • Managing Trail Files
          • Automating Process Setup
          • Restarting Oracle GoldenGate
          • Handling TCP/IP Errors
          • Using Reporting and Statistics
          • Monitoring Processes, Lags and Error Messages
          • Features of GoldenGate Management Pack

    We record every live session we hold. Video recordings of each and every session will be posted on our blog too. So, this means you can get access to what the session is about and this way you do not miss any class. But take a note of it that you can have access to these Video recordings for 6 months only from the date you start your training. Access to these videos or to other required course material will be provided using Google Drive Cloud for lifetime.

    Yes, you can cancel your enrolment. We provide a complete refund after deducting the administration fee. To know more, please go through our Refund Policy.

    We have a team of industry-expert instructors or trainers who possess 8-10 yrs. of relevant experience in various Business Technologies. Every instructor / trainer undergo our specialized training program called “Train the Trainer” at Xoomtrainings. Our trainers are trained so that our learners get a great learning experience.

    Yes, classes at Xoomtrainings are conducted through online video streaming where there is two-way communication between users and instructors. The users can speak by using a microphone, chat by sending a message through a chat window and share their screens with an instructor. For better understanding, users can take the sample recorded class on this page to know of the quality of instruction and the way the class is conducted.

    Yes, the instructor will allocate you a real-time project to have a clear understanding of how you are able to conceptualize and implement the real-world application of the course content.

    Yes, we run multiple offers from time-to-time. Please, contact the support team they will give the Coupon Code.

    Yes, we will give you a discount of Rs 1500/- on selected course if you refer someone. We also offer special discount for groups.

    Yes, we will provide you the links of the software to download (trial version) which are open source and for proprietary tools we will provide you trial version, if available.

    For your practical work, we will help you set up a Virtual Machine on your system with IDE’s. This will be local access for you. The detailed step-wise installation guides are present in your LMS which will help you install and set-up the environment for any course. In case, you come across any doubt, the 24/7 support team will promptly assist you through mail (support@xoomtrainings.in) or Phone (+91 -40-4018 3355)

    4 Mbps of internet speed is recommended to attend LIVE classes. However, we have seen people attending the classes with a much slower internet connection too.

    Yes. You will receive a Digital E-Certificate from us once you complete the course. You can include this is in your Resume to get placed better.

    Xoomtrainings is the largest online education company and a large number of recruitment firms contacts us for our student’s profiles from time-to-time. Since there is a big demand for this skill, we help our certified students get connected to prospective employers. We also help our customers prepare their resumes, work on real life projects and provide assistance for interview preparation. Having said that, please understand that we don’t guarantee any placement. However, if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.

    No doubt, your transaction is always safe and secure with Xoomtrainings.

    You will get 24/7 access to the blog to post your questions. Trainers will answer your questions through email within 24 hrs. of time. Also, our support team will help you 24/7 through mail (support@xoomtrainings.in) or Phone (+91-40-4018 3355 ,7093502091,92 ).

    You can give us a CALL at INDIA: +91-40-4018 3355 ,7093502091,92  Or Email at contact@xoomtrainings.in


    Tab Content

    Course Reviews

    No Reviews found for this course.

    • Rs.39,000.00
    • 25 Hours

    Course Features

    Lifetime access to the learning management system including Class recordings, presentations, sample code and projects

    Lifetime access to the support team (available 24/7) in resolving queries during and after the course completion

    Xoomtrainings certified based on your project performance, reviewed by our expert panel

    Xoomtrianings enjoys strong relationship with multiple staffing companies in US, UK and India. If you are looking out for exploring Placement opportunities, you can pass your resumes once you complete the course and we will help you with job assistance. We don’t charge any extra fees for passing the resume to our partners and clients

    Course Enquiry

    © 2015 - 2016 Xoom Trainings powered by Innovin IT Solutions Pvt.LTD..All Rights Reserved.
    There are no courses Added to Cart