Module 1: Environment Setup

1. Setting up the lab environment for Oracle DBA practice.

2. System requirements and prerequisites.

Module 2: Installing Oracle Software

1. Installing Oracle 11g

2. Installing Oracle 12c

3. Installing Oracle 19c

Module 3: Database Creation

1. Manual Database Creation

2. GUI Mode Database Creation using DBCA

Module 1: Oracle Architecture

1. Detailed architecture overview for Oracle 11g, 12c, and 19c.

2. Understanding System Global Area (SGA), Program Global Area (PGA), and background processes.

Module 2: Tablespaces and Storage Management

1. Managing tablespaces, segments, extents, and data blocks.

Module 3: ASM (Automatic Storage Management)

1. Overview and administration of ASM architecture.

Module 4: Multitenant Database Architecture

1. Introduction to Container Databases (CDB) and Pluggable Databases (PDB) in 12c and 19c.

2. New features and administration of multitenant architecture.

Module 5: Oracle Networking

1. Configuring Oracle Net Services and listener management.

2. Troubleshooting network issues.

Module 1: User Account Management

1. Creating and managing user accounts, roles, and privileges.

2. Security best practices and auditing.

Module 2: Database Backup and Recovery

1. Understanding backup types and strategies.

2. Using RMAN (Recovery Manager) for backups and recovery.

3. Performing conventional backups and recovery techniques.

Module 3: Database Cloning

1. Cloning databases using RMAN and conventional methods.

Module 4: Applying Patches

1. Types of patches: PSU, CPU, BP, ONEOFF, and MERGE.

2. Patch application process and best practices.

Module 5: Database Upgrade

1. Upgrade paths and considerations.

2. Upgrading from Oracle 11g to 12c.

Upgrading from Oracle 12c to 19c.

Module 6: Data Guard Architecture and Standby Databases

1. Overview of Data Guard architecture.

2. Configuring and managing physical and logical standby databases.

Module 1: Shell Scripting Overview

1. Basics of shell scripting for DBAs.

2. Writing and executing scripts to automate DBA tasks.

Module 2: Data Pump (Expdp/Impdp) Backups

1. Introduction to Data Pump.

2. Performing export and import operations using Expdp/Impdp.

Module 3: Performance Analysis and Tuning

1. Using AWR , ADDM , and ASH reports.

2. Performance tuning techniques for SQL queries and database instances.

3. Index management and optimization.

Module 4: Proactive Monitoring and Maintenance

1. Setting up proactive monitoring and alert mechanisms.

2. Best practices for maintaining database health and performance.

Module 5: Real-Time Practical Scenarios

1. Hands-on exercises based on real-world DBA tasks.

2. Troubleshooting common issues and resolving them.