If you need a study outline, the official workshop typically covers:
| Module | Topics | |--------|--------| | 1 | Installing Oracle Database 19c software | | 2 | Creating a database (DBCA, manual) | | 3 | Managing database instances (starting/stopping, parameter files) | | 4 | Managing storage (tablespaces, data files, ASM) | | 5 | User security and privileges | | 6 | Managing undo data and redo logs | | 7 | Backup & Recovery (RMAN) | | 8 | Monitoring and tuning basics | | 9 | Oracle Net Services (listener, tnsnames) | Change a parameter at runtime:
| Resource | Purpose | |----------|---------| | Oracle Database 19c: Admin Guide (free Oracle docs) | Complete reference – but dry and example-light | | OCA/OCP Oracle Database 19c Exam Guide (S. Bersinic) | Exam-focused, includes answers, but less lab work | | Oracle Live SQL (free web) | Quick practice for SQL and basic admin | | YouTube: Oracle DBA 19c Playlist (Oracle Learning) | Free video walkthroughs of same topics | If you need a study outline, the official
Each lab states: Purpose, Time, Steps, Verification.
Example: “Lab 5-2: Configure a listener for a pluggable database using LREG dynamic registration.”
The step-by-step format is excellent for self-practice (if you have access to a 19c installation). Indexing strategies, explain plan (EXPLAIN PLAN FOR
Each PDF includes a “Practices” section at the end of each module. These labs are identical to those delivered in Oracle University’s live environment (live SQL, ORCL, or PDBs). By following the PDF, you can recreate the labs in your own VirtualBox or cloud environment.