Please note topics, agenda and labs are subject to change, and may adjust during live delivery based on audience interests, skill-level and participation.
1. Introduction to Oracle Database
- Oracle Multitenant Container Database
- Oracle Database Instance Configurations
- Database Sharding
- Oracle Database Server
2. Accessing an Oracle Database
- Oracle Database Tools
- Database Tool Choices
- SQL Developer
- Enterprise Manager Database Express
3. Creating an Oracle Database by Using DBCA
- Planning the Database
- Choosing a Database Template
- Configuration Assistant
4. Creating an Oracle Database by Using a SQL Command
- Creating a Container Database
- Enable Pluggable Database
5. Starting Up and Shutting Down a Database Instance
- Starting the Oracle Database Instance
- Shutting Down an Oracle Database Instance
- Opening and Closing PDBs
6. Managing Database Instances
- Investigating Initialization Parameter Files
- Viewing Initialization Parameters by Using SQL*Plus
- Modifying Initialization Parameters by Using SQL*Plus
- Viewing Diagnostic Information
7. Oracle Net Services Overview
- Oracle Net Services Components
- Oracle Net Listener
8. Configuring Naming Methods
- Configuring the Oracle Network to Access a Database
- Creating a Net Service Name for a PDB
9. Configuring and Administering the Listener
- Exploring the Default Listener
- Creating a Second Listener
- Connecting to a Database Service Using the New Listener
10. Configuring a Shared Server Architecture
- Configuring Shared Server Mode
- Configuring Clients to Use a Shared Server
11. Configuring Oracle Connection Manager for Multiplexing and Access Control
- Oracle Connection Manager Processes
- Filtering Rules
- Session Multiplexing
12. Creating PDBs from Seed
- Provisioning New Pluggable Databases
- Tools
- Creating a New PDB from PDB$SEED
- Using OMF or the PDB_FILE_NAME_CONVERT Parameter
13. Using Other Techniques to Create PDBs
- Cloning Regular PDBs
- Migrating Data from a Non-CDB into a CDB
- Remote PDB
- Cloning Remote PDBs in Hot Mode
- Creating a Proxy PDB
14. Managing PDBs
- Renaming a PDB
- Setting Parameter Values for PDBs
15. Database Storage Overview
- Logical and Physical Database Structures
- Tablespaces and Data Files
- Types of Segments
- Monitoring Tablespace Space Usage
16. Creating and Managing Tablespaces
- Viewing Tablespace Information
- Creating a Tablespace
- Managing Temporary and Permanent Tablespaces
17. Improving Space Usage
- Managing Space in Tablespaces
- Using Compression
- Enabling the Resumable Space Allocation Feature
18. Managing Undo Data
- Transactions and Undo Data
- Managing Undo
- Configuring Undo Retention
- Categories of Undo
- Temporary Undo Benefits
19. Creating and Managing User Accounts
- Creating Common and Local Users
- Creating a Local User for an Application
- Exploring OS and Password File Authentication
20. Configuring Privilege and Role Authorization
- Granting a Local Role (DBA) to PDBADMIN
- Using SQL*Developer to Create Local Roles
21. Configuring User Resource Limits
- Using SQL*Developer to Create a Local Profile & Users
- Configuring a Default Role for a User
22. Implementing Oracle Database Auditing
- Enabling Unified Auditing
- Creating Audit Users
- Creating an Audit Policy
23. Introduction to Loading and Transporting Data
- General Architecture
- Oracle Data Pump
- SQL Loader
- Loading Data into a PDB from an External File
- Moving Data from One PDB to Another PDB
- Transporting a Tablespace
NEXT-LEVEL BONUS CONTENT / TIME PERMITTING
These extra / bonus chapters will be included with your courseware but are only covered live in class if time permits.
- Using External Tables to Load and Transport Data
- Automated Maintenance Tasks: Overview
- Managing Tasks and Windows
- Database Monitoring and Performance Tuning Overview
- Monitoring Database Performance
- Database Processes
- Managing Memory
- Analyzing SQL and Optimizing Access Paths
