Visão Geral

Este curso aborda a administração de segurança em ambientes Oracle Database, capacitando o participante a implementar controles de acesso, proteção de dados, auditoria, conformidade e monitoramento de segurança. O curso explora recursos nativos do Oracle Database para fortalecer a confidencialidade, integridade e disponibilidade das informações, alinhando as práticas de segurança às exigências corporativas e regulatórias.

Objetivo

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

• Compreender a arquitetura de segurança do Oracle Database
• Implementar controles de autenticação, autorização e acesso
• Administrar privilégios, roles e políticas de segurança
• Configurar auditoria e monitoramento de atividades do banco de dados
• Proteger dados utilizando criptografia e recursos avançados de segurança
• Aplicar boas práticas de compliance, governança e proteção de dados corporativos

Publico Alvo

• Administradores de Banco de Dados Oracle (DBAs)
• Especialistas em segurança da informação
• Analistas de infraestrutura e governança
• Arquitetos de soluções Oracle
• Auditores de TI e compliance
• Consultores de segurança e banco de dados

Pre-Requisitos

• Conhecimentos equivalentes ao curso Oracle Database Administration I
• Familiaridade com administração de usuários e privilégios Oracle
• Noções de segurança da informação e governança de TI

Conteúdo Programatico

Module 1: Oracle Database Security Fundamentals

1. Introduction to database security concepts
2. Oracle security architecture overview
3. Security principles and best practices
4. Threats and vulnerabilities in database environments
5. Defense-in-depth strategies
6. Security governance fundamentals

Module 2: Authentication and User Management

1. Oracle authentication mechanisms
2. Password-based authentication
3. External and enterprise authentication
4. User account administration
5. Profile management and password policies
6. Identity management concepts

Module 3: Authorization and Access Control

1. System and object privileges
2. Roles administration
3. Privilege delegation and management
4. Principle of least privilege
5. Access control strategies
6. Security administration best practices

Module 4: Advanced Security Features

1. Oracle security options overview
2. Security configuration techniques
3. Data access protection mechanisms
4. Fine-grained access control concepts
5. Security policy implementation
6. Secure administration practices

Module 5: Data Encryption and Protection

1. Cryptography fundamentals
2. Transparent Data Encryption (TDE)
3. Tablespace encryption
4. Column-level encryption
5. Network encryption concepts
6. Encryption key management

Module 6: Auditing and Compliance

1. Oracle auditing architecture
2. Unified Auditing fundamentals
3. Audit policy creation and management
4. Monitoring database activities
5. Compliance and regulatory requirements
6. Audit reporting and analysis

Module 7: Database Activity Monitoring and Threat Detection

1. Security monitoring strategies
2. Detecting suspicious activities
3. Log analysis techniques
4. Security event management concepts
5. Incident detection and response
6. Security monitoring best practices

Module 8: Fine-Grained Security and Data Protection

1. Fine-Grained Auditing (FGA)
2. Virtual Private Database (VPD)
3. Label security concepts
4. Data masking fundamentals
5. Sensitive data protection
6. Data privacy strategies

Module 9: Multitenant Security Administration

1. Security considerations in CDB and PDB environments
2. Common and local user security
3. Access management in multitenant databases
4. Resource isolation concepts
5. Auditing multitenant environments
6. Security governance for multitenant architectures

Module 10: Security in High Availability Environments

1. Security considerations for RAC environments
2. Data Guard security administration
3. Secure backup and recovery practices
4. Disaster recovery security requirements
5. Business continuity and security integration
6. Enterprise security architecture

Module 11: Security Operations and Governance

1. Security policies and procedures
2. Risk management fundamentals
3. Compliance frameworks and controls
4. Change management for security environments
5. Documentation and operational governance
6. Security maturity assessment concepts

Module 12: Practical Labs and Security Case Studies

1. User and privilege administration exercises
2. Encryption and auditing workshops
3. Security monitoring laboratories
4. Compliance and governance scenarios
5. Security incident response simulations
6. Final Oracle security administration project