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
- What is PL/SQL?
- Advantages of using PL/SQL
Basic Structure of a PL/SQL Block
- Anonymous blocks
- Named blocks
Variables and Data Types
- Declaration of variables
- Syntax and rules
- Data types in PL/SQL
- Using variables in PL/SQL blocks
Control Structures
- IF-THEN-ELSE
- CASE statements
- FOR loops
- WHILE loops
Stored Procedures and Functions
- Creating and running stored procedures
- Syntax and examples
- Input and output parameters
- Creating and executing functions in PL/SQL
- Syntax and examples
- Usage in SQL statements
Cursors
- Explicit cursors
- Implicit cursors
- Fetching data
- Cursor attributes
Exception Handling
- Predefined exceptions
- User-defined exceptions
- Using TRY-CATCH blocks
Transaction Control
- Transaction control in PL/SQL
- Using nested blocks and transactions
- Managing nested transactions
- Creating and using savepoints
Advanced Cursor Techniques
- Strong vs. weak REF CURSOR
- Usage scenarios
Triggers
- Creating triggers
- Types of triggers
- Using triggers for auditing
Packages in PL/SQL
- Creation
- Specification
- Implementation
- Execution
- Invocation
- Real-world application
- Code walkthrough
Summary and Next Steps
Requirements
- Basic understanding of SQL
- Understanding of database schemas, tables, and relationships
Audience
- Database administrators
- Database developers
- Software developers
- Data analysts
21 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 £5700 online delivery, based on a group of 2 delegates, £1800 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 (5)
The PL/SQL session basics. I used PL/SQL but never got the basics of it and this course helped me a lot understand PL/SQL queries.
Stefan-Andrei
Course - PL/SQL in Oracle 19c
Very balanced training and practice oriented, very glad that I had the virtual machine and was able to work in parallel with trainer the exercises
Robert
Course - PL/SQL in Oracle 19c
Trainer was patient with us and he made sure we understood each section before moving forward.
RONIKA - Igaye Projects (PTY) LTD
Course - PL/SQL in Oracle 19c
The way he explained everything
Alexandra G - DB Global Technology
Course - PL/SQL in Oracle 19c
The exercises were explained very good.
