Learn Oracle 18c & Data Guard: On-Premises and Oracle Cloud

Name: Learn Oracle 18c & Data Guard: On-Premises and Oracle Cloud
Rating: 4.3 (157 reviews)

Practical Course to install Oracle database and Oracle Data Guard administration using Oracle 18C on premises and Cloud

Created byZulqarnain Hayat

Last updated 10/2025

English

What you'll learn

Able to setup Oracle 18c test lab for Oracle OCM certification including Understand the concepts of Oracle Data Guard architecture on cloud &on priem
ODG
19c
Lab Setup

Course content

6 sections • 20 lectures • 2h 39m total length

Introduction5:28

Create free account on oracle cloud3:44
Create a free Oracle Cloud account by registering for the trial, verify your phone, and add a payment method to receive three hundred dollars in cloud credit for thirty days.
Generating an SSH Key Pair On Windows Using the PuTTY Key Generator4:30
Create service5:37
Create a cloud service and provision an Oracle database instance by configuring name, region, database type, and instance size; receive email notifications and manage via enterprise manager.
Logging in to your instance using ssh from windows2:54
Learn to log in to an Oracle 18c database instance from Windows via SSH with a private key, using the public IP and hostname, and access PDB two.

Create a Compartment1:59
Learn to navigate Oracle Cloud infrastructure, log in to the OCI console, and create an identity compartment, laying the groundwork for a virtual cloud network and database VM.
Create a Virtual Cloud Network (VCN)3:18
Create a Database VM4:19
Create a database VM on Oracle Cloud by configuring a virtual network and public and private keys, then launch the VM with a database admin and hostname.

Configure Data Guard On Oracle Cloud Service using Oracle 18c4:23
Configure Data Guard on Oracle Cloud using Oracle 18c by creating a single instance with standby, setting name, password, storage, and public access.
Database Switch over4:51
Database Fail over4:34
Snapshot Standby database3:15
Demonstrate converting a physical standby database to a snapshot standby, then switching it back to a physical standby with step-by-step commands and a practical demo.

Requirements

I assume the audience have the basic knowledge of the Oracle Database Administration fundamentals. We do not expect you to be an expert DBA
oracle ODG
Failover
Failback

Description

Welcome! My name is Zulqarnain Hayat, and in this course, you will gain hands-on experience with Oracle Database 18C and Oracle Data Guard, both on-premises and on the Oracle Cloud. Designed for DBAs, IT professionals, and developers, this course provides practical knowledge for setting up, configuring, and managing Oracle 18C databases in real-world environments.

The course is divided into two major parts:

Part 1: Oracle 18C Lab Setup and On-Premises Data Guard
You’ll learn how to download software, configure virtual machines, install Oracle Linux 7, and set up Oracle 18C. You will configure listeners, create Container Databases (CDB) and Pluggable Databases (PDB), and perform database connections. The lab also guides you through Data Guard setup on-premises, including cloning nodes and configuring high availability environments.

Part 2: Oracle 18C on Cloud (DBaaS & OCI)
Explore Oracle Cloud by creating a free trial account and setting up Database as a Service (DBaaS). Learn to generate SSH key pairs, log in via SSH, create compartments, virtual cloud networks (VCNs), and database VMs. You’ll also configure Oracle Data Guard on cloud, performing tasks like switch-over, fail-over, and snapshot standby databases step by step.

By the end of this course, you’ll be confident in deploying, managing, and securing Oracle 18C databases on both on-premises and cloud environments, mastering Data Guard high availability solutions. This course is ideal for anyone looking to advance their career as an Oracle DBA or IT professional.

Who this course is for:

This course is designed for Oracle Database Administrators and Oracle developer or who want to do preparation to complete Oracle certification
who would like to use Oracle 18c and Oracle Data Guard on premises or on Oracle Cloud .
Lab Setup

Learn Oracle 18c & Data Guard: On-Premises and Oracle Cloud

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 5min

Oracle 18C lab environment hands-on7 lectures • 1hr 4min

Oracle Data-Guard Lab setup on Oracle 18C1 lecture • 46min

Oracle Cloud Database as a Service (DBaaS)4 lectures • 17min

Oracle Cloud Infrastructure (OCI)3 lectures • 10min

Configure Data Guard On Oracle Cloud Service using Oracle 18c4 lectures • 17min

Requirements

Description

Who this course is for: