Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to PL/SQL
- Overview of the PL/SQL runtime environment
- Structure and types of PL/SQL blocks
- Declaring and utilizing variables
- Control structures: conditionals and loops
Incorporating SQL within PL/SQL
- Executing DML commands
- Utilizing DDL and dynamic SQL
- Transaction control commands (TCL)
- Performing data retrieval with SELECT statements
Procedures and Functions
- Creation and deletion of procedures and functions
- Parameterization techniques
- Passing parameters by value and by reference; understanding
NOCOPY
Error and Exception Handling
- Strategies for managing errors and exceptions in PL/SQL
Cursor Management
- Understanding records and static cursors
- Parameterizing cursors
- Implementing cursors with
FOR UPDATE
Associative Arrays
- Declaring and using associative arrays in PL/SQL
Packages
- Structure of packages: specifications and bodies
- Initialization sections, global variables, and memory management
- Concepts of encapsulation, overloading, and forward declarations
Triggers
- Creating DML triggers
- Implementing INSTEAD OF triggers
- Understanding system triggers
- Exploring advanced trigger features
Practical Applications of Built-in Packages
- Writing to files using
UTL_FILE - Sending emails from PL/SQL
Code Management and Compilation
- Techniques for code encryption and obfuscation
- Utilizing conditional compilation
- Managing object dependencies
- Interpreting compiler warnings
Summary and Next Steps
Requirements
- Basic proficiency in any programming language (structured or object-oriented)
- Familiarity with SQL fundamentals and the Oracle database environment
Audience
- Developers
- Database administrators
28 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €9120 online delivery, based on a group of 2 delegates, €2880 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (3)
I liked very much the format of the training, hands on, directly in sql developer.
Andreea - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
The exercises were explained very good.
Monica - DB Global Technology
Course - PL/SQL in Oracle 19c
It was quite hands-on, not too much theory.
