Book a Call 🏠 Home About Courses Services Corporate Events Contact
Home Courses Oracle DBA
Oracle Database Admin ✔ 3 Levels Available

Oracle DBA
Full Programme

Regenerated certification track across three levels: DBA_L1 foundations (architecture, installation, users, tablespaces, SQL for DBAs, RMAN concepts, monitoring, security, hands-on labs), DBA_L2 operations (instance, storage, RMAN, Data Pump, performance, networking, scheduler, flashback, security), and DBA_L3 enterprise topics (multitenant, RAC, Data Guard, ASM, upgrades, advanced tuning, OEM, capstone). Format: Theory + Lab/Assignments per syllabus.

⏱
Duration
78 Hours
🧪
Lab / Assignments
22 Hours
🎯
Format
Theory + Lab/Assignments
🏆
Certificate
Arich Certified
Enrol Now →
Course Code
ORACLE-DBA
Click a Level to View its Syllabus
L1
DBA_L1 · Certification
78 hrs · 11 Modules
›
L2
DBA_L2 · Certification
12 Modules
›
L3
DBA_L3 · Certification
12 Modules
›
📄 DBA_L1 — Certification Syllabus
L1
DBA_L1
Oracle DBA – Certification (Level 1)
Programme: 78 Hours  |  Theory: 56 hrs  |  Lab: 22 hrs  |  Intensive segment: ~20 hrs (2.5 days)
01
Introduction to Oracle DBA
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
Role of DBA
Oracle Editions
Database Concepts
Lab: Explore DBA roles and editions
02
Oracle Architecture Overview
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
Instance vs Database
SGA
PGA
Background Processes
Lab: Identify Architecture Components
03
Installation & Configuration
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
Oracle Installation
DBCA
Listener Setup
Lab: Install Oracle & Configure Listener
04
Managing Database Users
Theory: 1 hr  ·  Lab: 2 hrs  ·  Total: 3 hrs
▼
Creating Users
Roles
Privileges
Profiles
Lab: Create and Manage Users
05
Tablespaces & Datafiles
Theory: 1 hr  ·  Lab: 2 hrs  ·  Total: 3 hrs
▼
Tablespace Types
Datafile Management
Storage Parameters
Lab: Create Tablespaces and Add Datafiles
06
SQL Basics for DBAs
Theory: 1 hr  ·  Lab: 2 hrs  ·  Total: 3 hrs
▼
DDL
DML
DCL Commands
SELECT Queries
Lab: Practice SQL Commands
07
Backup & Recovery Concepts
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
RMAN Basics
Logical vs Physical Backup
Restore Scenarios
Lab: Perform RMAN Backup
08
Monitoring & Performance
Theory: 1 hr  ·  Lab: 2 hrs  ·  Total: 3 hrs
▼
Alert Logs
AWR Reports
Basic Tuning Techniques
Lab: Analyze AWR and Tune Queries
09
Security & Auditing
Theory: 1 hr  ·  Lab: 2 hrs  ·  Total: 3 hrs
▼
Password Policies
Auditing
Account Locking
Lab: Configure Auditing and Security Policies
10
Hands-On Practice
Theory: 4 hrs  ·  Lab: 2 hrs  ·  Total: 6 hrs
▼
User Management
Tablespace Creation
RMAN Backup
11
Review & Assessment
Theory: 1 hr  ·  Lab: 2 hrs  ·  Total: 3 hrs
▼
Recap
Quiz
Common Mistakes
Q&A
78
Programme Hrs
56
Theory Hrs
22
Lab Hrs
📄 DBA_L2 — Certification Syllabus
L2
DBA_L2
Oracle DBA – Certification (Level 2)
Programme: 92 Hours  |  Theory: 66 hrs  |  Lab: 26 hrs  |  Intensive segment: ~23.5 hrs (3 days)
01
Oracle Instance Management
Theory: 1 hr  ·  Lab: 2 hrs  ·  Total: 3 hrs
▼
Startup/Shutdown
Parameter Files (PFILE/SPFILE)
Memory Tuning
Lab: Configure and tune Oracle instance
02
Storage Structures
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
Segments
Extents
Blocks
Tablespace Management
Lab: Create and monitor storage structures
03
User and Privilege Management
Theory: 1 hr  ·  Lab: 2 hrs  ·  Total: 3 hrs
▼
Roles
Profiles
System/Object Privileges
Quotas
Lab: Assign roles and configure quotas
04
Backup & Recovery with RMAN
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
RMAN Architecture
Backup Strategies
Restore & Recovery Scenarios
Lab: Perform RMAN restore and recovery
05
Data Pump & Export/Import
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
Logical Backup
expdp/impdp
Filters
Performance Tips
Lab: Export and import data using Data Pump
06
Performance Tuning Basics
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
Wait Events
AWR/ASH Reports
SQL Tuning
Lab: Analyze wait events and tune SQL
07
Oracle Networking
Theory: 1 hr  ·  Lab: 2 hrs  ·  Total: 3 hrs
▼
Listener Configuration
TNS
Oracle Net Services
Lab: Configure listener and TNS entries
08
Job Scheduling with DBMS_SCHEDULER
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
Creating Jobs
Programs
Chains
Monitoring Jobs
Lab: Schedule and monitor jobs
09
Flashback Technologies
Theory: 1 hr  ·  Lab: 2 hrs  ·  Total: 3 hrs
▼
Flashback Query, Table, Database
Undo Management
Lab: Perform flashback operations
10
Security Enhancements
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
Auditing
Fine-Grained Access Control
Transparent Data Encryption
Lab: Configure TDE and audit policies
11
Hands-On Practice
Theory: 4 hrs  ·  Lab: 2 hrs  ·  Total: 6 hrs
▼
RMAN Backup/Restore
Data Pump
Performance Tuning
12
Review & Assessment
Theory: 1 hr  ·  Lab: 2 hrs  ·  Total: 3 hrs
▼
Recap
Quiz
Troubleshooting Scenarios
92
Programme Hrs
66
Theory Hrs
26
Lab Hrs
📄 DBA_L3 — Certification Syllabus
L3
DBA_L3
Oracle DBA – Certification (Level 3)
Programme: 100 Hours  |  Theory: 72 hrs  |  Lab: 28 hrs  |  Intensive segment: ~23.5 hrs (4 days)
01
Multitenant Architecture
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
CDB and PDB Concepts
PDB Creation
Cloning
Plug/Unplug Operations
Lab: Create and manage PDBs
02
Real Application Clusters (RAC)
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
RAC Architecture
Clusterware
Cache Fusion
Node Addition/Removal
Lab: Simulate RAC setup and node operations
03
Data Guard Configuration
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
Physical vs Logical Standby
Switchover/Failover
Broker Setup
Lab: Configure Data Guard and test failover
04
Oracle ASM
Theory: 1 hr  ·  Lab: 2 hrs  ·  Total: 3 hrs
▼
ASM Disk Groups
Redundancy Levels
Rebalancing
ASM Commands
Lab: Create and manage ASM disk groups
05
Database Upgrade & Patching
Theory: 1 hr  ·  Lab: 2 hrs  ·  Total: 3 hrs
▼
Manual vs Auto Upgrade
Patch Types
OPatch Utility
Lab: Apply patch using OPatch
06
Performance Tuning Advanced
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
SQL Plan Management
Adaptive Query Optimization
Index Tuning
Lab: Tune queries using advanced techniques
07
Backup & Recovery with RMAN
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
Advanced RMAN Features
Recovery Catalog
Block Media Recovery
Lab: Use recovery catalog and perform block recovery
08
Security & Auditing
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
TDE
Data Redaction
Unified Auditing
Privilege Analysis
Lab: Implement TDE and audit policies
09
Resource Management
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
Resource Manager Plans
Consumer Groups
CPU/IO Allocation
Lab: Configure resource plans and groups
10
Oracle Enterprise Manager (OEM)
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
OEM Setup
Monitoring
Alerts
Job Scheduling
Lab: Monitor DB using OEM and schedule jobs
11
Hands-On Lab
Theory: 6 hrs  ·  Lab: 2 hrs  ·  Total: 8 hrs
▼
RAC Setup
Data Guard Switchover
RMAN Recovery
OEM Monitoring
12
Capstone Project & Review
Theory: 2 hrs  ·  Lab: 2 hrs  ·  Total: 4 hrs
▼
Real-World Scenario
Troubleshooting
Final Assessment
100
Programme Hrs
72
Theory Hrs
28
Lab Hrs