Oracle Database on AWS: EC2 & RDS from Scratch

Simpliv

Course

Online

£ 5 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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?

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • Mac
  • Install
  • Private
  • Public
  • Global
  • Mac-OS
  • Mac OS
  • Database training
  • Database
  • PHP
  • Apache
  • Windows
  • Computing
  • Benefits
  • Market
  • Access

Course programme

What will you learn 1 lecture 06:46 What will you learn ? What will you learn 1 lecture 06:46 What will you learn ? What will you learn ? What will you learn ? What will you learn ? What will you learn ? Introduction to Cloud Computing 4 lectures 14:20 What is Cloud Computing ? Benefits of Cloud Computing Types of Cloud Services: IaaS/PaaS/SaaS Top Cloud Vendors by Market Share Introduction to Cloud Computing 4 lectures 14:20 What is Cloud Computing ? Benefits of Cloud Computing Types of Cloud Services: IaaS/PaaS/SaaS Top Cloud Vendors by Market Share What is Cloud Computing ? What is Cloud Computing ? What is Cloud Computing ? What is Cloud Computing ? Benefits of Cloud Computing Benefits of Cloud Computing Benefits of Cloud Computing Benefits of Cloud Computing Types of Cloud Services: IaaS/PaaS/SaaS Types of Cloud Services: IaaS/PaaS/SaaS Types of Cloud Services: IaaS/PaaS/SaaS Types of Cloud Services: IaaS/PaaS/SaaS Top Cloud Vendors by Market Share Top Cloud Vendors by Market Share Top Cloud Vendors by Market Share Top Cloud Vendors by Market Share Introduction to Amazon Cloud 5 lectures 22:43 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 Introduction to Amazon Cloud 5 lectures 22:43 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 Introduction to Amazon Cloud & History Introduction to Amazon Cloud & History Introduction to Amazon Cloud & History Introduction to Amazon Cloud & History What is Free Tier in AWS ? What is Free Tier in AWS ? What is Free Tier in AWS ? What is Free Tier in AWS ? Sign-Up Process for AWS Sign-Up Process for AWS Sign-Up Process for AWS Sign-Up Process for AWS Demo: Explore Amazon Cloud Offerings Demo: Explore Amazon Cloud Offerings Demo: Explore Amazon Cloud Offerings Demo: Explore Amazon Cloud Offerings Demo: Understanding AWS Cloud Management Console Demo: Understanding AWS Cloud Management Console Demo: Understanding AWS Cloud Management Console Demo: Understanding AWS Cloud Management Console Architecture of AWS 16 lectures 01:19:33 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 Architecture of AWS. 16 lectures 01:19:33 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 AWS Global Infrastructure : Regions Description on AWS Regions , an important part of AWS Global Infrastructure AWS Global Infrastructure : Regions Description on AWS Regions , an important part of AWS Global Infrastructure AWS Global Infrastructure : Regions Description on AWS Regions , an important part of AWS Global Infrastructure AWS Global Infrastructure : Regions Description on AWS Regions , an important part of AWS Global Infrastructure Description on AWS Regions , an important part of AWS Global Infrastructure 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. What is an Availability Zone(AZ) ? Understanding on the AZ's or Availability Zones in AWS. What is an Availability Zone(AZ) ? Understanding on the AZ's or Availability Zones in AWS. What is an Availability Zone(AZ) ? Understanding on the AZ's or Availability Zones in AWS. Understanding on the AZ's or Availability Zones in AWS. 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 Demo: Exploring Regions & AZ's A Demo on how to check the AWS Regions & AZ's Demo: Exploring Regions & AZ's A Demo on how to check the AWS Regions & AZ's Demo: Exploring Regions & AZ's A Demo on how to check the AWS Regions & AZ's A Demo on how to check the AWS 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 What is a Virtual Private Cloud (VPC) ? Understanding on the features of VPC in AWS Cloud What is a Virtual Private Cloud (VPC) ? Understanding on the features of VPC in AWS Cloud What is a Virtual Private Cloud (VPC) ? Understanding on the features of VPC in AWS Cloud Understanding on the features of VPC in AWS Cloud Understanding on the features of VPC in AWS Cloud Understanding a Simple VPC with Example Understanding a Simple VPC with Example Understanding a Simple VPC with Example Understanding a Simple VPC with Example Understanding a Simple VPC with Example Understanding a Simple VPC with Example Understanding a Simple VPC with Example Understanding a Simple VPC with Example 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. Demo: Create a Custom VPC Using AWS Console a demo showing how to create your own VPC loud (EC2) ? Understanding the basics of...

Additional information

Basic Understanding of Oracle Databases

See related categories

Oracle Database on AWS: EC2 & RDS from Scratch

£ 5 + VAT

The best Oracle courses

See all

See all