💡
How to use this roadmap: Follow the tracks in order — Linux → SQL → Oracle DBA → Advanced. Click any section header to explore its modules in detail. Click module topics to see full learning content on the Modules page.
🏛️
Oracle DBA
Weeks 10–16
M1Introduction to Linux
- What is Linux
- Everyday Use of Linux
- Unix vs Linux
View all topics →
M2Virtual Machines & Lab Setup
- What is a Virtual Machine (VM)
- IP Address
- Oracle VirtualBox
- Creating a VM
- Linux vs Windows OS
View all topics →
M3File System & Navigation
- Terminal & SSH Access
- File System Introduction
- Navigation Commands
- Creating Files & Directories
- Removing Files & Directories
- Copy Files & Directories
- Finding Files, Wildcards
- Reading Files in Linux
View all topics →
M4File Management & Permissions
- File Permissions (chmod)
- File Ownership (chown)
- Pipes & Redirection
- Filters (grep, awk, sed)
- Compress, Compare, Split Files
View all topics →
M5User Management & System Admin
- vi / vim Editor
- User Account Management
- sudo Access
- Process Monitoring (ps, top)
- System Logs, Cron Jobs
View all topics →
M6Networking & Remote Access
- SSH & Telnet
- Securing SSH
- curl, ping, SCP
- YUM & WGET
- Firewall Configuration
View all topics →
M7Storage & Disk Management
- Storage Concepts
- Disk Partitioning (df, fdisk)
- OS Variants: RHEL, CentOS
View all topics →
M1Database & Environment Setup
- DBMS and SQL Overview
- Oracle Database Intro
- SQL Developer & SQLPlus Setup
View all topics →
M2Basic SELECT Statements
- Writing SELECT Statements
- Arithmetic & NULL Values
- Column Aliases, DISTINCT
View all topics →
M3Filtering Data
- WHERE Clause
- Comparison Operators
- Logical Operators (AND, OR, NOT)
View all topics →
M4Sorting & Row Limiting
- ORDER BY Clause
- Row Limiting (FETCH FIRST / ROWNUM)
View all topics →
M5Group Functions & Aggregation
- Aggregate Functions
- GROUP BY & HAVING Clauses
View all topics →
M6Joins
- Inner / Outer Joins
- Self Join & Cross Join
- Natural Join, JOIN USING
View all topics →
M7DDL, DML & DB Objects
- DDL — CREATE, ALTER, DROP
- DML — INSERT, UPDATE, DELETE
- Views, Indexes, Schemas
View all topics →
M1Oracle Database Overview
- RDBMS Overview
- Oracle Technologies
- Role of an Oracle DBA
View all topics →
M2Oracle Architecture & Installation
- Oracle Architecture
- Tablespaces & Datafiles
- Installing Oracle Database
View all topics →
M3Memory & Storage Management
- SGA & PGA Components
- Managing Tablespaces
- Undo Tablespace
View all topics →
M4Instance Management
- Startup & Shutdown
- Initialization Parameters
- SPFILE & PFILE
View all topics →
M5Multitenant — CDB & PDB
- Multitenant Architecture
- Creating CDB and PDBs
- Multitenant Admin Tasks
View all topics →
M6Security & User Management
- Users, Privileges & Roles
- Least Privilege Principle
- Password File
View all topics →
M7Oracle Network Configuration
- Oracle Net Services
- Listener Configuration
- TNS Naming Methods
View all topics →
M8Redo & Archive Logs
- Fast Recovery Area (FRA)
- Redo Log Groups & Members
- ARCHIVELOG Mode
View all topics →
M9Backup & Recovery — RMAN
- RMAN Full & Incremental Backup
- Restore & Recovery
- PITR, Flashback, Recovery Catalog
View all topics →
M11Patching Oracle Database
- Patch Types (PSU, RU, One-off)
- OPatch Utility
- Applying Patches
View all topics →
M12Upgrading Oracle Database
- Upgrade Concepts & Methods
- Pre/Post Upgrade Checks
- DBUA & Manual Upgrade
View all topics →
M13Oracle ASM & Oracle Restart
- Oracle ASM Overview
- Oracle Restart
- Creating DB with ASM Storage
View all topics →
🛡️ Oracle Data Guard
- Data Guard Architecture
- Physical & Logical Standby
- Data Guard Broker
- Switchover & Failover
- Active Data Guard
🔗 Oracle RAC
- RAC Architecture
- Clusterware, Voting Disk, OCR
- Load Balancing & Failover
- RAC Administration
🔄 Oracle GoldenGate
- GoldenGate Architecture
- Extract, Pump, Replicat
- Bi-Directional Replication
- Monitoring & Troubleshooting
☁️ OCI (Oracle Cloud)
- OCI Core Concepts
- Database Service on OCI
- Autonomous Database
- OCI Identity & Storage
🖥️ Exadata VM
- Exadata Architecture
- VM Configuration & Management
- Smart Scan & Storage Cells
☁️ ExaCS & ExaCC
- ExaCS Overview & Architecture
- ExaCC Deployment
- ExaCS vs ExaCC Differences