Architecture and Access
- Structure of the Oracle database: instance, memory and process structures
- Logical and physical database structures
- Access methods: SQL*Plus, SQL Developer, Enterprise Manager Database Express
- Positioning the 26ai release line: version scheme 23.26.x, Long Term Support, editions
Creating Databases and Operating Instances
- Creating a database with DBCA and via SQL commands
- Starting and shutting down instances
- Initialisation parameters and dynamic performance views
- Automatic Diagnostic Repository, alert log and trace files
Oracle Net Services
- Overview of Oracle Net Services
- Configuring name resolution
- Setting up and administering the listener
- Shared server architecture and connection management
Multitenant: Container and Pluggable Databases
- Creating PDBs from the seed database
- Further methods: clone, plug, unplug and relocate
- Managing PDBs: opening, closing, save state, parameters per PDB
- PDB priorities and hybrid read-only operation
Storage: Tablespaces and Undo
- Overview of database storage
- Creating and managing tablespaces, bigfile tablespaces
- Improving space usage: segment space management and block management
- Managing undo data, undo versus redo, temporary undo
Users, Privileges and Auditing
- Creating and managing user accounts
- Granting privileges and roles, resource limits via profiles
- Setting up Unified Auditing and Fine-Grained Auditing
- New in 23ai/26ai: schema privileges, developer role, dictionary protection
- Configuring SQL Firewall: allow list, log and block mode
Loading and Transporting Data
- Overview of the methods
- Loading data with SQL*Loader
- Data Pump and transportable tablespaces
- Using external tables
Maintenance, Monitoring and an Introduction to Performance
- Automatic maintenance tasks and maintenance windows
- Monitoring the database: AWR fundamentals, metrics and alerts
- Reading execution plans and optimising access paths
- Fundamentals of backup and recovery
Introduction to the AI Database for Administrators
- AI Vector Search: impact on storage, memory and indexes
- Setting up and operating True Cache
- JSON Duality Views: implications for storage and monitoring
- Select AI and agents: governance and permissions
