Best Oracle Goldengate Courses

Find the best online Oracle Goldengate Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Oracle Goldengate Courses.

Oracle SQL Performance Tuning Masterclass 2021

Become an Expert on Oracle SQL Tuning and Solve All The Performance Problems of Your SQL Queries and the Database!

Created by Oracle Master Training • 100,000+ Students Worldwide - Oracle Architect & Best Selling Instructor

"]

Students: 23411, Price: $119.99

Students: 23411, Price:  Paid

Here is the most comprehensive SQL Tuning course that you will not need to take any other courses in anywhere.

This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge on Oracle SQL Tuning.

The most common problem of working with SQL is, performance problems. Most of the developers don't know how to write well-performing queries. So in time, this problem grows and becomes a problem for both the developer and the company.

This course will teach you how to tune your SQL statements and database step by step for a perfect performance! You will learn how to write fast, reliable, and secure queries. Besides, you will learn the database architecture and will be able to optimize the database workloads.

Once you complete this course, you will recognize the database terms better and will use the most appropriate one for the performance.

Once you complete this course, you will be able to:

  • Find the poorly performing queries

  • Learn Advanced Query Tuning Techniques

  • Understand the Database Architecture to perform Better Tuning Techniques

  • Learn Advanced Indexing Techniques to Maximize Database Performance

  • Learn how to use various Performance Tuning Tools

  • Compare BAD vs GOOD Queries with Hands-on Examples.

  • Gather Statistics for the bad SQLs

  • Interpret the Execution Plans with different methods

  • Choose an appropriate SQL tuning approach

  • Guide the Oracle Optimizer for a better execution

  • Use various tuning techniques like using bind variables, different types of indexes, and much more.

  • Improve the performance of the queries & database

  • Gain Complete Knowledge in Oracle SQL and Performance Tuning!

Briefly, the knowledge of SQL Tuning is a "must" for IT Professionals and this course is the magic pill for that you're seeking for Becoming a Performance Expert!

If you want to step ahead in your career, "SQL & Performance Tuning" should be your next step.

See you in the first lecture!

Oracle Goldengate 12c

Oracle Goldengate

Created by Ashish Agarwal - Oracle Goldengate Specialist and Database Analyst

"]

Students: 5031, Price: $19.99

Students: 5031, Price:  Paid

Learn Oracle Goldengate and be Oracle Goldengate Specialist..

  The course contains the topics from basics to advanced level. The course is designed in such a way that it caters to everyones need. The course is descriptive and practical. The course will help you in achieving expertise on Oracle Goldengate.

With this course you will learn:

  • Oracle Goldengate Architecture

  • Oracle Goldengate Introduction,Download and Installation 

  • Strategizing Goldengate on RAC

  • Set up a unidirectional and bidirectional replication

  • Understanding Parameter files

  • Perform data filteration and transformation

  • Implementing DDL Replication

  • Implement integrated Extract 

  • Implementing Integrated Replicat

  • Strategy for Monitoring and troubleshooting an Oracle GoldenGate configuration,

  • Configuring Oracle Goldengate security to meet customer needs

  • Understanding and Configuring Oracle Goldengate Parameter Files

  • Preparing for the interview

  • Test cases

  • Oracle Goldengate 12c new features

  • Hands on Activity Guides

  • Interview Questions for GG

  • Upgrade and patching

  • guidance for Certification

Post the completion of this course attend the Goldengate certification course (Certification Oracle Goldengate Implementation Essentials) from Ashish Agarwal and be Oracle Goldengate certified. So u will have expertise and certification both with this and certification course!

Content and Overview 

This course is suitable for for Database Administrators and Developers., The course has descriptive and demonstrated 18 hours video sessions which will help you learn Oracle GoldenGate 12c fundamentals. The lectures are supported with exercises and documentations.

The course starts with description of Oracle Goldengate Architecture and installation of Oracle Goldengate on Linux Platform. The course has a wonderful presentation on all the topics including parameter files of Oracle Goldengate. The course also guides you on how to crack the interview. With the course you get Goldengate Interview Q and A.  Also you can get the guide to setup the lab with this course.

