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
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
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.
Instructor Details
- 4.4 Rating
500 Reviews
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.
More IT & Software courses
D3.js Data Visualization Fundamentals - Hands On (2026)
4.9 (3,917 Reviews)
Provider: Udemy
Time: 4.6h
$49.99
Hands-On Training: Streaming Data with Apache Kafka on Azure (2025)
4.9 (103 Reviews)
Provider: Udemy
Time: 3.7h
$10.99
Oracle Grid Infrastructure and RAC using Oracle Database 19c (2026)
4.8 (2,499 Reviews)
Provider: Udemy
Time: 8.7h
$19.99
PowerShell Scripting & Automation: The Complete Hands-On (2026)
4.8 (1,750 Reviews)
Provider: Udemy
Time: 9.6h
$11.99
AWS EC2 Crash Course + Load Balancing with Demos and PDFs (2025)
4.8 (866 Reviews)
Provider: Udemy
Time: 3.7h
$19.99
Reviews
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.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 88 / 100






