Oracle Database 23ai: Administration Workshop

• 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

Oracle Database 23ai is the latest version of Oracle’s enterprise-grade relational database management system (RDBMS), offering advanced automation, AI-driven optimization, and enhanced security features.

This instructor-led, live training (online or onsite) is aimed at intermediate-level database administrators and IT professionals who wish to gain practical expertise in installing, configuring, securing, and maintaining Oracle Database 23ai.

By the end of this training, participants will be able to:

• Install and configure Oracle Database 23ai.
• Manage database storage, users, and security settings.
• Optimize database performance using AI-driven automation.
• Implement backup and recovery strategies.
• Monitor and troubleshoot database performance issues.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

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