This course give you the chance to grab the oppurtunity to work with instructor with such a wide experience and gaining real time scenarios.

Upon completing this course, you will be able to configure Oracle Goldengate and support Goldengate in customer environment. So, come join in the amazing journey of learning this hot technology.

Who is the target audience?

  • Database Administrators

  • Database Analysts

  • Solution Architects

  • Technical Architects

  • Database Architects

  • Configuration Consultant

  • Data Warehouse Administrator

  • Data Warehouse Analyst

  • Data Warehouse Developer

  • Database Administrators

  • Database Designers

  • System Integrator

  • Technical Consultant

Introduction to Oracle 12c Golden Gate for absolute beginner

Setup your first single table replication using Oracle Golden Gate using the lab setup provided inside the course

Created by Arun Kumar - Oracle Certified Expert and Entrepreneur living in India

"]

Students: 3340, Price: $89.99

Students: 3340, Price:  Paid

Oracle Golden Gate is the best replication technology available in the market. It supports a wide variety of popular database platforms. Oracle Golden Gate being a robust replication technology, makes it A MUST LEARN technology for Database Administrators.

This video course focuses more on practice side of Oracle Golden Gate and is designed specifically for Oracle DBAs.

  • Install and configure Oracle 12c Golden Gate for Oracle database replication
  • Configure unidirectional and bidirectional replication
  • Explain the difference between classic vs integrated capture
  • Improve Golden Gate performance and troubleshoot common issues
  • Configure high availability using Oracle Golden Gate
  • Perform Oracle Golden Gate upgrade
  • Configure Oracle to MYSQL replication
  • Configure MS-SQL Server to Oracle replication
  • Prepare for Oracle Golden Gate interview

This video course is designed for Oracle DBAs who want to lean Oracle Golden Gate for configuring replication or job change but struggles to start learning and prepare a practice environment at home

Oracle GoldenGate 12c Fundamentals

Become professional at configuring and implementing Oracle GoldenGate in the Enterprise (upgrade to 19c included)

Created by Ahmed Baraka - Snr. Database Administrator

"]

Students: 1741, Price: $19.99

Students: 1741, Price:  Paid

Learn how to build, manage, monitor, and troubleshoot an Oracle GoldenGate configuration.

Upgrade to Oracle GoldenGate 19c Included

Not only the course will demonstrate the concepts for you, you will also gain practical experience on implementing the them.

  • Set up a unidirectional and bidirectional replication

  • Perform data filtering and manipulation

  • Implementing DDL Replication

  • Implement integrated processes

  • Implementing Coordinated Replicat

  • Monitor and troubleshoot an Oracle GoldenGate configuration,

  • Implement the security options

  • Apply Oracle GoldenGate patches

Content and Overview 

Suitable for Oracle Database Administrators, through this course of 42 lectures and more than 10 hours of video-based sessions, you’ll learn all of the Oracle GoldenGate 12c fundamentals. After every concepts lecture, you will implement a hands-on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents.

Starting with introducing Oracle GoldenGate, this course will take you all the away from installing the software on a Linux platform, building up a unidirectional and bidirectional configurations, managing an Oracle GoldenGate configuration, up to applying the patch sets.

This is an opportunity for the students to gain practical  experience from the author who has implemented a number of Oracle GoldenGate projects in real life.

Upon completing this course, you will be able to build up an Oracle GoldenGate configuration that  works in real life scenario.

Join the author in this learning journey to gain the knowledge on this amazing technology!

Oracle GoldenGate Beginner to Expert

Oracle GoldenGate

Created by Shrikanth Krishnamoorthy - Consultant

"]

Students: 1702, Price: $19.99

Students: 1702, Price:  Paid

*NEW Session* Oracle Golden Gate Performance troubleshooting for Replicate has been uploaded

**Awesome Opportunities to learn Real Time Golden Gate activities with Extensive 40+ hours session with regular addition of session.**

