Module 1: PL/SQL Basics

• PL/SQL block structure

• Variables and data types

• Conditional statements (IF, CASE)

• Loops (WHILE, FOR)

• Exception handling (TRY-CATCH)

​

Module 2: SQL in PL/SQL

• Embedding SQL in PL/SQL

• Cursors in PL/SQL

• Implicit vs. explicit cursors

• Cursor attributes and operations

​

Module 3: PL/SQL Procedures

• Creating and executing procedures

• Input and output parameters

• Calling procedures from SQL and PL/SQL

 

Module 4: PL/SQL Functions

• Creating and executing functions

• Returning values from functions

• Calling functions from SQL and PL/SQL

 

Module 5: PL/SQL Triggers

• Introduction to triggers

• Trigger types (BEFORE, AFTER, INSTEAD OF)

• Trigger syntax and execution

• Trigger examples and use cases

 

Module 6: PL/SQL Packages

• Understanding packages

• Creating and using packages

• Package specifications and bodies

• Access control and encapsulation

 

Module 7: Dynamic SQL in PL/SQL

• Dynamic SQL concepts

• EXECUTE IMMEDIATE statement

• Dynamic SQL examples

• Security considerations

 

Module 8: Error Handling and Debugging

• Error handling best practices

• DBMS_ERRLOG and EXCEPTION_INIT

• Debugging tools and techniques

• Profiling and performance tuning