Oracle DBA: Course Contents

Introduction to Operating System 

Basic Networking, Backup and Storage

Linux Operating Systems

Basic shell program to handle DB tasks

Overview of database

Significance of Database

DB creation using DBCA

DB Availability & Performance

System configuration

Oracle Architecture

SQL (Structured Query Language)

Logical and physical structure of database

SGA & Its memory components

Mandatory Background process

Parameter and server parameter files

DB alert-log file and trace files

Control files

Online Redo Log & Archive Log

DB startup and shutdown

Control file multiplexing

Tablespaces

Listener and Tnsnames

User / Schema creation

DB user profiles

Roles & Privileges

DB object types, creation, and administration

Permanent segment

Rollback segment

Temporary segment

Segment space management.

Components of Blocks

Row migration and row chaining.

Table / Index Reorg

Export & Import (Datapump)

DB monitoring

DB statistics

DB interview questions

Mock interview

Grid and RDBMS Software installation.

DB Creation 

Traditional export & import & Datapump

Backup & Recovery:

RMAN Hot Backup

RMAN Cold Backup

Block Corruption and Recovery

High Availability:

Data Guard (Physical Standby)

Switch Over and Failover

Filesystem Vs ASM

Maximum Availability Architecture:

RAC setup

RAC maintenance

RAC administrations

Service creation and maintenance

Load Balancer and Failover

DB Upgrade (in-place upgrade / out-place upgrade)

Performance tuning:

AWR analysis

ADDM analysis

ASH analysis

Trace File Analysis

Oracle SPM

Grid and RDBMS Patch Management:

One-off patch

Quarterly CPU patch

Rollable and non-rollable patches

DB versions and feature comparison:

10g, 11gR2, 12c, 19c 

DBMS packages

DB monitoring

Corporate exposure

Python Script: Basics

DB inteview questions

Mock interview