top of page
Administer Multi-Tenant Database in Cloud

Oracle 19c DBA on AWS

Administer Multi-Tenant Database in Cloud

Count

Setup AWS. Host Oracle 19c on EC2.

Administer RDS Remotely


AWS being the #1 cloud provider, it is no doubt that one in three companies would definitely be using AWS services. Having deep understanding of AWS cloud is very critical towards setting up cloud infrastructure. Most of the online resource are created for developers or cloud architects and hardly any resources available for Database Administrators. Cloud being so simple, learning Oracle database administration on cloud should be a cakewalk!


What you will learn


  • Setup AWS account and understand different services offered by AWS infrastructure

  • Explore AWS data centre architecture, infrastructure setup and resource limits

  • Build a Linux EC2 instance and perform Oracle 19c installation pre-requisites

  • Install Oracle 19c multi-tenant database and administer multiple PDBs over one CDB

  • Administer CDB, PDB, backup, recovery and data security via Putty remotely

  • Start an Oracle RDS and administer access to application users via SQL Developer


Project work


  • Project #1 - Migrate PDB from Physical server to AWS EC2 root container

  • Project #2 - Migrate PDB running on EC2 instance to AWS RDS

Session Recordings

What is cloud

46m

AWS Management Console

1h 6m

Launch EC2 Instance

1h 42m

IAM Console

1h 11m

Install Oracle 19c

1h 46m

Create CDB & PDB

1h 44m

DB Files & Tablespaces

1h 27m

Add space to Tablespace

1h 11m

Assignment Day

18m

Users in Oracle

1h 13m

Multi-Tenant Networking

2h 14m

Users, Roles & Privileges

1h 24m

Cloud Networking & Elastic IP

1h 44m

PDB Backup & Recovery

1h 37m

AWS RDS

2h

Migration Project

1 Physical to EC2

2h 38m

Physical to EC2 Cont.

2h 41m

2 EC2 to RDS Migration

2h 38m

Notification Message!

bottom of page