Course Objectives:
- Back up, restore, and patch DBCS database deployments
- Describe the DBaaS and on-premises Oracle Database architectures
- Manage database instances
- Manage UNDO data
- Move data between databases
- Implement basic backup and recovery procedures
- Monitor and tune database performance
- Tune SQL to improve performance
- Manage resources with Oracle Database Resource Manager
- Create pluggable databases (PDBs)
- Configure the Oracle network environment
- Administer user security and implement auditing
- Create and manage tablespaces
- Manage storage space
- Create and manage Database as a Cloud Service (DBCS) database deployments
- Register databases and manage performance with Enterprise Manager Cloud Control
Course Outline:
- Exploring Oracle Database Architecture
- Managing Database Instances
- Creating PDBs
- Configuring the Oracle Network Environment
- Administering User Security
- Creating and Managing Tablespaces
- Managing Storage Space
- Managing UNDO Data
- Moving Data
- Backup and Recovery Concepts
- Monitoring and Tuning Database Performance
- SQL Tuning
- Oracle Database Resource Manager
- Enterprise Manager Cloud Control
- Introduction to Oracle Database Cloud Service
- Creating DBCS Database Deployments
- Managing DBCS Database Deployments
- Backing Up and Restoring DBCS Database Deployments
- Patching DBCS Database Deployments
- Creating Master Encryption Keys for PDBs
- Tablespace Encryption by Default