Oracle Database: PL/SQL Workshop Training in Netherlands

Module one: Introduction to PL/SQL

• Overview of PL/SQL runtime architecture.
• Understanding PL/SQL block structure.
• Benefits of using PL/SQL for database operations.

Module two: Declaring PL/SQL variables

• Variable declaration, initialization, and scope.
• Using the %TYPE and %ROWTYPE attributes.
• Working with composite data types.

Module three: Writing executable statements

• Lexical units and PL/SQL block syntax.
• SQL functions and sequences in PL/SQL.
• Best practices for writing readable and maintainable code.

Module four: Using SQL statements within PL/SQL

• Executing SELECT, INSERT, UPDATE, and DELETE within PL/SQL.
• Managing cursors and SQL cursor attributes.
• Handling naming ambiguities in SQL statements.

Module five: Writing control structures

• Conditional statements (IF, CASE).
• Loops (FOR, WHILE, BASIC).
• Nested and labelled loops with scope management.

Module six: Exception handling in PL/SQL

• Types of exceptions (predefined, user-defined).
• Using RAISE and RAISE_APPLICATION_ERROR.
• Guidelines for structured exception management.

Module seven: Creating and managing subprograms

• Differences between procedures and functions.
• Parameter modes and their applications (IN, OUT, IN OUT).
• Best practices for modular program design.

Module eight: Advanced PL/SQL features

• Creating and using packages for modular programming.
• Writing and managing triggers.
• Implementing dynamic SQL with EXECUTE IMMEDIATE.

Module nine: Debugging and performance tuning

• Using Oracle SQL Developer for debugging.
• Managing dependencies and recompilation.
• Optimising PL/SQL code using compiler warnings.