Golden Gate is the strongest and Robust Tool currently available . Hence it makes it very important to have a good grasp of the Tool.

Golden Gate in Real Time is not just configuration of Extract/Pump/Replicat. Its much more.

I Hope many would agree , we do not create new Process every Day or for every Requirement, the main concern I received from many was , how to play with existing process and visualize the solution. I was fortunate enough to work in very Troublesome and Extensive  Environment in my 9+ year of Industry Experience and have given all that in this Course.

Have added from the most basic like how to find a replication flow, Eg: if you have Extract --> then how to identify its respective Pump/Replicat and Vice Versa to Upgrade/Migration/Trail corruption/and many many more.

The course objective is to create the logic of how to approach the issue whenever you face anything in GoldenGate.

Many Realtime activities which are requested by Application Team are also shown here.

You can check the Q&A Section where wonderful questions have been asked.
Happy Learning.

Please reach me out in shrikanthkrishnamoorthy@gmail.com or +91 9545506265 for any doubt/query/discount.

Oracle Goldengate Microservices 19c

Learn new architecture of Goldengate and how to Configure, manage and maintain Oracle Goldengate using web based GUI

Created by Ashish Agarwal - Oracle Goldengate Specialist and Database Analyst

"]

Students: 627, Price: $24.99

Students: 627, Price:  Paid

Learn Oracle Goldengate Microservices and upskill your learning how to setup,Manage,maintain oracle Goldengate in Microservices architecture to stay ahead in your carrrer and learning!

  The course contains the topics from basics to advanced level. The course is designed in such a way that it caters to everyones need. The course is descriptive and practical. The course will help you in achieving expertise on Oracle Goldengate Microservices.

With this course you will learn:

  • Overview and Introduction to Goldengate Microservices.

  • Download and Installation of MSA

  • Create Service Manager and Deployment/s

  • Add credentials in credential Store

  • Configuration of GG MSA

  • Add Goldengate Extracts, Replicats and Distribution Server

  • Parallel Replicats and types

  • Bounded Recovery concept in Goldengate

  • What are parameters and Configuration of Parameter Files in GoldenGate MSA

  • Comparison of new Goldengate MSA architecture with existing Classic/Integrated Architecture

  • Performance Metrics (Monitoring Performance) of Goldengate MSA

  • Admin Client in Microservices vs GGSCI in Classic Architecture

  • How to read trail files in MSA (Usage of logdump)

  • Classic architecture to MSA replication (Source has classic architecture and target has Microservices architecture)

  • MSA to Classic architecture replication (Source has MSA architecture and target has Classic architecture)

  • How to upgrade oracle Goldengate Microservices

  • Troubleshooting issues in Goldengate MSA

  • Deinstallation of oracle Goldengate Microservices

Post the completion of this course you may also attend the Goldengate certification course (Certification Oracle Goldengate Implementation Essentials) , Oracle Goldengate Veridata and Oracle Goldengate (Classic) Archoitecture Training from Ashish Agarwal and be Oracle Goldengate certified. So u will have expertise and certification both with this and certification course!

Content and Overview 

This course is suitable for for Database Administrators and Developers., The course has descriptive and demonstrated 18 hours video sessions which will help you learn Oracle GoldenGate 12c fundamentals. The lectures are supported with exercises and documentations.

The course starts with description of Oracle Goldengate Architecture and installation of Oracle Goldengate on Linux Platform. The course has a wonderful presentation on all the topics including parameter files of Oracle Goldengate. The course also guides you on how to crack the interview. With the course you get Goldengate Interview Q and A.  Also you can get the guide to setup the lab with this course.

This course give you the chance to grab the oppurtunity to work with instructor with such a wide experience and gaining real time scenarios.

Upon completing this course, you will be able to configure Oracle Goldengate and support Goldengate in customer environment. So, come join in the amazing journey of learning this hot technology.

Who is the target audience?

  • Database Administrators

  • Database Analysts

  • Solution Architects

  • Technical Architects

  • Database Architects

  • Configuration Consultant

  • Data Warehouse Administrator

  • Data Warehouse Analyst

  • Data Warehouse Developer

  • Database Administrators

  • Database Designers

  • System Integrator

  • Technical Consultant

