1. Exploring the Oracle Database 19c Architecture
2. List the architectural components of Oracle Database 19c
3. Explain the memory structures
4. Describe the background processes
5. Explain the relationship between logical and physical storage structures
6. Oracle Database Management Tools
7. Use database management tools
8. Oracle Database Instance
9. Understand initialization parameter files
10. Start up and shut down an Oracle database instance
11. View the alert log and access dynamic performance views
12. Configuring the Oracle Network Environment
13. Configure Oracle Net Services
14. Use tools for configuring and managing the Oracle network
15. Configure client-side network
16. Configure communication between databases
17. Managing Database Storage Structures
18. Describe the storage of table row data in blocks
19. Create and manage tablespaces

1. Administering User Security
2. Create and manage database user accounts
3. Grant and revoke privileges
4. Create and manage roles
5. Create and manage profiles
6. Managing Space
7. Explain how Oracle database server automatically manages space
8. Save space by using compression
9. Proactively monitor and manage tablespace space usage
10. Use the Segment Advisor
11. Reclaim wasted space from tables and indexes by using the segment shrink functionality
12. Manage resumable space allocation
13. Managing Undo Data
14. Explain DML and undo data generation
15. Monitor and administer undo data
16. Describe the difference between undo data and redo data
17. Configure undo retention
18. Managing Data Concurrency
19. Describe the locking mechanism and how Oracle manages data concurrency
20. Monitor and resolve locking conflicts
21. Implementing Oracle Database Auditing
22. Explain DBA responsibilities for security and auditing

Enable standard database auditing and unified auditing

1. Backup and Recovery Concepts
2. Identify the importance of checkpoints, redo log files, and archive log files
3. Backup and Recovery Configuration
4. Configure the fast recovery area
5. Configure ARCHIVELOG mode
6. Performing Database Backups
7. Create consistent database backups
8. Back up your database without shutting it down
9. Create incremental backups
10. Automate database backups
11. Manage backups
12. Performing Database Recovery
13. Determine the need for performing recovery
14. Use Recovery Manager (RMAN) and the Data Recovery Advisor to perform recovery of the control file, redo log file and data file
15. Moving Data
16. Describe ways to move data
17. Use SQL*Loader to load data from a non-Oracle database
18. Use external tables to move data via platform-independent files
19. Explain the general architecture of Oracle Data Pump
20. Use Data Pump Export and Import to move data between Oracle databases

1. Performing Database Maintenance
2. Manage the Automatic Workload Repository (AWR)
3. Use the Automatic Database Diagnostic Monitor (ADDM)
4. Describe and use the advisory framework
5. Set alert thresholds
6. User server-generated alerts
7. Use automated tasks
8. Managing Performance
9. Use Automatic Memory Management
10. Use the Memory Advisor to size memory buffers
11. Managing Performance: SQL Tuning
12. Manage optimizer statistics
13. Use the SQL Tuning advisor
14. Use the SQL Access Advisor to tune a workload
15. Managing Resources Using Database Resource Manager
16. Configure the Database Resource Manager
17. Access and create resource plans
18. Monitor the Resource Manager
19. Automating Tasks by Using Oracle Scheduler
20. Use Oracle Scheduler to simplify management tasks
21. Use job chains to perform a series of related tasks
22. Use Scheduler jobs on remote systems
23. Use advanced Scheduler features to prioritize jobs

1. Oracle Software Installation Basics
2. Plan for an Oracle Database software installation
3. Installing Oracle Grid Infrastructure for a Standalone Server
4. Configure storage for Oracle Automatic Storage Management (ASM)
5. Install Oracle Grid Infrastructure for a standalone server
6. Install the Oracle Database software
7. Create a database by using the Database Configuration Assistant (DBCA)
8. Using Oracle Restart
9. Use Oracle Restart to manage components
10. Upgrading Oracle Database Software
11. Describe data migration methods
12. Preparing to Upgrade to Oracle Database 19c
13. Describe upgrade requirements when certain features or options are used in Oracle Database
14. Use the pre-upgrade information tool before performing an upgrade
15. Prepare the new Oracle home prior to performing an upgrade
16. Upgrading to Oracle Database 19c
17. Upgrade the database to Oracle Database 19c by using the Database Upgrade Assistant (DBUA)
18. Perform a manual upgrade to Oracle Database 19c by using scripts and tools
19. Performing Post-Upgrade Tasks
20. Migrate to unified auditing
21. Perform post-upgrade tasks
22. Migrating Data by Using Oracle Data Pump
23. Migrate data by using Oracle Data Pump