Oracle Database on AWS: Exploring EC2 & RDS from scratch

Explore the basics of cloud computing and how computing resources are delivered as services over the internet from data centers. Learn about servers, storage, databases, networking, and applications.

Explore the benefits of cloud computing, including cost savings, rapid provisioning, scalable resources, boosted productivity, improved performance, and reliable disaster recovery with mirrored data and availability domains.

Explore the cloud stack of IaaS, PaaS, and SaaS, with IaaS providing servers and networks, PaaS adding middleware and databases, and SaaS delivering cloud apps.

Explore how Amazon web services emerged, define what aws is, and trace its history from a garage startup to launching s3 and ec2 in 2006.

Discover the AWS free tier as your entry point, detailing 12-month and always-free offers, including 750 hours of t2 micro EC2, 5 GB S3 storage, and RDS BYOL for Oracle.

Navigate the AWS management console to access services like EC2 and databases, sign in, select regions, and pin frequent tasks for quick access.

Explore how to view AWS regions and availability zones in the console, and understand how selecting a region affects where EC2 services and databases are created.

build a simple vpc with cidr 10.0.0.0/16 across a single availability zone, with public and private subnets, a network acl, and routing through an internet gateway.

Launch the VPC wizard in the AWS console to create a VPC with public and private subnets, a NAT instance, and outbound internet access.

Discover how a security group acts as a virtual firewall for EC2 instances, controlling inbound and outbound traffic with rules, and how to separate web and database servers.

Explore security groups as a layer protecting AWS EC2 and RDS, linking a public subnet web server to a private subnet database on ports 22, 80, and 1521.

Create a web server security group in the VPC and configure inbound SSH (port 22) and HTTP (port 80) rules to secure EC2 web traffic and prepare the RDS setup.

Learn about elastic block store (EBS) for EC2: persistent block storage that survives instance life, with SSD or HDD options, encryption, and snapshots to S3 for relational databases to NoSQL.

Learn how Amazon S3 storage stores data as objects in buckets, accessible over the internet, with 11 nines durability, query in place, and support for backups, archiving, and disaster recovery.

Demonstrate how to create an Amazon S3 bucket, set private permissions, enable versioning, and upload an image, illustrating S3 as storage for the internet.

Explore AWS EC2 instance types, including general purpose, compute optimized, memory optimized, accelerated computing, and storage optimized. Learn how to select the right instance type for your workload and ami.

Navigate the AWS console to launch an EC2 instance, choosing an AMI, instance type, storage, and tags, then follow the six-step process to configure VPC, security groups, review, and launch.

Launch an Oracle 18c EC2 instance in a public subnet, select a suitable t2.small, configure storage and security groups, create a key pair, and SSH in.

Learn how to download, transfer, and install Oracle 18c XE on an AWS EC2 instance, including using a pre-installed rpm, enabling extras repositories, and configuring the database.

Install Oracle 18c xe on EC2 by downloading the preinstalled database, enabling red hat extras, and using yum; configure the Oracle home and pluggable databases in /u01/app/oracle/oradata.

Demonstrates configuring Oracle Secure Backup cloud module to back up an Oracle database to S3 using the SBT interface, including archive log mode and verifying backup pieces.

Learn to restore from S3 storage and recover a corrupted Oracle database using backup pieces, restore data files, apply media recovery, and open the database.

Explore Amazon RDS for Oracle, covering two licensing models: bring your own license and license included, with automated backups, CloudWatch monitoring, and multi-AZ deployments.

explore how rds automates backups within a chosen window using storage snapshots, and perform manual backups; learn point-in-time recovery by creating a new instance from base and incremental backups.

Explain the architecture diagram for deploying an Oracle RDS in a private subnet within a VPC, and outline steps to create an Amazon RDS for Oracle using 12c.

Shows how to create a db subnet group for Oracle in a vpc demo by using private subnets across availability zones for an rds Oracle deployment.

Provision an Oracle RDS instance in AWS via the management console, selecting standard edition two with license included, VPC subnet groups, security groups, backups, and monitoring.

Illustrates configuring CloudWatch monitoring and enhanced monitoring for an Oracle database on AWS, including metrics like CPU utilization, DB connections, free memory, write and read ops, logs, and creating alarms.

Explore AWS backups and recovery for Oracle databases using storage snapshots, manual snapshot creation, and incremental snapshots, with guidance on io suspension and multi-az deployments.

Restore a new RDS environment from a snapshot, using manual or automated backups, then configure license model, instance class, VPC, subnet, and accessibility before the instance becomes available.

Learn how AWS RDS upgrades Oracle databases, including version mapping from 12 102 v13 to 12 102 v14, applying PSUs, and automated snapshots before and after upgrades.

Explore web server to database connectivity on AWS by wiring Apache on EC2 with PHP to Oracle 12c in a private subnet, and display data on a PHP page.

Explore how Oracle commands map to RDS operations in AWS, using the admin_util package to perform tasks such as kill sessions, flush shared pool, switch log files, and manage privileges.

Compare Oracle on-premises commands with RDS equivalents and show how to run admin util procedures to flush the shared pool, flush the buffer cache, checkpoint data, and switch log files.

Understand what a rest api is and how representational state transfer powers scalable cloud tasks, using http methods and json with Postman for db snapshot operations on Oracle Cloud.

Demonstrates calling the AWS RDS create db snapshot API with Postman, configuring the db instance identifier, db snapshot identifier, and signature details with authorization to observe the snapshot creation process.

Conclude this course with renewed confidence to work in the cloud, embracing the journey ahead and continuing your learning beyond these early days.