Unlock the full potential of your Oracle development skills. Learn to solve complex data challenges, improve execution efficiency, and apply coding standards that reduce vulnerabilities. By the end of the course, you’ll have the expertise to design and maintain high-performing, secure PL/SQL applications.
15% off eLearning, up to 20% off virtual courses - use code: NSWOCT25UAE
View courses
dadc0606-cad5-496d-ae6f-d90e11f66f82
Oracle Advanced PL-SQL
Select your learning method
Learn essential skills
Course overview
Develop, optimise and secure PL/SQL code with confidence
This three-day course is designed for experienced database professionals. Through a blend of expert instruction and practical exercises, you’ll explore advanced techniques that improve performance, strengthen security, and enhance the functionality of your applications.
Learning objectives
- Optimise PL/SQL performance
- Master collections
- Manage large objects (LOBs) efficiently
- Apply fine-grained access control
- Strengthen your code security
- Integrate external routines
- Leverage Oracle’s built-in packages
- Diagnose performance bottlenecks
What you’ll learn
This course offers an in-depth look at advanced PL/SQL capabilities, helping you develop techniques to optimise performance, enhance security, and manage complex data with precision. You’ll gain practical experience in areas such as code profiling and efficient data management.
Working with collections
Develop the skills to work effectively with Oracle’s collection types, including associative arrays, varrays, and nested tables. The course explains how each structure works, when it is most effective, and how to implement it for flexible, efficient data handling. Through practical examples, you’ll see how collections can simplify code, improve performance, and support more sophisticated data processing.
Fine-grained access control
Learn how to protect sensitive data by defining precise access rules that determine exactly what each user can view or modify. Using application contexts and Oracle’s policy-based controls, you’ll be able to restrict access at the row level, ensuring compliance with security requirements while maintaining application performance and providing users with only the data relevant to their role.
Performance tuning
Explore proven techniques to enhance the speed and efficiency of your PL/SQL programs, from reducing unnecessary SQL calls to leveraging bulk processing for handling large data volumes. The course also covers strategic use of compiler settings and caching to maximise execution efficiency, giving you the insight and skills to identify performance bottlenecks and implement effective, lasting improvements.
Application security
Learn how to safeguard your PL/SQL code against common vulnerabilities such as SQL injection by applying defensive programming techniques from the outset. The course demonstrates how to use Oracle’s DBMS_ASSERT package and other security measures to validate input, reduce attack surfaces, and build applications that maintain integrity and resilience in the face of evolving security threats.
What’s included
- 3 days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
- Course completion certificate
Key facts
Who it’s for
Oracle developers and database administrators who already work with PL/SQL but want to advance their knowledge
Prerequisites
You should have completed our Oracle SQL, Oracle PL/SQL, or Oracle PL/SQL Stored Program Units course, or have the equivalent working knowledge.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
Enhance your programming expertise with our Oracle Advanced PL/SQL course. Cover advanced techniques including performance optimisation, data handling, and integration.
How does this course help improve PL/SQL performance?
You’ll learn to identify and resolve performance bottlenecks using techniques such as bulk processing, caching, SQL call reduction, and strategic compiler settings. By applying these methods, you can significantly improve execution speed and resource efficiency in your PL/SQL applications.
What is the best way to manage large objects (LOBs) in Oracle?
Managing LOBs effectively involves using the right storage type, such as SecureFile for improved performance, compression, encryption, and deduplication. The course covers how to create, store, retrieve, and optimise large objects, including binary and character LOBs, as well as handling BFILEs and temporary LOBs.
Can I call external programs from PL/SQL, and how is it done securely?
Yes. PL/SQL can interact with external programs written in languages like C or Java. The course shows you how to define and register external libraries, configure secure access, and call these routines efficiently while ensuring that system-level operations do not compromise security or stability.
How is the training delivered?
This course is delivered through our live virtual classroom study option. You’ll take part in interactive sessions, practical exercises and discussions, ensuring you gain both the technical knowledge and hands-on experience needed to apply advanced PL/SQL techniques effectively.
What our customers say
"The instructor was particularly good and very knowledgeable and anything he didn't know he would investigate and come with the explanation. That is not my first class with him and one of the reasons, I actually book with this company.”
Caroline, Oracle Advanced PL/SQL learner
“Very well laid out and John does an amazing job of explaining things in detail.”
Ali, Operations Technical Service Analyst - Utilities
Why study with ILX
500,000+ learners
Join the half a million learners developing their skills with our training
5,000+ businesses
A trusted partner to thousands of organisations worldwide
96% customer satisfaction
Our passionate team goes above and beyond to support customer needs
Quote request
Please complete the form to ensure your quote is accurate and we will contact you soon.
For the best prices, get in touch!