Oracle Database on AWS: Exploring EC2 & RDS from scratch

Name: Oracle Database on AWS: Exploring EC2 & RDS from scratch
Rating: 4.2 (1025 reviews)

Architecture ,Database Deployments with 18c/12c , Webserver Connectivity ,Demos on EC2/RDS from Architectural Standpoint

Created byKshitij Joy (Cloud Alchemy)

Last updated 11/2024

English

English [Auto],Spanish [Auto],

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 ?

Course content

7 sections • 58 lectures • 5h 10m total length

Introduction1:11
Master Oracle database on AWS by exploring EC2 and RDS from scratch, guided by Joy from DB Alchemist, with emphasis on Exadata patching and Oracle Cloud Infrastructure fundamentals.
What will you learn from the course ?6:46
Learn architecture-driven Oracle on AWS, building a custom VPC with public and private subnets. Connect PHP on Apache to Oracle and explore EC2, RDS, and backups.

AWS Global Infrastructure : Regions3:21
What is an Availability Zone(AZ) ?4:12
Demo: Exploring Regions & AZ's2:57
What is a Virtual Private Cloud (VPC) ?8:37
Understanding a Simple VPC with Example2:23
build a simple vpc with cidr 10.0.0.0/16 across a single availability zone, with public and private subnets, a network acl, and routing through an internet gateway.
Demo: Create a Custom VPC6:32
What is a Security Group ?4:28
Understanding Security Group with Example3:07
Demo: Create a Security Group: websrv_sg5:38
Create a web server security group in the VPC and configure inbound SSH (port 22) and HTTP (port 80) rules to secure EC2 web traffic and prepare the RDS setup.
Demo: Create a Security Group: dbsrv_sg3:26
What is an Elastic Block Store (EBS) Volume ?4:19
Demo: Create an EBS Volume3:22
What is Amazon S3 Storage ?3:57
Demo: Create an S3 Bucket5:47
Demo: Configure AWSCLI for Windows6:49
Demo : Configure AWSCLI for Mac OS10:31
Subscribe to Our YouTube Channel0:13

What is Elastic Compute Cloud (EC2) ?5:55
What are AWS Instance Types & Amazon Machine Images (AMI)4:24
Explore AWS EC2 instance types, including general purpose, compute optimized, memory optimized, accelerated computing, and storage optimized. Learn how to select the right instance type for your workload and ami.
Demo: Create an EC2 Instance7:00
Navigate the AWS console to launch an EC2 instance, choosing an AMI, instance type, storage, and tags, then follow the six-step process to configure VPC, security groups, review, and launch.
Demo:Create an EC2 Instance for Oracle 18c11:09
Demo: Attach an EBS Volume to EC2 Instance5:17
Demo: Download and Stage Oracle 18c XE6:03
Demo: Install Oracle 18c XE on EC28:21
Install Oracle 18c xe on EC2 by downloading the preinstalled database, enabling red hat extras, and using yum; configure the Oracle home and pluggable databases in /u01/app/oracle/oradata.
Demo: Configure Oracle Secure Backup for Cloud4:12
Demo: Configure Database Backup to S3 Storage5:44
Demonstrates configuring Oracle Secure Backup cloud module to back up an Oracle database to S3 using the SBT interface, including archive log mode and verifying backup pieces.
Demo: Perform a Restore from S3 Storage5:22
Learn to restore from S3 storage and recover a corrupted Oracle database using backup pieces, restore data files, apply media recovery, and open the database.
Your 10 seconds will help me design new Courses0:13
A 10 Second Survey

What is Amazon RDS ?4:29
What is Amazon RDS for Oracle ?8:11
Explore Amazon RDS for Oracle, covering two licensing models: bring your own license and license included, with automated backups, CloudWatch monitoring, and multi-AZ deployments.
Understanding Backup & Recovery in RDS4:18
Discuss Architecture Diagram for RDS Oracle1:07
Explain the architecture diagram for deploying an Oracle RDS in a private subnet within a VPC, and outline steps to create an Amazon RDS for Oracle using 12c.
Demo: Create DB Subnet Group5:08
Shows how to create a db subnet group for Oracle in a vpc demo by using private subnets across availability zones for an rds Oracle deployment.
Provision an RDS Database for Oracle17:31
Monitoring in RDS5:07
Demo : Cloud Watch & Enhanced Monitoring7:20
Illustrates configuring CloudWatch monitoring and enhanced monitoring for an Oracle database on AWS, including metrics like CPU utilization, DB connections, free memory, write and read ops, logs, and creating alarms.
Demo: Create a Manual Snapshot4:30
Explore AWS backups and recovery for Oracle databases using storage snapshots, manual snapshot creation, and incremental snapshots, with guidance on io suspension and multi-az deployments.
Demo: Restore a Database from RDS Snapshot4:17
Demo: Database Patching in RDS8:43
Understand Architecture Diagram for Webserver to Database Connectivity2:30
Explore web server to database connectivity on AWS by wiring Apache on EC2 with PHP to Oracle 12c in a private subnet, and display data on a PHP page.
Demo: Configure Apache Webserver with PHP25:52
Oracle Vs RDS Commands5:53
Explore how Oracle commands map to RDS operations in AWS, using the admin_util package to perform tasks such as kill sessions, flush shared pool, switch log files, and manage privileges.
Demo: Oracle Vs RDS Commands3:09
Demo: Connect to RDS Database using sqlplus5:08
What is REST API ?2:46
Demo: Calling a REST API using Postman5:09

Requirements

Oracle DBA's / Developers / DevOps

Description

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 commands

A 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.

Who this course is for:

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

Oracle Database on AWS: Exploring EC2 & RDS from scratch

What you'll learn

Explore related topics

Course content

Introduction & What will you Learn ?2 lectures • 8min

Introduction to Cloud Computing4 lectures • 14min

Introduction to Amazon Cloud5 lectures • 23min

Architecture of AWS17 lectures • 1hr 20min

Exploring Amazon EC2 with Oracle Database11 lectures • 1hr 4min

Exploring Relational Database Service (RDS)18 lectures • 2hr 1min

Conclusion1 lecture • 1min

Requirements

Description

Who this course is for: