Syllabus

2 months
On Oracle 18c

Introduction, Basics & Overview of Oracle and Oracle DBA
Linux Setup on (Oracle VM) Virtual Machine
- Setting up a VM (Virtual Machine)
- Importing Linux Image into VM
- Linux Commands - Example (ps, ls, top, df and many more) as required for DBA
Installing Oracle Database Server on Linux VM
- Installing Oracle 18c XE DB via rpm
- Setting bash profiles
- Working with Listeners, Tnsnames.ora & Listener.ora files
Understanding Oracle Database Architecture
- Architectural Components
- Background Processes
- Memory structures like SGA, PGA, shared pool, large pool and many more
Understanding Oracle Database Instance
- PFILE, SPFILE and parameter changes
- DB startup and shutdown modes
- Alert.log, dictionary views and dynamic performance views

Understanding Database Storage Structures
- Blocks
- Extents
- Segments
Tablespace Management
- Introduction to Tablespace
- Tablespace Creation
- Managing Datafiles
- Undo Tablespace
- Temp Tablespace
Creating Database
- Updating server files
- Mapping Database Instance
- Mapping Tablespaces
- Mapping users
- Setting up prvileges
Using Database
- Table Creation
- CRUD Operations
- Table Management
Administering User Security and Resources
- Creating Users, Roles etc
- Assigning Roles
- Managing Profiles

Managing Data Concurrency
- Understanding Object and Row locking
- Simulating locking Scenario, Detecting and Resolving it via SQL scripts
Backup and Recovery
- Types of backups: Hot and Cold
- RMAN Backups
- Putting DB in Archivelog modes
- Restoring DB from RMAN backup
Data Export / Import
- SQL Loader
- Export (and taking backups with export)
- Export Datapump
Misc. Topics
- db links
- dbms_scheduler
SQL Tuning (Performance Enhancements)
- Explain Plan
- DBMS_STATS - Gathering statistics via Oracle supplied package DBMS_STATS
- Creating Appropriate Indexes
- Table Re-Organization

Partitioning
- Types of Partitioning schemes
- Table Partitioning, Tablespace Partitioning etc.
- Understanding Effect of Partitioning
- Listing Partitions
Instance Tuning & AWR Reports
- Understanding AWR reports
- AWR vs ASH reports
- Generating AWR reports
- Reading AWR reports
Tuning Advisors
- SQL query tuning advisor
- Memory advisors: SGA, PGA, Database Buffer cache advisors
- Automatic Database Diagnostics Monitor (ADDM) reports
Oracle 18c Multitenant Architecture
- Basics
- Creating PDBs
- Plugging and unplugging PDBs
- Cloning a PDB within CDB
Certification Preparation
Interview Prepare Sessions