Skip to content

IT : Database | Oracle Database on AWS: EC2 & RDS from Scratch

Database, Online Database Administrator Course, Classroom Database Courses & Training, Advanced Database Course

Simpliv LLC

Summary

Price
£50 inc VAT
Or £16.67/mo. for 3 months...
Study method
Online
Duration
6 hours · Self-paced
Access to content
Lifetime access
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

Overview

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

Description

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?

Who is this course 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
Students also bought

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Certificates

Certificate of completion

Digital certificate - Included

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: Database, IT
Related searches: Online courses