Course Topics
1. Introduction
- Sample HR Schema
- Oracle Cloud Overview
- Oracle Database Editions, Options, and Management Packs
2. Managing DBCS Database Deployments
- Managing Network Access to DBCS
- Managing the Compute Node
- Scaling a Database Deployment
- Patching a Database Deployment
3. Creating PDBs
- Dropping PDBs
- Cloning PDBs
- Methods and Tools to Create PDBs
- Creating PDBs from Seed
- Unplugging and Plugging in PDBs
4. Managing Storage Space
- Resumable Space Allocation
- Shrinkable Segments
- Deferred Segment Creation
- Space-Saving Features
- Oracle Database Space Management Features
- Types of Segments
- Table and Row Compression
- Block Space Management
5. Backup and Recovery Configuration
- Configuring ARCHIVELOG Mode
- Configuring and Monitoring the Fast Recovery Area
- Multiplexing Control Files
- Multiplexing Redo Log Files
- Archive Redo Log Files
6. Monitoring and Tuning Database Performance
- Managing Memory Components
- Automatic Workload Repository (AWR)
- Advisory Framework
- Monitoring Wait Events, Sessions, and Services
- Managing Metric Thresholds and Alerts
- Performance Tuning Methodology
- Performance Planning Considerations
- Automatic Database Diagnostic Monitor (ADDM)
7. Oracle Database Architecture
- Automatic Storage Management (ASM) Overview
- Oracle Database Instance Configurations
- Oracle Database Memory and Process Structures
- Connecting to the Database Instance
- Logical and Physical Database Structures
- Multitenant Architecture
- Oracle Database Server Architecture
8. Managing Database Instances
- Starting Up Oracle Database Instances
- Data Dictionary Views
- Shutting Down Oracle Database Instances
- Dynamic Performance Views
- Automatic Diagnostic Repository (ADR)
- Alert Log and Trace Files
- Initialization Parameter Files
9. Creating Master Encryption Keys for PDBs
- Overview of Transparent Data Encryption (TDE)
- Creating and Activating an Encryption Key
- CDB and PDB Master Encryption Keys
- Encryption in Oracle Database Cloud Service
10. Managing Undo Data
- Comparing Local Undo Mode and Shared Undo Mode
- Transactions and Undo Data
- Storing Undo Information
- Configuring Undo Rentention
- Comparing Undo Data and Redo Data
- Temporary Undo
11. Creating Database Backups
- RMAN Backup Types
- On-Demand Backups on DBCS
- Using Recovery Manager (RMAN)
- Backup Terminology
- Automatic Backups on Database Cloud Service (DBCS)
12. SQL Tuning
- Oracle Optimizer
- SQL Tuning Advisor
- SQL Performance Analyzer
- Optimizer Statistics
- SQL Access Advisor
- SQL Tuning Process
13. Introdction to Oracle Database Cloud
- Automated Database Provisioning
- Oracle Database Cloud Service Architecture
- Features and Tooling
14. Accessing an Oracle Database
- Oracle Database Cloud Service Tools
- Database Configuration Assistant (DBCA)
- Oracle Enterprise Manager Cloud Control
- Oracle enterprise Manager Database Express
- SQL Developer
- SQL*Plus
15. Oracle Net Services
- Oracle Net Services Administration Tools
- Configuring Communication Between Database Instances
- Oracle Net Listener Overview
- Connecting to an Oracle Database Instance
- Comparing Dedicated and Shared Server Configurations
- Naming Methods
16. Administering User Security
- Assigning Quotas to Users
- Applying the Principal of Least Privilege
- Managing Oracle Cloud Users, Privileges, and Roles
- Creating and Assigning Profiles
- User Authentication
- Managing Oracle Database Users, Privileges, and Roles
17. Creating and Managing Tablespaces
- Viewing Tablespace Information
- Creating, Altering and Dropping Tablespaces
- Table Data Storage
- Tablespace Encryption by Default in DBCS
- Implementing Oracle Managed Files
- Moving and Renaming Online Data Files
18. Moving Data
- External Tables
- Oracle Data Pump
- Migrating to Oracle Database Cloud Service
- SQL*Loader
19. Backup and Recovery Concepts
- Point-in-time Recovery
- Complete Recovery
- Categories of Failure
- Flashback Technology
- Instance Recovery
20. Performing Database Recovery
- Database Recovery Advisor
- Recovering Data Files in ARCHIVELOG Mode
- Recovering Data Files in NOARCHELOG Mode
- Recovery Options in Database Cloud Service (DBCS)