Oracle Database / Intermediate: application SQL and evidence

Oracle Database β€” Intermediate: application SQL and evidence

Coordinate imports, analytics, hierarchies, PL/SQL and concurrent work with scoped plan evidence.

6 lessons Β· No account required

What you will learn

  • Compose deterministic source changes, windows and procedural interfaces.
  • Reason about index costs, locks and consistent-read history.

  1. DML, MERGE and idempotent imports

    Apply source changes deterministically while preserving business keys, freshness and retry safety.

    Start learning

  2. Analytic windows and deterministic ranking

    Retain shipment detail while calculating ranks, running totals and previous-event comparisons.

    Start learning

  3. Subqueries, factoring and hierarchical paths

    Compose readable query stages and traverse depot relationships without confusing path semantics with materialization.

    Start learning

  4. PL/SQL blocks, cursors and error contracts

    Combine procedural decisions with set-based SQL while keeping failure and transaction ownership explicit.

    Start learning

  5. Indexes, statistics and plan evidence

    Connect access paths to selective predicates and diagnose estimation mistakes before proposing an index.

    Start learning

  6. Locking, isolation and undo

    Protect capacity invariants and distinguish normal waiting, deadlocks and missing historical versions.

    Start learning
Back to course