Detailed Course Outline
- 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