Oracle GoldenGate 12c database replication workshop

Learn database replication by creating virtual machines with Oracle GoldenGate 12c on Oracle 12c Multitenant databases.

Created by Javier Morales Carreras - OCP Oracle DBA

"]

Students: 544, Price: $79.99

Students: 544, Price:  Paid

Are you ready to create your own database replication environment with Oracle GoldenGate 12c? and have in your PC a complete database environment with two oracle servers and Oracle GoldenGate 12c installed and set up to replicate data from one server to another? and do you want to test it all in real, with all scripts and logs, to make it all work in your self-made test environment?

Then this course is for you. This is a practical workshop where you will learn how to replicate Oracle12c databases using Oracle GoldenGate12c by building your own replication environment. The course will give you the basics and the step by step practices to reproduce, in your virtual machines, a feel like production environment where you will replicate a database schema keeping it in sync with the source database.

In the course you will be guided step by step to set up and verify all steps in the Oracle GoldenGate12c installation and configuration, by using VirtualBox virtual machines with a pre-built Oracle12c multitenant database ready to use. You will start up in your laptop or PC two virtual machines with OraLinux servers and you will practice all the exercises in a total real environment.

So, even the workshop is based on OraLinux and Oracle12c multitenant, the replication theory would be valid for any supported environment you want to replicate: SQLServer through an Oracle server, or an Oracle Server to a DB2, etc. and including different versions like replicating data from an old Oracle11g to a Oracle12c with or without multitenant.

The course is divided into three main sections: 

1.- Laboratory installation, which will include detailed instructions to install and set up: Oracle VirtualBox, two virtual machines with OraLinux, each Oracle database server for GoldenGate, The installation and configuration of Oracle GoldenGate12c and a sample schema.

2.- Basic replication, using the same database as source and target, for a single table.

3.- Advanced replication, using the two servers to propagate all transactions from the source database to the target database at schema level (all tables and sequences). You woulc use this method to perform a database version upgrade to a new database release, having two environments in sync, and doing the upgrade by just stopping the source environment and starting the target database to the users. This is often called "upgrade with almost zero downtime", and it's one of the most valuable upgrading procedures when it comes to upgrade critical servers.

In other words, you will learn how to build a new replicated environment you may use as reporting database, or quality assurance test servers where you may test live your "go to production" procedures, or using it as a DR (disaster recovery) database copy ready to use in production in a severe lost of the main database, with all up to date transactions!.

And so, you will find lots of chapters with important information about the Oracle GoldenGate funcionality and the particular considerations about Oracle database at administration level, such as setting up the supplemental login, how to manage multitenant Oracle12c database, important aspects about the logging files and transactional processing, or how to copy a schema consistent to a point in time to create an identical target based on a SCN.

The course also includes quizzes, checks, scripts, dictionary of terms and concepts, and basic troubleshooting guide it may be useful in your daily work. It's a complete guide and workshop with a practical laboratory you may use and keep for further tests and checks.

Preparatory Study Oracle GoldenGate Certification 1Z0-447

THE CORRECT ANSWERS! Get ready with 130+ different questions (no duplicates), accurate answers and Oracle docs reference

Created by Rod Rodrigues | Oracle Certified Professional, Expert and Specialist - Senior Database Administrator

"]

Students: 169, Price: $89.99

Students: 169, Price:  Paid

After failing the 1Z0-447 exam I decided to collect every GoldenGate question that I could find and compile my own training material. Then I researched for the CORRECT answers based on the official Oracle docs. It worked pretty well and I passed the exam on my second try with over 90% of correct answers. I am sure this preparatory study will give you the confidence to obtain your GoldenGate Certification.

Oracle Goldengate 19c – Learn and Master Oracle Goldengate

Professionally learn to design & implement Goldengate setup for ur customer & enterprise

Created by Ashish Agarwal - Oracle Goldengate Specialist and Database Analyst

"]

Students: 121, Price: $34.99

