Oracle Database 19c: Administration Workshop

Prerequisites:

• Understanding of relational database concepts and a good knowledge of the operating system.
• Completed Oracle SQL course or familiar with Oracle SQL.

Audience

• Database Administrator
• System Administrator

Course Outline

• Introduction to Oracle Database
• Accessing an Oracle Database
• Creating an Oracle Database by Using DBCA and by Using a SQL Command
• Starting Up and Shutting Down a Database Instance
• Managing Database Instances
• Configuring Naming Methods with Oracle Net Services
• Configuring and Administering the Listener
• Configuring a Shared Server Architecture
• Configuring Oracle Connection Manager for Multiplexing and Access Control
• Creating PDBs from Seed and Using Other Techniques
• Managing PDBs
• Database Storage Overview
• Creating and Managing Tablespaces
• Improving Space Usage
• Managing Undo Data
• Creating and Managing User Accounts
• Configuring Privilege and Role Authorization
• Configuring User Resource Limits
• Implementing Oracle Database Auditing
• Loading Data
• Transporting Data
• Using External Tables to Load and Transport Data
• Automated Maintenance Tasks: Managing Tasks and Windows
• Tuning Database Performance Overview
• Monitoring Database Performance
• Database Processes
• Managing Memory
• Analyzing SQL and Optimizing Access Paths