📚 Day 1: Code Design & Collections
- Lesson 1 : Introduction & Guidelines for efficient PL/SQL design
- Lesson 2 : PL/SQL Programming Concepts: Review (Cursors, Exceptions, Dependencies)
- Lesson 3 : Designing PL/SQL Code (Cursor variables, Subtypes creation)
- Lesson 4 : Working with Collections (Nested tables, Varrays, Associative arrays, Collections methods)
📚 Day 2: Advanced Interfaces, Security & Large Objects
- Lesson 5 : Using Advanced Interface Methods (External C & Java execution)
- Lesson 6 : Implementing Fine-Grained Access Control for VPD (Virtual Private Database)
- Lesson 7 : Manipulating Large Objects (DBMS_LOB, Internal/External LOBs)
- Lesson 8 : Administering SecureFile LOBs (Deduplication, Compression, Encryption)
- Lesson 9 : Performance and Tuning (Compiler influence, Intraunit inlining)
📚 Day 3: Caching, Analysis & Injection Security
- Lesson 10 : Improving Performance with Caching (SQL result set caching, DBMS_RESULT_CACHE)
- Lesson 11 : Analyzing PL/SQL Code (PL/Scope, DBMS_METADATA)
- Lesson 12 : Profiling and Tracing PL/SQL Code (DBMS_PROFILER, DBMS_TRACE)
- Lesson 13 : Safeguarding Your Code Against SQL Injection Attacks (DBMS_ASSERT, immune code design)