Model Online / On-Site
Duration
Modules 5 modules

Course Objective & Scope

Powering core systems in banking, telecoms, government and large enterprises, Oracle Database (19c / 23ai) has a distinct memory, process and storage architecture that rewards deep technical understanding. This course gives developers and administrators a clear grasp of how Oracle works under the hood, how to tune workloads and how to manage production environments safely.

It covers the Oracle Instance (SGA, PGA, background processes) and Multitenant (CDB/PDB) architecture, logical and physical storage (Tablespaces, Segments, Extents, Blocks, Redo/Undo), index types (B-Tree, Bitmap, Function-Based) and partitioning, the Cost-Based Optimizer and execution plans, bottleneck analysis with AWR/ASH reports, RMAN backup/recovery and Data Guard fundamentals.

Who Should Attend?

  • Database administrators (DBAs) and systems engineers managing Oracle environments
  • Senior developers and data architects building high-volume enterprise applications on Oracle
  • Tech leads who need to read execution plans and interpret AWR/ASH performance reports
  • Prerequisite: foundational relational database and SQL knowledge

Key Takeaways

  • Manage Oracle SGA/PGA memory structures, Redo/Undo internals and Multitenant CDB/PDB containers
  • Select appropriately between B-Tree, Bitmap and Function-Based indexes and table partitioning strategies
  • Diagnose slow SQL using DBMS_XPLAN, optimizer statistics and Oracle wait events
  • Read AWR and ASH reports to pinpoint system-wide I/O, CPU, latch and lock bottlenecks
  • Execute backup and point-in-time recovery procedures using RMAN and Oracle Flashback features

Curriculum

Oracle Instance, Multitenant (CDB/PDB) and Storage Architecture
  • SGA (Buffer Cache, Shared Pool, Redo Log Buffer), PGA memory and background processes (DBWn, LGWR, CKPT, SMON, PMON)
  • Multitenant architecture: managing Container Databases (CDB) and Pluggable Databases (PDB)
  • Logical vs physical storage: Tablespaces, Segments, Extents, Data Blocks (PCTFREE) and Undo/Redo flow
Schema Objects, Index Types and Table Partitioning
  • Heap tables, Index-Organized Tables (IOT), Global Temporary Tables and Sequence caching
  • When to use B-Tree, Bitmap, Function-Based, Reverse Key and Invisible indexes
  • Range, List, Hash and Interval/Composite Partitioning with Local vs Global partitioned indexes
The Cost-Based Optimizer (CBO), Statistics and SQL Tuning
  • Hard parse vs soft parse: bind variables, cursor sharing and avoiding Shared Pool contention
  • Gathering statistics and histograms with DBMS_STATS and reading plans via DBMS_XPLAN.DISPLAY_CURSOR
  • Nested Loops, Hash Join and Sort Merge Join access paths plus lock/enqueue troubleshooting
Performance Diagnostics: Wait Events, ASH and AWR Reports
  • The Oracle Time Model (DB Time, DB CPU) and top wait events (db file sequential/scattered read, log file sync, enq: TX)
  • Step-by-step walkthrough of Active Session History (ASH) and AWR diagnostic reports
Security, RMAN Backups, Flashback and Data Guard
  • Users, profiles, roles, privileges and logical data movement with Oracle Data Pump (expdp / impdp)
  • ARCHIVELOG mode, RMAN full/incremental backups and recovery, plus Flashback Query/Table/Database
  • Overview of Oracle Data Guard and Real Application Clusters (RAC) for high availability and DR

Other Courses in This Category

  • MongoDB Document Data Modelling, Aggregation and Operations

    BSON and document schema design patterns (embedding vs referencing), the Aggregation Pipeline, compound/multikey indexes and the ESR rule, multi-document ACID transactions, Change Streams, Replica Sets and Sharding.

    Databases Corporate
    Live Course
    5 modules
    View
  • In-Memory Data Structures, Caching and Messaging with Redis

    Redis data structures (Strings, Hashes, Lists, Sets, Sorted Sets, Streams, HyperLogLog), caching patterns (cache-aside, stampede protection), distributed locks, rate limiting, Lua/pipelining, RDB/AOF persistence and Redis Cluster.

    Databases Corporate
    Live Course
    5 modules
    View
  • Distributed NoSQL Databases with Apache Cassandra

    Masterless ring architecture, consistent hashing, tunable consistency (LOCAL_QUORUM), LSM-Tree/SSTable storage internals, query-driven CQL data modelling and cluster operations — for high-write distributed systems.

    Databases Corporate
    Live Course
    5 modules
    View
  • Search and Real-Time Analytics with Elasticsearch and OpenSearch

    Inverted index and Lucene internals, text analysis (tokenizers/filters), mapping design, Query DSL and BM25 relevance tuning, Aggregations, hybrid/vector search and cluster lifecycle management (ILM/ISM).

    Databases Corporate
    Live Course
    5 modules
    View
  • Graph Databases, Data Modelling and Cypher with Neo4j

    Labeled Property Graph modelling, the Cypher query language and variable-length path traversals, index-free adjacency, PROFILE/EXPLAIN tuning, Graph Data Science (PageRank, Louvain) and Knowledge Graph/GraphRAG patterns.

    Databases Corporate
    Live Course
    5 modules
    View
  • Time-Series Databases with TimescaleDB and InfluxDB

    Time-series data modelling, managing high cardinality, TimescaleDB (hypertables, continuous aggregates, compression) and InfluxDB/VictoriaMetrics, downsampling and automated retention policies.

    Databases Corporate
    Live Course
    5 modules
    View

Get in touch