PL/SQL Training in Genoa

This instructor-led, live training in Genoa (online or onsite) is designed for intermediate-level developers and administrators seeking a solid PL/SQL programming foundation to develop efficient and robust database applications using Oracle 19c.

Upon completion of this training, participants will be able to:

• Acquire a thorough understanding of PL/SQL and its benefits compared to standard SQL.
• Master the declaration and usage of variables and various data types within PL/SQL blocks.
• Utilize control structures such as IF-THEN-ELSE, CASE statements, and loops to develop robust PL/SQL programs.
• Understand and implement both explicit and implicit cursors for data retrieval.
• Effectively manage exceptions using predefined and user-defined error handlers.
• Develop and manage triggers to automate processes and enforce business rules.
• Create and utilize PL/SQL packages to encapsulate and modularize code for enhanced reusability and maintainability.

This three-day course provides an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions, and triggers using both SQL and PL/SQL commands.

The course takes the format of a workshop, with a mix of lecture, working examples, and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.

Full course notes are provided along with sample database files, example SQL files, and free software tools for use in accessing an ORACLE database.