Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most. Topics, agenda and labs are subject to change, and may adjust during live delivery based on audience needs and skill-level.
Oracle Database Architecture
- Oracle Database Server Architecture
- Oracle Database Instance Configurations
- Connecting to the Database Instance
- Oracle Database Memory Structures
Creating DBCS Database Deployments
- Automated Database Provisioning
- Creating a Database Deployment
Accessing an Oracle Database
- Connecting to an Oracle Database Instance
- Oracle Database Tools
- SQL*Plus
- Oracle SQL Developer
- SQL Developer Command Line (SQLcl)
- Database Configuration Assistant (DBCA)
- Oracle Enterprise Manager Database Express
- Enterprise Manager Cloud Control 13c Features
Managing DBCS Database Deployments
- Managing the Compute Node
- Scaling a Database Deployment
- Patching DBCS
Managing Database Instances
- Working with Initialization Parameters
- Starting the Oracle Database Instance
- Shutting Down an Oracle Database Instance
- Opening and Closing PDBs
- Alert Log
- Trace Files
- DDL Log File
Oracle Net Services
- Oracle Net Services
- Oracle Net Listener
- The Default Listener
- Establishing Oracle Network Connections
- Connecting to an Oracle Database
User Security
- Database User Accounts
- Oracle-Supplied Administrator Accounts
- Creating Oracle Database Users in a Multitenant Environment -9
- Schema-Only Account
- Authenticating Users
- System Privileges for Administrators
- Object Privileges
- Granting Privileges in a Multitenant Environment
- Granting and Revoking System Privileges
- Granting and Revoking Object Privileges
Creating PDBs
- Creating a New PDB from PDB$SEED
- Cloning PDBs
- Unplugging and Plugging in PDBs
- Plugging an Unplugged Regular PDB into a CDB
Creating and Managing Tablespaces
- Creating Tablespaces
- Creating Permanent Tablespaces in a CDB
- Altering and Dropping Tablespaces
- Viewing Tablespace Information
- Tablespace Encryption by Default in DBCS
Managing Storage Space
- Space Management Features
- Block Space Management
- Row Chaining and Migration
- Types of Segments
- Allocating Extents
Managing Undo Data
Moving Data
- Oracle Data Pump
- SQL Loader
Backup and Recovery Concepts
- Types of Failures
- Instance Recovery
- The Checkpoint (CKPT) Process
- Redo Log Files and the Log Writer (LGWR)
- Automatic Instance Recovery or Crash Recovery
- Using the MTTR Advisor
- Complete Recovery Process
- The Point-in-Time Recovery Process
- Flashback
Backup and Recovery Configuration
- Configuring for Recoverability
- Redo Log Files
Creating Database Backups
- RMAN Backup
- Backing Up Databases on DBCS
Performing Database Recovery
- Data Recovery Advisor
- Loss of a Control File
- Loss of a Redo Log File
- DBCS: Performing Recovery by Using the Console
- dbaascli Utility
Monitoring and Tuning Database Performance
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor (ADDM)
- Advisory Framework
Tuning SQL
- SQL Tuning Process
- Oracle Optimizer
- Optimizer Statistics
- SQL Plan