
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!