Oracle Database on AWS: Exploring EC2 & RDS from scratch

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

Created by: Kshitij Joy (Cloud Alchemy)
Oracle Certified Master(OCM) & Oracle Cloud Architect

What Will I 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 ?

Requirements

• Oracle DBA's / Developers / DevOps

Target audience

• 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