Skills Learned

• Become familiar with the Oracle Database architecture so you can describe the many areas you need to understand to manage it properly and benefit from its capabilities
• Understand the Oracle Database Cloud Service (DBCS) architecture and features
• Manage database security and implement auditing
• Implement basic backup and recovery procedures
• Move data between databases and files
• Employ basic monitoring procedures and manage performance
• Plan effective backup and recovery procedures
• Configure the database for recoverability
• Use Recovery Manager (RMAN) to create backups and perform recovery operations
• Use the Data Recovery Advisor to diagnose and repair failures
• Use Oracle Flashback Technologies to recover from human error
• Perform an encrypted database backup and restore
• Perform tablespace point-in-time recovery Manage PDB snapshots
• Encrypt data in PDBs and isolate PDB keystore
• Monitor performance in CDBs and PDBs
• Protect data with Database Vault policies in CDB and PDBs
• Manage a CDB fleet
• Manage resource allocation between PDBs and within a PDB
• Use Data Pump operations from a non-CDB or CDB into a PDB
• Upgrade 12c CDBs or PDBs to 18c
• Configure and create a CDB
• Manage common and local users, roles, privileges, profiles, objects in CDBs and PDBs
• Backup, duplicate, recover, and flashback CDB and PDBs
• Rack and cable a new Oracle Database Appliance engineered system
• Power on the system for the first time and define network options
• Configure Oracle Integrated Lights Out Manager (ILOM)
• Validate Oracle Appliance Manager software version and re-image Operating System, if needed
• Download and install the latest Oracle Database Appliance Patch-Set Bundle
• Use the Oracle Database tuning methodology appropriate to the available tools
• Utilize database advisors to proactively tune an Oracle Database instance
• Use the tools based on the Automatic Workload Repository to tune the database
• Use Enterprise Manager performance-related pages to monitor an Oracle Database
• Describe and determine database security requirements
• Understand Oracle security solutions to help meet security requirements
• Implement basic database security
• Configure network security
• Enumerate Oracle auditing solutions to monitor database security requirements
• Implement Oracle Audit Vault and Database Firewall
• Configure and use Transparent Data Encryption
• Grasp and use Oracle Key Vault Security measures
• Understand Oracle Data Redaction
• Understand and use Oracle Data Masking and Subsetting
• Grasp potential security risks and identify appropriate Oracle solutions
• Configure general authentication and authorization
• Understand and implement Global Users
• Set up and maintain a simple wallet
• Install and use Oracle Database Vault
• Configure and use Transparent Sensitive Data Protection
• Describe the key capabilities of Exadata Database Machine
• Identify the benefits of using Exadata Database Machine for different application classes
• Describe the architecture of Exadata Database Machine and its integration with Oracle Database, Clusterware, and ASM
• Configure I/O Resource Management
• Complete the initial configuration of Exadata Database Machine
• Describe recommended approaches for migrating to Exadata Database Machine
• Gain an understanding of the Oracle Database Exadata Cloud Service
• Monitor Exadata Database Machine health and optimize performance
• And more…