Skip to content
UdemyIT & SoftwarePaid courseAll LevelsCertificate

Oracle GoldenGate 12c database replication workshop (Udemy.com)

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

Created by: Javier Morales Carreras

Last updated October 2021

icon
What you will learn

  • Understand all the basics about Oracle databases replication with Oracle GoldenGate tool
  • Create a duplicated and synchronized environment for emergency or reporting
  • Perform a database migration with (almost) zero downtime
  • Learn a lot of stuff about Oracle12c architecture, Multitenant databases, new features of GoldenGate12c, ...
  • Create a lab test environment with two OraLinux servers with Oracle to test logical replications

How it compares

Against the other 1,182 rated Udemy courses in IT & Software on CourseDuck:

  • Rating4.4 out of 5higher than 30% of them
  • Reviews500#582 of 1,183 by number of reviews
  • Length1.6 hoursshorter than 89% of them
  • Last updatedOctober 2021earlier than 79% of them

icon
Course Description

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.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Javier Morales Carreras

Javier Morales is Oracle DBA certified professional since 2002. Writer of the oracle best seller "Optimización SQL en Oracle" (spanish - Amazon) about SQL performance tuning in Oracle, he has worked as DBA and developer menthor for entities like Health Government (Spain - Valencia, Norway), National Police, Presidence Ministry of Spain, Oracle Iberica (Spain and Portugal) and many others. 

Since 2009 he owns the consulting company named TechLevel and provides expert services based on Oracle with a collaborators team with more than 15 years of experience.

He had performed almos zero downtime migrations for the Valencian bloodbank and several hospitals including architecture change (windows to linux, solaris to linux) and different oracle versions.


icon
More IT & Software courses

$49.99

$10.99

$124.99

$19.99

$11.99

$19.99

icon
Reviews

4.4

500 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By GERARDO ANTONIO PINEDO on 7/14/2025

The course is very basic, I understand that's the objective. It would have been great if it had covered topics like replicating between different RDBMS and using the Classic Method. Because of that, I'm giving it a 3-star rating.

By Eric Wijaya on 5/27/2025

Disable trigger is on Clapton or Moore? You said there are three things to check first before do golden gate but no video to verify to check and ALTER if needed for this three things (LOGGING, SUPPLEMENTAL, sorry forgot the other one)

By Eriovaldo do Carmo Andrietta on 5/10/2025

Bem pontual e claro. O instrutor domina o assunto, tem didática. O curso é bem extenso e abrangente no assunto. Executa os comandos. Senti falta de poder pegar os slides, mas o instrutor disse que tem direitos reservados sobre o material, o que faz sentido. Os recursos em texto fornecidos poderiam trazer todos os comandos executados, mas nada disso tira o mérito do curso. É bom.

By Jonathan Lehman on 3/5/2024

Javier Morales Carreras has a great short course concerning Oracle GoldenGate. The total time to play through the videos is less than 2 hours and much of the video material is the instructor merely speaking to the camera. But The course is made up of many guided assignments which provide many great examples of code and commands. The course includes full installation steps for Oracle Database and Oracle GoldenGate. While an overview briefly describes the many capabilities of Oracle GoldenGate to integrate with numerous Database platforms, the course itself focuses on replicating data within a single Oracle Database or between 2 Oracle Databases. The final section contains many links to official documentations and a long list of error codes and possible problems and solutions to look for when troubleshooting, which is really great.

By Alvaro Said Camacho Villanueva on 8/20/2023

Excelent contents and well explained! This has been a great learning experience.Thanks a lot! All the excercises were succesfully completed and everything exposed tested and learned with a very good explanation in every step

By Roberto Rodríguez on 5/21/2020

Es un buen curso. Tal vez hay que hacer énfasis en algunas cosas como por ejemplo, remarcar en que servidores se están haciendo las modificaciones, aunque la mayor parte se hizo en el servidor clapton, algunas cosas debían revisarse o ser ejecutadas en el servidor moore y no se especificaba claramente que se debía trabajar en dicho servidor. En general buen curso.

By Greg Palumbo on 1/24/2020

I like the fact that most of the modules are paired with hands-on lab exercises. This helps to enforce what is being learned, and the occasional "hiccup" when something doesn't work quite right in the lab is valuable troubleshooting skill-building.

By Earnest Ndifor on 12/27/2018

This is my first experience with Oracle GoldenGate application. The course was organized such that, I could go through the steps with minimal challenges. I felt like I was a genus at the end of the course. Each theoretical lesson was followed by a practical lab for a real life experience. Thanks Professor for also including at the end of course, additional links where we can continue to polish our ideas.

By Jose Carlos Pavón on 9/1/2018

This is one of the best GG course i ever see in Udemy. 100% practical, easy to understand and direct to the point. My suggestion to make it almost perfect would be: Extend section about Troubleshooting and conflicts resolution and also cover different configurations like Downstreams Integrated Extract. Best Regards, Jose.-

By Hrishikesh Samant on 7/26/2018

This is a no-nonsense hands on guide to golden gate. If you are familiar with golden gate architecture and need a quick brush up then you would feel at home with this course.You would be equally comfortable if you are in a hurry to get your hands dirty with goldengate. I have taken of half a star from the course because the title of the course is Practical Oracle Golden Gate and yet for some very strange reason the Instructor does not cover Conflict Detection and Resolution which you would always encounter whenever you replicate any data.Since Author teaches Oracle Golden gate 12.3. I expect him to undoubtedly cover this there is no excuse for not covering it. Hope the instructor is generous enough to take this feedback positively and cover Automatic CDR and the scenarios and earn a Five Star rating on this course.

Showing all 10 reviews on CourseDuck

Read all 500 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 88 / 100