Visão Geral

Este curso apresenta os fundamentos da administração de bancos de dados Oracle, capacitando o participante a instalar, configurar, administrar e monitorar ambientes Oracle Database. O curso aborda arquitetura, gerenciamento de instâncias, armazenamento, usuários, segurança, backup e recuperação, fornecendo a base necessária para atuação como Administrador de Banco de Dados Oracle (DBA).

Objetivo

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

• Compreender a arquitetura do Oracle Database
• Instalar e configurar ambientes Oracle Database
• Gerenciar instâncias, bancos de dados e armazenamento
• Administrar usuários, privilégios e segurança básica
• Realizar atividades de monitoramento e manutenção do banco de dados
• Executar procedimentos básicos de backup e recuperação

Publico Alvo

• Administradores de banco de dados iniciantes
• Analistas de infraestrutura e suporte
• Profissionais de TI responsáveis por ambientes Oracle
• Desenvolvedores que desejam compreender a administração de bancos Oracle
• Consultores de tecnologia
• Estudantes interessados em administração de bancos de dados

Pre-Requisitos

• Conhecimentos básicos de sistemas operacionais Windows ou Linux
• Noções de bancos de dados relacionais
• Conhecimentos básicos de SQL são recomendados

Conteúdo Programatico

Module 1: Oracle Database Architecture Fundamentals

1. Introduction to Oracle Database
2. Oracle architecture overview
3. Database instance concepts
4. Memory structures and processes
5. Physical and logical storage structures
6. Oracle multitenant architecture fundamentals

Module 2: Installing and Configuring Oracle Database

1. Oracle Database installation planning
2. Installation prerequisites
3. Using Oracle Universal Installer
4. Database creation with DBCA
5. Initial configuration tasks
6. Post-installation verification and validation

Module 3: Managing Oracle Database Instances

1. Starting and stopping database instances
2. Understanding initialization parameters
3. Server parameter files (SPFILE)
4. Managing instance configurations
5. Diagnostic and alert logs
6. Database operational modes

Module 4: Oracle Storage Management

1. Tablespaces and datafiles
2. Managing storage structures
3. Understanding segments, extents and blocks
4. Temporary and undo tablespaces
5. Space allocation and management
6. Storage monitoring and optimization

Module 5: User Administration and Security Fundamentals

1. Creating and managing users
2. Roles and privileges
3. Authentication methods
4. Profiles and resource limits
5. Password management policies
6. Security best practices

Module 6: Managing Schema Objects

1. Creating and managing tables
2. Index administration fundamentals
3. Views and materialized views overview
4. Sequences and synonyms
5. Managing database objects
6. Object maintenance practices

Module 7: Data Concurrency and Transaction Management

1. Understanding transactions
2. COMMIT and ROLLBACK operations
3. Locking mechanisms
4. Concurrency control concepts
5. Read consistency fundamentals
6. Managing transaction-related issues

Module 8: Oracle Networking Fundamentals

1. Oracle Net Services overview
2. Listener configuration and management
3. Client connectivity concepts
4. Service names and connection descriptors
5. Network troubleshooting basics
6. Connectivity best practices

Module 9: Backup and Recovery Fundamentals

1. Introduction to backup and recovery concepts
2. Oracle recovery architecture overview
3. User-managed backup techniques
4. RMAN fundamentals
5. Recovery scenarios and strategies
6. Database protection best practices

Module 10: Database Monitoring and Maintenance

1. Monitoring database performance
2. Using Oracle Enterprise Manager
3. Managing alerts and diagnostics
4. Identifying operational issues
5. Routine maintenance activities
6. Capacity planning fundamentals

Module 11: Automation and Administrative Tools

1. Administrative utilities overview
2. SQL*Plus administration tasks
3. Oracle SQL Developer for DBAs
4. Data Pump fundamentals
5. Scheduling jobs with Oracle Scheduler
6. Automation best practices

Module 12: Practical Labs and DBA Scenarios

1. Oracle installation exercises
2. User and security administration labs
3. Storage management scenarios
4. Backup and recovery workshops
5. Monitoring and troubleshooting activities
6. Final Oracle DBA administration project