Students: 121, Price:  Paid

Oracle Goldengate 19c is the latest version of Oracle Goldengate with lot of new features and advantages. The new features include robustness,security,performance and loads of new features. This course is complete course which starts from download and installation of Goldengate and covers advanced topics.

I created this course because I want to encourage you to learn and build career in Goldengate. I want you to be an expert in Goldengate. Contrary to what we are being told and even technical "gurus", learning Goldengate is not difficult. Its very easy. Creating this course has been a journey - a journey of delivering my knowledge I've carried about Goldengate for a long time. i want to emphasise learning Goldengate is easy and being a Goldengate expert is not that tough. it just need some guidance,mentorship and practise. This course has all ingredients to make you learn Goldengate and pave your path towards becoming Goldengate expert.

This is the course with realtime activity course focussing on practicals. This course will make you interview ready and job ready. My assurance is at the end of the training you will be able to setup, manage,troubleshoot,configure Goldengate on ur own as well as able to provide solutions related to Goldengate on ur own to ur customer. If you are starting you carerr in Goldengate or new to Goldengate this is the correct course to pursue. Also if u have done my 12c course still there are lot of new topics introduced with this training.It is highly recommended that you enroll for this course.  this course has all the topics. This is the best course available related to Goldengate.

The course is designed to meet best learning experience. With each session of the course you get notes/recap of the session and what practical implementaion to follow prior to next session to get you ready. With the course you get step by step activity guides,whatsapp group support and for any technical issues I am just an email away.

The course Oracle GoldenGate 19c training will help you gain a strong foundation as well as expertise in implementing Oracle GoldenGate solutions. The course will deep dive into Oracle Goldengate architecture, parameters, mapping, transformations, and much more with real-time examples. You’ll also gain hands-on expertise with the help of Oracle GoldenGate training. There are many new topics included in training:

1. Parallel Replicat

2. Bidirectional auto CDR

3. Heartbeat table

4. PMSRVR

5. Troubleshooting strategies

6. Goldengate security wallet

Oracle GoldenGate 12c Implementation Essentials / 1Z0-447

Oracle GoldenGate 12c Implementation Essentials Exam Number: 1Z0-447

Created by IT Exams - ItExams

"]

Students: 6, Price: $24.99

Students: 6, Price:  Paid

Oracle GoldenGate (OGG) Overview

  • Describe OGG functional overview and common topologies

  • Describe OGG Veridata and Management Pack functionality

  • Describe the difference between real-time data integration replication and Data Manipulation Language (DML) replication

Architecture Overview

  • Describe OGG components

  • Create the two types of Capture processes for Oracle database

  • Create the three types of Replicat processes

  • Explain the difference between an Extract and Pump, and local and remote trails

  • Configure OGG's process recovery mechanism

Install and Configure OGG

  • Download and Install OGG, and differentiate between various installers (zip, OUI, tar)

  • Synchronize source and target databases with the Initial Load

  • Prepare database for OGG CDC and check databases with OGG schema check script

  • Configure OGG Replication component parameter files

  • Configure the OGG Command Interface to create OGG processes

  • Describe how to identify and resolve issues in heterogeneous replication, and provide appropriate solutions

  • Configure OGG utilities

Parameters

  • Describe and compare GLOBALS versus MANAGER parameters

  • Create solutions using component parameters for replication requirements

  • Install OGG parameters

  • Explain and identify parameters specific for non-Oracle databases

Mapping and Transformation Overview

  • Implement use cases for transformation functions

  • Implement macros

Configuration Options

  • Describe OGG configuration options (Data Definition Language (DDL), compression and encryption options)

  • Configure OGG event actions based on use cases

  • Troubleshoot conflict detection and resolution

  • Configure Integrated Capture, Replicat, and deployment options

Managing and Monitoring Oracle GoldenGate

  • Manage OGG command and data security

  • Implement and troubleshoot OGG Monitoring

  • Explain the configuration and management of the Enterprise Manager 12c plug-in

  • Implement and troubleshoot OGG Veridata