Library

Course: Oracle Database on AWS: EC2 & RDS from Scratch

Oracle Database on AWS: EC2 & RDS from Scratch

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
  • Self-Paced
About this Course

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.

Basic knowledge
  • Basic Understanding of Oracle Databases
What you will 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?
Curriculum
Number of Lectures: 54
Total Duration: 05:02:59
What will you learn
  • What will you learn ?  
Introduction to Cloud Computing
  • What is Cloud Computing ?  
  • Benefits of Cloud Computing  
  • Types of Cloud Services: IaaS/PaaS/SaaS  
  • Top Cloud Vendors by Market Share  
Introduction to Amazon Cloud
  • Introduction to Amazon Cloud & History  
  • What is Free Tier in AWS ?  
  • Sign-Up Process for AWS  
  • Demo: Explore Amazon Cloud Offerings  
  • Demo: Understanding AWS Cloud Management Console  
Architecture of AWS
  • AWS Global Infrastructure : Regions  

    Description on AWS Regions , an important part of AWS Global Infrastructure

  • What is an Availability Zone(AZ) ?  

    Understanding on the AZ's or Availability Zones in AWS.

  • Demo: Exploring Regions & AZ's  

    A Demo on how to check the AWS Regions & AZ's

  • What is a Virtual Private Cloud (VPC) ?  

    Understanding on the features of VPC in AWS Cloud

  • Understanding a Simple VPC with Example  

    Understanding a Simple VPC with Example

  • Demo: Create a Custom VPC  

    Using AWS Console a demo showing how to create your own VPC.

  • What is a Security Group ?  

    Understanding the features of a Security Group.

  • Understanding Security Group with Example  

    Understanding Security Group with Example

  • Demo: Create a Security Group: websrv_sg  

    Create a Security Group for a Webserver

  • Demo: Create a Security Group: dbsrv_sg  

    Create a Security Group for Database

  • What is an Elastic Block Store (EBS) Volume ?  

    What is an Elastic Block Store (EBS) Volume ?

  • Demo: Create an EBS Volume  

    A demo showing the creation of EBS Volume in AWS

  • What is Amazon S3 Storage ?  

    Understand the features of S3 Storage

  • Demo: Create an S3 Bucket  

    A Demo showing the creation of S3 Buckets in AWS Cloud

  • Demo: Configure AWSCLI for Windows  

    How to Configure the AWSCLI on Windows

  • Demo : Configure AWSCLI for Mac OS  
Exploring Amazon EC2 with Oracle Database
  • What is Elastic Compute Cloud (EC2) ?  

    Understanding the basics of EC2 on AWS

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

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

  • Demo: Create an EC2 Instance  
  • Demo:Create an EC2 Instance for Oracle 18c  
  • Demo: Attach an EBS Volume to EC2 Instance  

    Demo: Attach an EBS Volume to EC2 Instance

  • Demo: Install Oracle 18c XE on EC2  
  • Demo: Configure Oracle Secure Backup for Cloud  

    Demo: Configure Oracle Secure Backup for Cloud

  • Demo: Configure Database Backup to S3 Storage  

    Demo: Configure Database Backup to S3 Storage

  • Demo: Perform a Restore from S3 Storage  

    Demo: Perform a Restore from S3 Storage

Exploring Relational Database Service (RDS)
  • What is Amazon RDS ?  

    What is Amazon RDS ?

  • What is Amazon RDS for Oracle ?  

    What is Amazon RDS for Oracle ?

  • Understanding Backup & Recovery in RDS  

    Understanding Backup & Recovery in RDS

  • Discuss Architecture Diagram for RDS Oracle  

    Discuss Architecture Diagram for RDS Oracle

  • Demo: Create DB Subnet Group  

    Demo: Create DB Subnet Group

  • Provision an RDS Database for Oracle  
  • Monitoring in RDS  

    The different ways in which you can monitor RDS

  • Demo : Cloud Watch & Enhanced Monitoring  

    Demo : Cloud Watch & Enhanced Monitoring

  • Demo: Create a Manual Snapshot  

    Demo: Create a Manual Snapshot

  • Demo: Restore a Database from RDS Snapshot  

    Demo: Restore a Database from RDS Snapshot

  • Demo: Database Patching in RDS  

    Demo: Database Patching in RDS

  • Understand Architecture Diagram for Webserver to Database Connectivity  

    Understand Architecture Diagram for Webserver to Database Connectivity

  • Demo: Configure Apache Webserver with PHP  

    Demo: Configure Apache Webserver with PHP

  • Oracle Vs RDS Commands  

    Oracle Vs RDS Commands

  • Demo: Oracle Vs RDS Commands  

    Demo: Oracle Vs RDS Commands

  • Demo: Connect to RDS Database using sqlplus  

    Demo: Connect to RDS Database using sqlplus

  • What is REST API ?  

    What is REST API ?

  • Demo: Calling a REST API using Postman  

    Demo: Calling a REST API using Postman

Conclusion
  • Conclusion  
Reviews (1)
2 months before
more for DB Admin sties ad for developer, but interesting