Build the skills to write powerful PL/SQL code and strengthen your Oracle development capability. Designed for professionals who support, manage or develop Oracle databases, this course deepens your programming knowledge and builds the confidence to deliver efficient, maintainable solutions for real-world business needs.
15% off eLearning, up to 20% off virtual courses - use code: NSWOCT25USA
View courses
66dc2308-bcfb-463c-9189-a6ceea29788a
Oracle PL-SQL
Select your learning method
Learn essential skills
Course overview
Develop advanced Oracle applications with PL/SQL
Elevate your PL/SQL expertise with our practical two-day Oracle course. Discover how to create, manage and optimise stored programme units including procedures, functions and triggers. You’ll also build the skills to deliver scalable, efficient database applications and enhance the structure, performance and reliability of your Oracle code.
Learning objectives
- Create and maintain Oracle stored procedures
- Build efficient, event-driven PL/SQL triggers
- Design and structure modular PL/SQL packages
- Use built-in Oracle-supplied packages
- Implement and pass data using REF CURSORs
- Handle dependencies between programme units
- Improve processing speed with bulk binding
- Apply dynamic SQL for flexible Oracle development
What you’ll learn
Gain the skills to develop scalable, performance-driven Oracle applications with this advanced PL/SQL course. You’ll learn how to manage dependencies, optimise performance through native compilation, apply effective design patterns, and use dynamic SQL securely. This course is ideal for building flexible, reliable solutions in complex Oracle environments.
Managing dependencies
Oracle PL/SQL applications often rely on other database objects. During our course, you’ll learn how Oracle manages these dependencies and what happens when changes cause invalidation. You’ll also discover how to recompile affected units, avoid cascading failures, and maintain a reliable codebase. By mastering dependency management, it’ll help you prevent unexpected errors and reduce downtime in your Oracle environment.
Native compilation and performance optimisation
Native compilation enhances PL/SQL performance by converting code into machine-level instructions, significantly speeding up execution. You’ll explore how to handle compile-time warnings and use the DBMS_WARNING package to catch issues early. These skills help you write cleaner, more efficient PL/SQL code that performs reliably in demanding, production-level Oracle environments.
PL/SQL design best practices
Well-structured PL/SQL code improves performance, security and maintainability. During our course, you’ll explore design techniques such as invoker versus definer rights, local subprogrammes, standardised exceptions and the use of constants. You’ll also learn about compiler hints including NOCOPY and PARALLEL ENABLE, helping you create optimised Oracle applications that are scalable and easier to manage over time.
Using dynamic SQL effectively
Dynamic SQL allows you to create flexible Oracle PL/SQL applications that adapt to variable inputs and dynamic data structures. This course will teach you how to write dynamic SQL securely and efficiently, understand when its use is appropriate, and apply best practices to ensure your applications remain maintainable, powerful and responsive.
What’s included
- Two-days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
Key facts
Ideal for
Oracle developers, database administrators and technical specialists who want to advance their PL/SQL programming skills and deliver more efficient, scalable database solutions
Prerequisites
Learners should be familiar with PL/SQL basics or have completed an introductory Oracle course. Prior experience in writing scripts, procedures or functions will help you get the most from this training
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one
FAQs
Our Oracle PL/SQL course helps you build practical skills in writing, managing and optimising PL/SQL programme units. It’s perfect if you want to deepen your Oracle development knowledge or prepare for the Oracle Database: Program with PL/SQL 1Z0-149 exam.
What are PL/SQL stored programme units?
Stored programme units include procedures, functions, packages and triggers that are saved within the Oracle database. They allow you to reuse logic, improve application structure and run code more efficiently by executing directly within the database environment.
How do compound triggers differ from regular triggers?
Compound triggers combine multiple timing points, such as before and after row-level actions, into one trigger structure. They reduce code duplication and are ideal for managing complex data operations that require control at different stages of a transaction.
What is bulk binding and how can it help in PL/SQL?
Bulk binding improves performance in Oracle PL/SQL by processing multiple rows in a single operation. This minimises the switching between SQL and PL/SQL engines, making it essential for writing efficient code that handles large volumes of data.
Can I use PL/SQL to improve application performance?
Yes, PL/SQL provides advanced features such as bulk processing, native compilation and modular programming, all designed to optimise performance. This course teaches you how to apply these techniques to build Oracle applications that are faster, more reliable and easier to maintain.
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 reason, I actually book with this company.”
Caroline, ILX Learner - Government
“I really enjoyed this course, it was clear the instructor had in-depth knowledge about the subject and was keen on answering questions / explaining problems thoroughly. I also appreciated learning about the principles, best practice standards, and the reasoning behind these.”
Michaela, ILX Learner - Data Scientist - Government
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!