Oracle Database on AWS Exploring EC2 RDS from scratch

Architecture ,Database Deployments with 18c/12c , Webserver Connectivity ,Demos on EC2/RDS from Architectural Standpoint
Oracle Database on AWS Exploring EC2 RDS from scratch
File Size :
2.12 GB
Total length :
5h 10m



Kshitij Joy (Udemy Instructor Partner / Oracle ACE Pro)


Last update




Oracle Database on AWS Exploring EC2 RDS from scratch

What you’ll learn

What is Cloud Computing : IaaS/PaaS/SaaS
Top Cloud Vendors by Market Share
Introduction to Amazon Cloud , Free Tier, Offerings
Demo: Understanding AWS Management Console
Deep Dive into AWS Architecture
Discussing What are Regions / AZ / Security Groups / VPC / EBS / S3
Demo: Creating a Custom VPC / Security Group / EBS / S3
Demo: Configuring AWSCLI for Mac & Windows
What is EC2 / Amazon Machine Image (AMI)
Demo: Building an EC2 Machine in Custom VPC
Demo: Installation of Oracle 18c XE on EC2 Instance
Demo: Perform RMAN Backups / Restore using S3 Storage
What is Amazon RDS / RDS for Oracle
Understanding RDS Snapshots and Doing a Demo on Backup / Restore
Monitoring in RDS
Demo: Deploy an RDS Oracle 12c Database in Custom VPC
Demo: Patching an RDS Oracle Database
Demo: Installation of Apache Webserver & Perform PHP-Oracle Connectivity (OCI8)
Demo: Using Sqlplus Client to connect to RDS Oracle Database
Demos: Oracle vs RDS Commands
What is REST API ?
Demo: Using Postman a Demo on How to Call a REST API ?

Oracle Database on AWS Exploring EC2 RDS from scratch


Oracle DBA’s / Developers / DevOps


I will be looking to delve deeper into the AWS Infrastructure and demystify the entire dilemma around Oracle Database on AWS.We will take a main architecture diagram as base , where we shall create a custom VPC, which will have a Public Subnet & a Private Subnet. The Public Subnet will have access to the internet and we will have a test Oracle 18c XE Database and an Apache Webserver in this.The Oracle 12c RDS Database will be created in Private Subnet and will have access only from Webserver. To achieve this our approach would be as follows:We will start with the very basics like : What is Cloud Computing ,  What are the meanings of the important acronyms like IaaS/ PaaS/ SaaS, Top Cloud Vendors by Market Share.A good understanding will be given about AWS Cloud , Sign-Up Process and Understanding the AWS Management Console.We will be approaching our study from Architecture standpoint by doing a deep dive into the Architecture of AWS and discussing : Regions / AZ / VPC / Security Groups / EBS Voume / S3 Storage,A number of demos will be done on the creation of Custom VPC , Secury Groups , EBS Disk , S3 Storage. A demo will be done showing the configuration of AWSCLI on Mac OS / Windows.EC2: We will discuss the details on EC2 / What are AMI: Amazon Machine Images.We will do a demo to create an EC2 Instance in Custom VPC ,  Install 18c XE on EC2 Instance, Backups/Recovery using RMAN Backups to S3 Storage.RDS: What is RDS / RDS for Oracle ,  Backup/ Recovery , Monitoring , Oracle Vs RDS commandsA demo will be done on Deploying Oracle 12c Database in RDS , Patching the existing version of Oracle.A Demo will show the creation of EC2 instance which will act as Apache Webserver , then we shall install Apache, PHP and show the entire process around PHP with OCI8 Connectivity.We will also discuss what is REST API and using a tool Postman call an RDS REST API.


Section 1: Introduction & What will you Learn ?

Lecture 1 Introduction

Lecture 2 What will you learn from the course ?

Section 2: Introduction to Cloud Computing

Lecture 3 What is Cloud Computing ?

Lecture 4 Benefits of Cloud Computing

Lecture 5 Types of Cloud Services: IaaS/PaaS/SaaS

