• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 786-629-6893

About Course:

Oracle-Goldengate

This training program is designed to prepare the GoldenGate 11g Developer track. The Oracle GoldenGate 11g: Fundamentals for Oracle course focuses on Oracle-to-Oracle data 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 environment. The course teaches how to use the Oracle GoldenGate command line interface efficiently. Participants configure Change Capture, Initial Load, and Change Delivery. They learn to extract trails and files, create parameter files, and to manage Oracle GoldenGate instances


Duration : 30 hours


Fee: 328


Job Trends

Training Calender

Date Time Type Attend
No Schedule Available
Contact Us

+91 769-409-5404

Includes
  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Module of Training

LIVE ONLINE TRAINING


Live presentation of theory, demonstration of tool, features & tasks

We are connecting Online via Goto Meeting

Get practice environment for practical & hands-on Training curriculum has been designed by real-time industry professionals & real-time scenarios training pattern

CORPORATE TRAINING


Learn as per day-wise & customized schedule with discussions & lab exercises included

One to one or Batch-wise interactive demonstration of a tool, features and 100% practical classes

World-class learning material & case studies for the course

Completely customizable course content & schedule as per convenience

Certification guidance provided if necessary

Curriculum

Oracle GoldenGate Download  

Oracle GoldenGate

Course Overview

Module 1–GoldenGate Overview

1: Why GoldenGate

2: Listing Supported OS and DB’s

3: GoldenGate Topologies

Module 2–Oracle GoldenGate Architecture

1: Oracle GoldenGate Architecture

2 : Overview: Extract, Replicat, and Pump 

3: Oracle GoldenGate Checkpoints

4:  Trail files, Parameter file

5: Commit Sequence Numbers (CSN)

6: Initial Load vs Change Synchronization

Module 3 Installing Oracle GoldenGate

1: Listing System Requirements

2: Performing Installation

3: Configuring Environment Variables

4:  Understanding Directories

5: Using GGSCI

Module 4– Configuring Database and Manager

1: Create and Configure Goldengate user

2: Execute Scripts

3: Supplemental Logging and train data

4: Manager and Global Parameter file

5: Understanding DEFGEN utility

Module 5– Configuring Extract, Pump and Trail files

1: Extract Overview and Parameter File

2: Accessing Logs on Oracle ASM

3: Adding Extract Group

4: Adding Trails

5: Extract Trails and  Files Overview

6:  Configuring and Using Data Pumps

Module 6  Configuring Replicat and Unidirectional Replication

1:  Add Replicat

2:  Configure Replication

3:  Replication using data dump

4: Replication without using Data Pump

5: Using DEFGEN utility for 12.1 below

Module 7– Performing Initial Load

1: Oracle GoldenGate Initial Load   

2: Advantages and Restrictions

2: Configuring File Load Methods & Direct Load Methods

3: Handling Collisions with Initial Load

 

Module 8 – Integrated Capture and Integrated Delivery 

1:  Using Integrated Capture and benefits

2:  Steps to Upgrade to Integrated Capture

3: Integrated Delivery  and its benefits

4: Upgrade to Integrated Delivery

5: Dictionary View for Integrated Capture and Delivery

Module 9 Filtering and Data Selection

1:  COLUMN MAPPING

2: Data Selection

3: Filter Functions

4: Using Built-in “@” (at) Functions

5: Date and Range Functions

6: SQLEXEC

Module 10–DDL Replication

1: Requirement and Restrictions

2: DDL Replication: Scope

3: Configuring and Using String Substitution in DDL

Module 11   Troubleshooting and Monitoring

1: Process Information, Reporting, and Statistics

2: Overview of Trail File, Logdump and Trail File Recovery

3: Using BATCHSQL

Module 12   -  Compression and Encryption

                       1:  Compression

                       2:  Trail file, Message and Password Encryption

3: CMDSEC

4: USERIDALIAS

Module 13: Event Marker System

Module 14– Bidirectional Replication

1: Reviewing Bidirectional Considerations

2: Detecting and Preventing Loops

3: Avoiding and Resolving Conflicts

4: Insert, Delete and Update Conflicts

5: Using CompareCols

6:  Trusted Source

Module 15: Installing Oracle GoldenGate Microservices Architecture (12.3)

  1. Various Components of the Oracle GoldenGate Microservices Architecture
     
  2. List the Operating System Pre-Requisites Needed for a Microservices Architecture installation
     
  3. Perform an Oracle GoldenGate Microservice Architecture Installation and Verify its Successful Completion

Module 16: Overview of other Advance Topics

1: GoldenGate Cloud Service

2: Configuring GoldenGate for Container Database, RAC and DataGuard

3:  Reverse utility

Who should Learn Oracle GoldenGate?

Person who will have to work with different databases in the enterprise like DBA.

Prerequisite to learn Oracle GoldenGate

Oracle Goldengate is a tool, Developed to work with the heterogeneous databases.

Sound knowledge of database or DBA's

Delivery Methodology used to deliver the Oracle GoldenGate

We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.

Class delivery

Live Interactive classes with expert

Oracle GoldenGate FAQ

Question: Can I attend the Demo session before enrollment?

Answer: Yes, you may attend the Demo class before enrollment for training Quality Evaluation. You can also Interact with a trainer as one to one session for a specific requirement or discussion

Question: Can you schedule the training based upon my availability?

Answer: Yes, we need to discuss it with a trainer, accordingly, we can schedule training at a convenient time.

Question: How I can pay for the course?

Answer: You can pay the fee or enroll yourself via payment gateway through the course page, make an online payment using various options.

Question: What if I missed any class?

Answer: BISP has a missing class policy. If you missed any session, we will be sharing a recorded session. However, you may retake whole training multiple times within 6 month period but the trainer is the same.

Question: Is there any live project training along with regular training?

Answer: Our training curriculum includes real-time scenarios and lives project working module & the trainer explains every topic with examples. If you have any issue or you are stuck in any scenario the trainer will explain end-to-end.

Question: What about certification preparation and guidance?

Answer: BISP technical faculty assist & guide you completely for certification and preparation. We ensure you will get certified easily after our training.

Question: Who is the trainer & about his experience?

Answer: All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo We also ensure that only those trainers with a high alumni rating continue to train for us.

Question: Do you provide Job support?

Answer: Yes, we provide Job support services, but the cost structure is different and fixed. For more details: Just give us a call at: +91 769-409-5404 & +1 786-629-6893 You can also write to us: support@bisptrainings.com

Question: What if I have more queries and doubts?

Answer: Just give us call at : +91 769-409-5404 & +1 786-629-6893 You can also write to us: support@bisptrainings.com

Question: How Fee Refund Policy works?

Answer: Please refer the link for refund policy: https://www.bisptrainings.com/Refund-Policy

Case Study and Learning Pdf's

Certificate

Certificate123
Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?