Oracle SQL Mastery: Tuning, PL/SQL Essentials & Advanced Features
Calculate cardinalities and plan costs like the optimizer, use bind variables well, and write PL/SQL with cursors, exceptions, BULK COLLECT, FORALL, packages and Flashback, with every answer checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
Oracle SQL Mastery is an advanced, hands-on course for developers who already write Oracle SQL. You calculate row estimates the way the optimizer does, from num_distinct, histograms and join statistics, compare them with actual rows, and cost index scans, full scans, nested loops and hash joins. You measure what hard parsing and bind peeking cost, then write and trace PL/SQL: blocks, loops, explicit cursors, SQL%ROWCOUNT, exception handling, savepoints, BULK COLLECT with LIMIT, FORALL with SAVE EXCEPTIONS and package state. Flashback Query, undo sizing and a full tuning case finish the course. Every answer is checked instantly, and the first lesson is free.
Lessons
- Reading a Plan: Estimated vs Actual RowsFree
- Selectivity for Ranges, NULLs and Combined Predicates Locked
- Histograms: Estimates for Skewed Data Locked
- Join Cardinality: How Many Rows a Join Returns Locked
- Nested Loops vs Hash Join: Counting the Work Locked
- Index Access Cost and the Clustering Factor Locked
- Bind Variables and the Cost of Hard Parsing Locked
- Bind Peeking and Adaptive Cursor Sharing Locked
- PL/SQL Blocks, Variables and IF Logic Locked
- Loops: WHILE, FOR, EXIT and CONTINUE Locked
- Explicit Cursors and the %NOTFOUND Trap Locked
- SQL%ROWCOUNT and SELECT INTO Rules Locked
- Exceptions: Where the Handler Sits Matters Locked
- Transactions, Savepoints and Statement-Level Rollback Locked
- Row by Row vs Set-Based: Counting Context Switches Locked
- BULK COLLECT with LIMIT and the Lost Last Batch Locked
- FORALL and SAVE EXCEPTIONS Locked
- Packages and Per-Session State Locked
- Flashback Query: Reading the Past Locked
- Undo Retention, Sizing and ORA-01555 Locked
- Capstone: Tuning a Nightly PL/SQL Job Locked