Lecture 6 Top Cloud Vendors by Market Share

Section 3: Introduction to Amazon Cloud

Lecture 7 Introduction to Amazon Cloud & History

Lecture 8 What is Free Tier in AWS ?

Lecture 9 Sign-Up Process for AWS

Lecture 10 Demo: Explore Amazon Cloud Offerings

Lecture 11 Demo: Understanding AWS Cloud Management Console

Section 4: Architecture of AWS

Lecture 12 AWS Global Infrastructure : Regions

Lecture 13 What is an Availability Zone(AZ) ?

Lecture 14 Demo: Exploring Regions & AZ’s

Lecture 15 What is a Virtual Private Cloud (VPC) ?

Lecture 16 Understanding a Simple VPC with Example

Lecture 17 Demo: Create a Custom VPC

Lecture 18 What is a Security Group ?

Lecture 19 Understanding Security Group with Example

Lecture 20 Demo: Create a Security Group: websrv_sg

Lecture 21 Demo: Create a Security Group: dbsrv_sg

Lecture 22 What is an Elastic Block Store (EBS) Volume ?

Lecture 23 Demo: Create an EBS Volume

Lecture 24 What is Amazon S3 Storage ?

Lecture 25 Demo: Create an S3 Bucket

Lecture 26 Demo: Configure AWSCLI for Windows

Lecture 27 Demo : Configure AWSCLI for Mac OS

Lecture 28 Subscribe to Our YouTube Channel

Section 5: Exploring Amazon EC2 with Oracle Database

Lecture 29 What is Elastic Compute Cloud (EC2) ?

Lecture 30 What are AWS Instance Types & Amazon Machine Images (AMI)

Lecture 31 Demo: Create an EC2 Instance

Lecture 32 Demo:Create an EC2 Instance for Oracle 18c

Lecture 33 Demo: Attach an EBS Volume to EC2 Instance

Lecture 34 Demo: Download and Stage Oracle 18c XE

Lecture 35 Demo: Install Oracle 18c XE on EC2

Lecture 36 Demo: Configure Oracle Secure Backup for Cloud

Lecture 37 Demo: Configure Database Backup to S3 Storage

Lecture 38 Demo: Perform a Restore from S3 Storage

Lecture 39 Your 10 seconds will help me design new Courses

Section 6: Exploring Relational Database Service (RDS)

Lecture 40 What is Amazon RDS ?

Lecture 41 What is Amazon RDS for Oracle ?

Lecture 42 Understanding Backup & Recovery in RDS

Lecture 43 Discuss Architecture Diagram for RDS Oracle

Lecture 44 Demo: Create DB Subnet Group

Lecture 45 Provision an RDS Database for Oracle

Lecture 46 Monitoring in RDS

Lecture 47 Demo : Cloud Watch & Enhanced Monitoring

Lecture 48 Demo: Create a Manual Snapshot

Lecture 49 Demo: Restore a Database from RDS Snapshot

Lecture 50 Demo: Database Patching in RDS

Lecture 51 Understand Architecture Diagram for Webserver to Database Connectivity

Lecture 52 Demo: Configure Apache Webserver with PHP

Lecture 53 Oracle Vs RDS Commands

Lecture 54 Demo: Oracle Vs RDS Commands

Lecture 55 Demo: Connect to RDS Database using sqlplus

Lecture 56 What is REST API ?

Lecture 57 Demo: Calling a REST API using Postman

Section 7: Conclusion

Lecture 58 Conclusion

Beginner to the World of Cloud Computing & Any Experienced DBA’s / Developers looking to get Understanding around Oracle Database in AWS Cloud,Students looking to learn Oracle Database on AWS from an Architecture Standpoint

Course Information:

Udemy | English | 5h 10m | 2.12 GB
Created by: Kshitij Joy (Udemy Instructor Partner / Oracle ACE Pro)

You Can See More Courses in the IT & Software >> Greetings from

New Courses

Scroll to Top