🐧 Linux
M1 – Introduction to Linux
What is Linux
Everyday Use of Linux
Unix vs Linux
M2 – Virtual Machines & Lab Setup
What is a Virtual Machine
IP Address
Oracle VirtualBox
Creating a VM
Linux vs Windows OS
M3 – File System & Navigation
Command Prompt & Terminal
SSH Access (MobaXterm / PuTTY)
File System Introduction
Navigation Commands
File System Paths
Creating Files & Directories
Removing Files & Directories
Copy Files & Directories
Finding Files & Wildcards
Reading Files in Linux
M4 – File Management & Permissions
File Permissions (chmod)
File Ownership (chown)
Pipes & Redirection
grep, awk, sed Filters
Compress & Archive Files
Comparing Files (diff, cmp)
M5 – User Management & System Admin
vi / vim Editor
User Account Management
sudo Access
Process Monitoring (ps, top)
Cron Jobs & Scheduling
System Logs Monitoring
Root Password Recovery
M6 – Networking & Remote Access
SSH & Telnet
Securing SSH
curl & ping
SCP Command
YUM & WGET
Firewall Configuration
M7 – Storage & Disk Management
Storage Concepts
Disk Partitioning (fdisk, df)
RHEL / CentOS Overview
🗄️ SQL
M1 – Database & Environment Setup
DBMS & SQL Overview
Oracle Database Intro
SQL Developer Setup
SQLPlus Connection
M2 – Basic SELECT Statements
SELECT Statements
Arithmetic & NULL Values
Column Aliases
DISTINCT Keyword
Concatenation Operator
M3 – Filtering Data
WHERE Clause
Comparison Operators
Logical Operators
BETWEEN, IN, LIKE, IS NULL
M4 – Sorting & Row Limiting
ORDER BY Clause
Row Limiting (FETCH FIRST)
ROWNUM
M5 – Group Functions & Aggregation
COUNT, SUM, AVG, MIN, MAX
GROUP BY Clause
HAVING Clause
M6 – Joins
Inner Join
Left Outer Join
Right Outer Join
Full Outer Join
Self Join
Natural Join
M7 – DDL, DML & DB Objects
CREATE, ALTER, DROP, TRUNCATE
INSERT, UPDATE, DELETE, MERGE
Data Dictionary Views
Views
Indexes
Schemas
🏛️ Oracle DBA
M1 – Oracle Database Overview
Oracle Database Overview
Oracle Architecture
Oracle Technologies Overview
Role of an Oracle DBA
M2 – Oracle Architecture & Installation
Installing Oracle Database
Instance Structure
Tablespaces & Datafiles
M3 – Memory & Storage Management
SGA Components
PGA Overview
Managing Tablespaces
Datafile Management
Undo Tablespace
M4 – Instance Management
Startup & Shutdown
Initialization Parameters
SPFILE & PFILE
Data Dictionary Queries
M5 – Multitenant — CDB & PDB
Multitenant Architecture
Creating CDB and PDBs
Multitenant Admin Tasks
M6 – Security & User Management
Users, Privileges & Roles
User Profiles
Least Privilege Principle
SYS / SYSTEM Accounts
Password File
M7 – Oracle Network Configuration
Oracle Net Services
Listener Configuration
TNS Naming
M8 – Redo & Archive Logs
Fast Recovery Area (FRA)
Redo Log Groups & Members
ARCHIVELOG Mode
M9 – Backup & Recovery — RMAN
RMAN Full Backup
RMAN Incremental Backup
RMAN Restore & Recovery
Point-in-Time Recovery (PITR)
Automating Backups
Recovery Catalog
Flashback Database
M10 – Oracle Data Pump
expdp — Export Data Pump
impdp — Import Data Pump
Data Pump Parameters & Modes
M11 – Patching Oracle Database
Patch Types (PSU, RU, One-off)
OPatch Utility
Applying Patches
M12 – Upgrading Oracle Database
Upgrade Concepts & Methods
Pre/Post Upgrade Checks
DBUA & Manual Upgrade
M13 – Oracle ASM & Oracle Restart
Oracle ASM Overview
Oracle Restart
Creating DB with ASM Storage
⚡ Advanced Topics
Oracle Data Guard
Data Guard Architecture
Physical Standby DG Setup
Data Guard Broker
Switchover & Failover
Active Data Guard
Oracle RAC
Oracle RAC Architecture
RAC Clusterware
Voting Disk & OCR
Load Balancing in RAC
Oracle GoldenGate
GoldenGate Architecture
Extract & Replicat Processes
Bi-Directional Replication
OCI & Exadata
OCI Overview
Autonomous Database
Exadata Architecture
Smart Scan
ExaCS Overview
ExaCC Overview
💡 Suggest a Topic or Share Feedback
If you'd like to see a specific topic explained or have suggestions that can help fellow learners, reach out directly on LinkedIn.
in
Connect on LinkedIn