Module 1: Introduction
- Sample HR Schema
- Oracle Cloud Overview
- Oracle Database Editions, Options, and Management Packs
Module 2: 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
Module 3: Introduction to Oracle Database Cloud
- Automated Database Provisioning
- Oracle Database Cloud Service Architecture
- Features and Tooling
Module 4: Creating Oracle Database Cloud Service (DBCS) Deployments
- SSH Key Pairs
- Database File Storage
- Input to the Creation Wizard
Module 5: 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
Module 6: Managing DBCS Database Deployments
- Managing Network Access to DBCS
- Managing the Compute Node
- Scaling a Database Deployment
- Patching a Database Deployment
Module 7: 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
Module 8: 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
Module 9: 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
Module 10: Creating PDBs
- Dropping PDBs
- Cloning PDBs
- Methods and Tools to Create PDBs
- Creating PDBs from Seed
- Unplugging and Plugging in PDBs
Module 11: 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
Module 12: 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
Module 13: 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
Module 14: 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
Module 15: Moving Data
- External Tables
- Oracle Data Pump
- Migrating to Oracle Database Cloud Service
- SQL Loader
Module 16: Backup and Recovery Concepts
- Point-in-time Recovery
- Complete Recovery
- Categories of Failure
- Flashback Technology
- Instance Recovery
Module 17: 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
Module 18: Creating Database Backups
- RMAN Backup Types
- On-Demand Backups on DBCS
- Using Recovery Manager (RMAN)
- Backup Terminology
- Automatic Backups on Database Cloud Service (DBCS)
Module 19: 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)
Module 20: 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)
Module 21: SQL Tuning
- Oracle Optimizer
- SQL Tuning Advisor
- SQL Performance Analyzer
- Optimizer Statistics
- SQL Access Advisor
- SQL Tuning Process