Visão Geral

Este curso aborda a administração do Oracle Database 23ai, explorando os recursos mais recentes da plataforma Oracle para gerenciamento de bancos de dados corporativos. O participante aprenderá a instalar, configurar, administrar, monitorar, proteger e otimizar ambientes Oracle Database 23ai, incluindo recursos de inteligência artificial incorporada, automação, arquitetura multitenant, alta disponibilidade e gestão avançada de dados.

Objetivo

Após realizar este curso, você será capaz de:

• Compreender a arquitetura e os recursos do Oracle Database 23ai
• Instalar, configurar e administrar ambientes Oracle Database 23ai
• Gerenciar bancos de dados multitenant (CDB/PDB)
• Implementar práticas de segurança, backup e recuperação
• Monitorar e otimizar o desempenho de ambientes Oracle
• Utilizar recursos de automação e inteligência artificial disponíveis na plataforma

Publico Alvo

• Administradores de Banco de Dados Oracle (DBAs)
• Analistas de infraestrutura e banco de dados
• Arquitetos de soluções Oracle
• Consultores Oracle Database
• Especialistas em plataformas de dados corporativas
• Profissionais que desejam atualizar conhecimentos para Oracle Database 23ai

Pre-Requisitos

• Conhecimentos básicos de Oracle Database Administration
• Familiaridade com SQL e arquitetura de bancos de dados relacionais
• Experiência com sistemas Linux ou Windows Server é recomendada

Conteúdo Programatico

Module 1: Oracle Database 23ai Overview and Architecture

1. Introduction to Oracle Database 23ai
2. New features and enhancements
3. Oracle database architecture review
4. Multitenant architecture fundamentals
5. AI-enabled database concepts
6. Enterprise deployment scenarios

Module 2: Installation and Initial Configuration

1. Installation planning and prerequisites
2. Oracle Universal Installer
3. Database Configuration Assistant (DBCA)
4. Creating CDB and PDB environments
5. Post-installation configuration
6. Validation and health checks

Module 3: Managing Oracle Database Instances

1. Instance architecture and components
2. Startup and shutdown procedures
3. Initialization parameters
4. Memory management concepts
5. Diagnostic and alert logs
6. Operational administration tasks

Module 4: Multitenant Administration (CDB/PDB)

1. Container and pluggable database administration
2. Creating and managing PDBs
3. Cloning and relocating PDBs
4. Resource management
5. Security administration in multitenant environments
6. Consolidation strategies

Module 5: Storage and ASM Administration

1. Oracle storage architecture
2. Tablespaces and datafiles
3. ASM fundamentals
4. Disk group management
5. Space monitoring and optimization
6. Storage best practices

Module 6: Security Administration and Data Protection

1. User and privilege administration
2. Authentication and authorization
3. Unified Auditing
4. Transparent Data Encryption (TDE)
5. Data protection strategies
6. Security governance and compliance

Module 7: Backup, Recovery and Business Continuity

1. RMAN architecture and administration
2. Backup strategies and policies
3. Recovery operations
4. Flashback technologies
5. Disaster recovery concepts
6. Business continuity planning

Module 8: Performance Monitoring and Optimization

1. Oracle performance architecture
2. Monitoring tools and utilities
3. AWR, ASH and ADDM fundamentals
4. SQL performance analysis
5. Memory and storage tuning
6. Performance optimization strategies

Module 9: High Availability Technologies

1. Oracle Data Guard overview
2. Oracle RAC concepts
3. Service continuity strategies
4. High availability architecture
5. Failover and switchover concepts
6. Resilience and operational continuity

Module 10: AI Features and Intelligent Database Capabilities

1. Introduction to AI features in Oracle 23ai
2. AI-assisted database administration
3. Vector data concepts
4. AI-enabled search capabilities
5. Intelligent automation features
6. AI governance and operational considerations

Module 11: Automation, Monitoring and Operational Excellence

1. Oracle Enterprise Manager overview
2. Administrative automation techniques
3. Oracle Scheduler administration
4. Monitoring and alert management
5. Operational governance practices
6. Database lifecycle management

Module 12: Practical Labs and Enterprise Administration Scenarios

1. Oracle Database 23ai administration workshops
2. Multitenant management exercises
3. Backup and recovery simulations
4. Security and performance laboratories
5. High availability case studies
6. Final Oracle Database 23ai administration project