Earn your Oracle OCP — and know every line of it
The only exam prep school built exclusively for the 1Z0-083 — covering every domain from Multitenant architecture and RMAN backup strategies to Grid Infrastructure, Flashback, and SQL tuning, with real syntax you'll use the moment the exam is behind you.
"Every command I teach you, I expect you to be able to type from memory on the exam — and execute without hesitation in production the next morning."
— Carla Paton
What you'll learn
What you'll be able to do
- Configure, create, and manage Container Databases (CDBs) and Pluggable Databases (PDBs), including application containers, seeds, and plug/unplug operations
- Design and execute comprehensive RMAN backup strategies — full, incremental, compressed, encrypted, duplexed, archival, and ASM metadata backups
- Restore and recover CDBs, PDBs, and non-database files using RMAN and non-RMAN techniques, and apply point-in-time and Flashback recovery for any failure scenario
- Install, patch, and upgrade Oracle Grid Infrastructure and Oracle Database 19c software, including RPM-based installation and Rapid Home Provisioning
- Implement Multitenant security: PDB lockdown profiles, unified auditing across CDBs and PDBs, and application-container policy management
- Tune SQL statements and manage CDB/PDB resource allocation with Oracle Resource Manager, and diagnose RMAN performance issues and block corruption
How it works
A school that adapts to you
This isn't a set of static videos. Every lesson is generated live and tuned to where you actually are.
We learn your level
A quick placement check tailors your starting point so you're never bored or lost.
Lessons adapt as you go
Each lesson is written for your pace and your goal, adjusting as your skills grow.
Your AI coach keeps you moving
Checkpoints, feedback, and gentle nudges turn progress into a real result.
The curriculum
What's inside your school
0 modules · 0 lessons
Creating CDBs and Regular PDBs
Covers configuring and building a CDB from scratch, creating PDBs from the CDB seed, and exploring the internal structure of pluggable databases.
- 1.1Configure and Create a CDBIncluded
- 1.2Create a New PDB from the CDB SeedIncluded
- 1.3Explore the Structure of PDBsIncluded
Managing CDBs and PDBs
Teaches day-to-day administration of CDBs and PDBs including services, startup/shutdown, mode changes, and parameter management.
- 2.1Manage PDB Service Names and ConnectionsIncluded
- 2.2Manage Startup, Shutdown, and Availability of CDBs and PDBsIncluded
- 2.3Change the Different Modes and Settings of PDBsIncluded
- 2.4Evaluate the Impact of Parameter Value ChangesIncluded
- 2.5Control CDB and PDB Resource Usage with Oracle Resource ManagerIncluded
Application PDBs and Plug/Unplug Operations
Explores application containers, seeds, and PDB lifecycle operations including cloning, plugging, unplugging, and undo mode selection.
- 3.1Explain the Purpose of Application Root and Application SeedIncluded
- 3.2Define and Create Application PDBsIncluded
- 3.3Install, Upgrade, and Patch Applications in Application ContainersIncluded
- 3.4Clone PDBs and Application ContainersIncluded
- 3.5Plug and Unplug Operations with PDBs and Application ContainersIncluded
- 3.6Comparing Local Undo Mode and Shared Undo ModeIncluded
Multitenant Security, Auditing, and Lockdown
Covers securing the multitenant environment through PDB lockdown profiles, unified auditing, and application-container policy management.
- 4.1Manage Security in Multitenant DatabasesIncluded
- 4.2Manage PDB Lockdown ProfilesIncluded
- 4.3Audit Users in CDBs and PDBsIncluded
- 4.4Manage Other Types of Policies in Application ContainersIncluded
RMAN Backup Strategies and Configuration
Builds a complete RMAN skill set from initial configuration and catalog setup through every backup type and media management option.
- 5.1Configure RMAN and the Database for RecoverabilityIncluded
- 5.2Configure and Use an RMAN Recovery CatalogIncluded
- 5.3Perform Full and Incremental Backups and RecoveriesIncluded
- 5.4Compress and Encrypt RMAN BackupsIncluded
- 5.5Use a Media ManagerIncluded
- 5.6Create Multi-Section, Duplexed, and Archival BackupsIncluded
- 5.7Backup Recovery Files, Non-Database Files, and ASM MetadataIncluded
- 5.8Perform Backup and Recovery of CDBs and PDBsIncluded
Restore, Recovery, and Flashback Technologies
Covers all recovery scenarios from crash recovery through point-in-time and Flashback operations for CDBs, PDBs, and non-database files.
- 6.1Restore and Recover Databases with RMANIncluded
- 6.2Perform Non-RMAN Database RecoveryIncluded
- 6.3Describe and Use Recovery Technology for Crash, Complete, and Point-in-Time RecoveryIncluded
- 6.4Configure Your Database to Support FlashbackIncluded
- 6.5Perform Flashback OperationsIncluded
- 6.6Perform CDB and PDB FlashbackIncluded
Duplicating Databases and Transporting Data
Teaches active database duplication, PDB duplication, and all methods for transporting data between Oracle databases.
- 7.1Duplicate a DatabaseIncluded
- 7.2Duplicate an Active PDBIncluded
- 7.3Transport DataIncluded
Diagnosing Failures, RMAN Troubleshooting, and Tuning
Equips DBAs to detect block corruption, diagnose database issues with ADR, troubleshoot RMAN errors, and resolve RMAN performance bottlenecks.
- 8.1Detect and Repair Database and Block CorruptionIncluded
- 8.2Diagnose Database IssuesIncluded
- 8.3Interpret the RMAN Message OutputIncluded
- 8.4Diagnose RMAN Performance IssuesIncluded
- 8.5Use New Diagnosability FeaturesIncluded
Installing Grid Infrastructure and Oracle Database
Walks through installing, configuring, and verifying Oracle Grid Infrastructure for a standalone server and the Oracle 19c Database software.
- 9.1Install Grid Infrastructure for a Standalone ServerIncluded
- 9.2Install Oracle Database SoftwareIncluded
- 9.3Create, Delete, and Configure Databases Using DBCAIncluded
- 9.4Configure and Use Oracle Restart to Manage ComponentsIncluded
- 9.5Rapid Home ProvisioningIncluded
Patching, Upgrading Grid Infrastructure, and Upgrading Oracle Database
Covers the complete lifecycle of applying patches and upgrading both Grid Infrastructure and Oracle Database to 19c.
- 10.1Patch Grid Infrastructure and Oracle DatabaseIncluded
- 10.2Upgrade Oracle Grid InfrastructureIncluded
- 10.3Plan for Upgrading an Oracle DatabaseIncluded
- 10.4Upgrade an Oracle DatabaseIncluded
- 10.5Perform Post-Upgrade TasksIncluded
- 10.6Upgrade an Oracle Database — CDB and PDB ScopeIncluded
19c New Features and General Enhancements
Surveys key Oracle 19c and 18c new features spanning installation, availability, diagnosability, and SQL performance tuning tested on the exam.
- 11.1Image and RPM-Based Database InstallationIncluded
- 11.2Use Miscellaneous 19c New FeaturesIncluded
- 11.3Use an RMAN Recovery Catalog — 19c EnhancementsIncluded
- 11.4Use Flashback Database — Availability EnhancementsIncluded
- 11.5Tune SQL StatementsIncluded
Who it's for
Is this you?
OCA-Certified DBA
Holds the Oracle Database Administration I certification and is ready to complete the OCP credential by conquering the 1Z0-083.
Senior Database Administrator
Has years of hands-on Oracle DBA experience and needs a structured, exam-focused path to formalize expertise with the OCP credential.
Multitenant Migrator
Working on or planning a migration to Oracle's Multitenant architecture and needs deep, practical knowledge of CDBs, PDBs, and application containers.
Database Architect
Designing enterprise Oracle environments and wants authoritative command of RMAN strategy, Grid Infrastructure, and recovery architecture at OCP depth.
DBA Upskilling for 19c
Experienced on earlier Oracle versions and needs to get current on 19c new features — RPM-based installation, Rapid Home Provisioning, and Flashback enhancements.
IT Professional Pivoting to DBA
Has a strong technical background and equivalent Oracle experience, and is pursuing the OCP as a career-defining credential in database administration.
Questions
Frequently asked
Your teacher
A note from your teacher
Carla Paton
If you've made it to the 1Z0-083, you're not a beginner. You know how databases work. You've dealt with failed jobs at 2 a.m., you've navigated parameter changes that rippled across an environment in ways nobody anticipated, and you've probably spent time wondering whether your backup strategy would actually hold up when it mattered. You don't need someone to explain what a database is. What you need is a precise, no-filler path through the exact material the 1Z0-083 tests — and confidence that you won't walk into the exam room and hit a domain you underestimated.
That's exactly what I built this school to deliver.
The OCP credential is worth earning, but the exam is genuinely demanding. Multitenant carries significant weight — and it's the area where experienced DBAs most often underestimate how much Oracle expects you to know. CDB and PDB creation, application containers, plug/unplug operations, local versus shared undo mode, lockdown profiles, unified auditing across container scope — these aren't topics you can skim. This school goes through each one with the depth and real SQL syntax the exam demands. Same with RMAN: not just "what is a backup" but the full strategy layer — recovery catalogs, encrypted and duplexed backups, multi-section backups, ASM metadata, and CDB/PDB-scoped recovery.
I don't pad the curriculum. Every section you'll work through maps to exam domains and real-world application. When we cover Grid Infrastructure installation, Rapid Home Provisioning, and upgrade paths, it's because those topics appear on the exam and because you'll encounter them on the job. When we get into SQL tuning and Oracle Resource Manager for CDB/PDB resource allocation, it's because a professional-level credential means you can diagnose and fix performance problems — not just describe them.
Here's the thing about the OCP that I want you to internalize: it's not a trivia test. Oracle built this exam to validate that you can make correct decisions under pressure — choose the right recovery strategy, configure the right lockdown profile, interpret RMAN output and know what it's telling you. That's what this school trains. Every concept is explained precisely, every command is shown in full, and every exam domain is covered so you can sit for the 1Z0-083 knowing there are no blind spots.
If you're ready to close the gap between where you are and the OCP credential, this is where you do it. Let's get to work.
— Carla Paton
Start your journey today
Get instant access — learn at your own pace with an AI coach in your corner.
$59/mo
Recurring billing · cancel anytime
Secure checkout · Instant access
- 11 modules, 56 lessons
- AI-adaptive lessons tuned to your level
- Quizzes & checkpoints to lock in progress
- Your own AI learning coach
- Learn on any device, at your pace
- Full access for as long as you're subscribed