Skip to content
UdemyAWSPaid courseIntermediate levelCertificate

Oracle Database on AWS: Exploring EC2 & RDS from scratch (Udemy.com)

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

Created by: Kshitij Joy

Last updated November 2024

icon
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

How it compares

Against the other 235 rated Udemy courses in AWS on CourseDuck:

  • Rating4.2 out of 5higher than 17% of them
  • Reviews1,028#113 of 236 by number of reviews
  • Length5.2 hoursshorter than 70% of them
  • Last updatedNovember 2024more recently than 51% of them

icon
Course Description

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.


icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Kshitij Joy

Hi, I’m Kshitij Joy – a passionate educator, consultant, and Subject Matter Expert (SME) in Generative AI, Microsoft Azure, and enterprise AI solutions. With over 20+ years of experience as a Cloud Architect & Oracle Database Consultant working across global enterprises, I specialize in helping organisation's navigate their AI enablement journey by building scalable, production-ready solutions using cutting-edge technologies like OpenAI, Azure AI , Azure AI Search, and Agent-based frameworks such as LangChain and LlamaIndex.

As the founder of Cloud Alchemy Academy, I’ve trained thousands of professionals through my hands-on Udemy courses including “Generative AI: Beginner to Pro with OpenAI & Azure OpenAI” and “Meta LLaMA 3 Demystified” and Azure AI Agent Service.


I work closely with enterprises to design and deploy AI solutions that integrate Retrieval-Augmented Generation (RAG), private data copilots, and AI agents into their digital ecosystems. While my current focus is on Azure and Gen AI, I’m also proud to be recognized as an Oracle ACE Pro, bringing deep cross-platform expertise to every project. Whether you're just getting started with AI or looking to drive innovation at scale, my mission is to equip you with the skills and strategies to succeed in the rapidly evolving world of Generative AI.

icon
More courses by Kshitij Joy

$19.99

$69.99

$10.99

$10.99

$69.99

$69.99

icon
More AWS courses

$99.99

$49.99

$99.99

$124.99

$22.99

$84.99

icon
Reviews

4.2

1,028 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Theresa Hurd on 3/13/2025

I liked the content; there were examples to show how to implement things and check on certain things within AWS. I benefit from this since I am a visual learner. Could have been better had a handful of the lessons did not work would not run. Other than that, pretty good course.

By Saksham Aware on 12/22/2020

This course was good....but need more DBA specific tasks user management ,tablespace management ....all these things under AWS how they work...that want to know ....more commands and vidoes on that would have been handy .

By Anonymized User on 6/19/2020

Interesting course from 0 to AWS base knowledge for the ones who don't know already it. I rediscovered some good stuff to know ! :) Oracle EC2 and Oracle RDS sections are also interesting to follow. Regarding Oracle RDS I had the chance to practice a few in a recent past. The author doesn't detail about Options Groups menu (Oracle) and especially Database Parameter Groups which is used to change and customize (most) Oracle Database parameters. So some more sections could be added in that way. In my own opinion that's a lack of the course Sound quality for some sections are not homogeneous and should be improved. I nevertheless globally enjoyed the course Thanks you Kshitij for the step-by-steps practice examples ! :)

By Anonymized User on 5/18/2020

I thought the course was very good. The problem I had with it is the instructor words fade off and several times I didn't understand what he was saying. I did have the captions on ... the translation from instructor to words was atrocious. Someone should really look into a better translation tool. Also, when the instructor goes to the Windows screen to enter commands, change the background from dark to light and make the font bigger ... both of those changes are for easier readability. Outside of these issues, I think the course was very good.

By Cihan Ceylan on 3/10/2020

I appreciated your effort. I would recommend anybody who is looking for Oracle on AWS or Oracle on AWS RDS . Training was so technical and detailed. Also you may prepare a few use case scenarios regarding cloud migration / problem solving / performance tuning / sql tuning. thanks a lot

By Saurabh Agrawal on 8/30/2019

very informational course. All concepts are explained very well . It gives me confidence to manage Oracle Databases on AWS in real world Note. - It will be better if more labs (step by step) are included in the course which students can follow and create exactly same environment in cloud

By Vinod Subramanian on 6/29/2019

The scp command to transfer rpm to ec2 instance does not work on windows. I spent over 4 hours googling and yet to find a solution. I have done many other courses on udemy where care is taken to address such difficulties in OS other than the one the trainer is using. The trainer should think about these things.

By Anurag Kumar on 4/1/2019

The course was really very good and understanding. Learned a lot and everything was quiet practically explained. Last videos 53-56 I felt were explained a bit faster. Best wishes to you for new tutorials. Thanks so much for sharing your knowledge with us. God Bless You!!

By Chandra Narla on 3/18/2019

This is an excellent presentation. Initially(before starting the course), I didn't expect you are going to give this much clear information on each topic. Once started I realized and getting much more interested in each topic. Because you covered the major aws key topics along with rds. Soi refreshed my aws skills. It would be helpful if you can add some examples like migrate existing small DB from on-premises to aws-cloud and Daily life and a typical day scenario as AWS DBA point of view, etc.. anyhow really thanks for your presentation. :-) good news for you I am going to buy another course of yours. I am sure it will also Rock. -- Thanks n Regards, _________________________ Chandra DevOps Engineer/DBA

By Manjunath Maller on 1/11/2019

Its a wonderful course for Oracle on AWS.You will quickly get your hands dirty on how to install 18cXE (RPM style) on an EC2 instance.The instructor then goes deep dive into Oracle on RDS (Setup,Backup,Recovery,Monitoring,Commands differences etc).A very nice example of PHP setup on EC2 connecting to RDS in a Virtual Private Cloud is shown.That gives a 360 view of simple 2 tier architecture seperated over diff subnets(Public and Private) inside of a VPC.The world of cloud is indeed amazing.Enjoyed the course thoroughly.Keep them coming Kshitij Joy.

Showing all 10 reviews on CourseDuck

Read all 1,028 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100