Oracle DBA 26ai

24 Lessons
365-day access

Self-Paced Course

(Upgrade course for Oracle DBAs)

About the Course

Who can take this course?

This course is designed for existing Oracle DBAs who wish to learn multi-tenant container database (CDB) administration. If you are new to multi-tenant container database (CDB), this course is for you.

What you will learn?

You will learn Oracle Database Administration from a Multi-tenant Container Database (CDB) perspective. You will understand the difference between administering a non-CDB database and CDB database.

How long is the course?

This course is a quick but yet detailed one that will help you understand CDB administration in around 10 hours time. You can learn at your own pace and convenience.

Introduction to Oracle AI Database 26ai

Database and Database Instance

About Multitenant Architecture

Preview

Installing Oracle AI Database 26ai

Installing Oracle Linux 9.6

Preview

Installing Oracle AI Database 26ai

Container Database Administration

About Containers

Preview

Working with Containers

Preview

About Database Services

Startup and Shutdown of CDB, PDB

Physical Structure of a CDB

Creating PDBs

Data Dictionary in a CDB

Initialization Parameters in CDB

Users, Roles, Privileges in a CDB

Tablespaces, Data Files, Control Files, Online Log Files, Archiving in CDB

Backup and Recovery

Performing Backup of a CDB

Reporting on RMAN operations

About Complete Recovery in a CDB

Lab : Performing Complete Recovery

About Point-In-Time Recovery in a CDB

Lab : Performing In-Complete Recovery

Flashback Database

About Flashback Database

Lab : Performing Flashback Database operation on CDB

Lab : Performing Flashback Database operation on a PDB

Data Pump

Using Data Pump in CDB