Oracle Database On AWS: EC-II & RDS From Scratch

Education, IT

Start date

18/12/2019

End date

16/03/2020

Overview

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.

What you will learn

What will you 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?

What you require

Basic knowledge

  • Basic Understanding of Oracle Databases

Where

Venue

Online Courses, SW12AA

Google Map