Oracle Database: Program with PL/SQL

• An understanding of relational database concepts
• Basic knowledge of SQL
• Familiarity with procedural programming fundamentals

Audience

• Database developers
• Backend programmers and data engineers
• Technical support and DevOps personnel working with Oracle environments

PL/SQL (Procedural Language/SQL) is Oracle’s extension to SQL that enables developers to write procedural logic directly inside the database.

This instructor-led, live training (online or onsite) is aimed at intermediate-level developers and technical professionals who wish to write robust PL/SQL programs, manage exceptions, and create reusable procedures, functions, and packages in Oracle Database.

By the end of this training, participants will be able to:

• Create PL/SQL blocks, procedures, and functions to encapsulate business logic.
• Use control structures, cursors, and exception handling effectively.
• Define and manage packages, triggers, and stored logic securely.
• Debug and test PL/SQL code using standard Oracle tools.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

PL/SQL Fundamentals

• PL/SQL architecture and block structure
• Data types, variables, and constants
• Declaring and assigning variables

Control Flow and Decision Logic

• IF, CASE, and nested conditions
• LOOP, WHILE, and FOR constructs
• EXIT and CONTINUE statements

Cursors and Transactions

• Implicit and explicit cursors
• Cursor FOR loops and attributes
• Transaction control: COMMIT, ROLLBACK, SAVEPOINT

Exception Handling

• Types of exceptions and WHEN clauses
• Using RAISE_APPLICATION_ERROR
• Custom exceptions and handlers

Procedures and Functions

• Creating procedures and functions
• IN, OUT, and IN OUT parameters
• Calling stored procedures from SQL and PL/SQL

Packages and Triggers

• Creating and managing packages
• Package specification vs. body
• Row-level and statement-level triggers

Security and Testing

• Granting and revoking execution privileges
• Debugging PL/SQL with SQL Developer
• Unit testing stored procedures and packages

Summary and Next Steps