Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Oracle Database 23ai
- Overview of Oracle Database 23ai and key enhancements
- Understanding AI-driven database automation
- Exploring Oracle Cloud and on-premise deployment options
Installation and Configuration
- System requirements and pre-installation setup
- Installing Oracle Database 23ai on Linux and Windows
- Database creation using Oracle DBCA
Managing Database Storage
- Tablespaces and datafiles management
- Using Automatic Storage Management (ASM)
- Managing Undo Data and Redo Logs
User and Security Management
- Creating and managing user accounts
- Implementing roles and privileges
- Enhancing database security with encryption and auditing
AI-Driven Performance Optimization
- Understanding Oracle AI-driven automation for tuning
- Using Automatic Workload Repository (AWR) and SQL Tuning Advisor
- Optimizing queries with AI-powered indexing
Backup and Recovery Strategies
- Oracle Recovery Manager (RMAN) fundamentals
- Performing full and incremental backups
- Database restoration and disaster recovery best practices
Monitoring and Troubleshooting
- Using Oracle Enterprise Manager for monitoring
- Identifying and resolving performance bottlenecks
- Handling database errors and corruption
Advanced Administration and High Availability
- Configuring Oracle Data Guard for failover
- Using Oracle GoldenGate for real-time data replication
- Implementing multi-tenancy for database consolidation
Summary and Next Steps
Requirements
- An understanding of relational database concepts
- Basic experience with SQL and PL/SQL
- Familiarity with operating system commands (Linux or Windows)
Audience
- Database administrators
- IT professionals managing Oracle databases
- System administrators handling database infrastructure
35 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €11400 online delivery, based on a group of 2 delegates, €3600 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses