Oracle Database 19c: Administration workshop
Module 1: Introduction to Oracle Database
• Database Server Architecture
Module 2: Accessing an Oracle Database
• Accessing an Oracle Database
Module 3: Creating an Oracle Database by Using DBCA
• Creating a Database Using DBCA
Module 4: Creating an Oracle Database by Using a SQL Command
• Creating Database using SQL Command
Module 5: Starting Up and Shutting Down a Database Instance
• Starting Up and Shutting Down a Database Instance
Module 6: Managing Database Instances
• Managing the Database
Module 7: Oracle Net Service: Overview
• Configuring and Administering Oracle Net Service
Module 8: Configuring Naming Methods
• Oracle Net Components
• Naming Method
Module 9: Configuring and Administering the Listener
• Configuring and Administering the Listener
Module 10: Configuring a Shared Server Architecture
• Configuring a Shared Server Architecture
Module 11: Configuring Oracle Connection Manager for Multiplexing and Access Control
• Connection Manager
Module 12: Creating PDBs from Seed
• Creating PDBs from Seed
• Provisioning New Pluggable Databases
Module 13: Using Other Techniques to Create PDBs
• Using Other Techniques to Create PDBs
• Method of Creating and Migrating PDBs
Module 14: Managing PDBs
• Managing PDBs
Module 15: Database Storage Overview
• Database Storage Overview
• Purpose of the Default Tablespaces
• Storage of Data in Blocks
• Advantage of Deferred Segment Creation
Module 16: Creating and Managing Tablespaces
• Creating and Managing Tablespaces
• Viewing Tablespace Information
Module 17: Improving Space Usage
• Space Management Features
• Creating Global Temporary Tables
Module 18: Managing Undo Data
• Managing the Undo
• Enabling Temporary Undo
Module 19: Creating and Managing User Accounts
• Creating and Managing User Accounts
• Creating Common Users in the CDB and PDBs
Module 20: Configuring Privilege and Roles Authorization
• Configuring Privilege and Roles Authorization
Module 21:
• Configuring User Resource Limits
• Configuring User Resource Limits
Module 22: Implementing Oracle Database Auditing
• Implementing Oracle Database Auditing
• Configuring Auditing
• Viewing Audit Policy Information
Module 23: Introduction Loading and Transporting Data
• Introduction Loading and Transporting Data
Module 24: Loading Data
• Loading Data
Module 25: Transporting Data
• Transporting Data
• Using the RMAN Convert Command
Module 26: Using External Tables to Load and Transport Data
• Using External Tables to load Transport Data
• External Table Demo
Module 27: Automated Maintenance Tasks: Overview
• Automated Maintenance Tasks: Overview
• Automated Maintenance Tasks: Components
Module 28: Automated Maintenance Tasks: Managing Tasks and Windows
• Configuring Automated Maintenance Tasks
Module 29: Database Monitoring and Performance Tuning Overview
• Database Monitoring and Tuning Performance Overview
Module 30: Monitoring Database Performance
• Understanding What Database Performance is Monitored
Module 31: Analyzing SQL and Optimizing Access Paths
• Analyzing SQL and Optimizing Access Paths
• Adaptive Execution Plans
