DBA
  • 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
    • Blocks
    • Extents
    • Segments
    • Tablespace Management
  • 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
    • Select Queries
    • 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
  • Best Practise & Industry Case Study