About this Course
Certified PL/SQL Developer Course
Welcome to the Certified PL/SQL Developer course! This comprehensive training program is designed to equip you with the knowledge and skills necessary to become a proficient PL/SQL developer. PL/SQL (Procedural Language/Structured Query Language) is a powerful extension of SQL used for developing stored procedures, functions, triggers, and packages within Oracle Database systems.
Throughout this course, you will delve into the essential concepts of PL/SQL development, mastering the syntax, features, and best practices required to build efficient and robust database applications. The course curriculum has been carefully crafted to provide a balance between theoretical knowledge and hands-on exercises, ensuring a deep understanding of PL/SQL concepts through practical application.
Course Objectives
- Understand the fundamentals of PL/SQL programming and its role in Oracle Database systems.
- Learn how to write and execute PL/SQL blocks, including variables, control structures, and error handling mechanisms.
- Explore the various types of PL/SQL program units, such as procedures, functions, triggers, and packages.
- Gain proficiency in using SQL statements within PL/SQL code to interact with the database.
- Master advanced PL/SQL concepts, including cursors, collections, exception handling, and dynamic SQL.
- Discover performance optimization techniques for PL/SQL code to ensure efficient execution.
- Acquire the skills to design and implement secure, maintainable, and scalable PL/SQL solutions.
- Prepare for the Certified PL/SQL Developer certification exam.
Course Syllabus
- Introduction to PL/SQL
- PL/SQL overview and benefits
- PL/SQL architecture
- PL/SQL tools and environments
- PL/SQL Basics
- PL/SQL block structure
- Variables and data types
- Control structures (IF, CASE, LOOP)
- Exception handling
- Program Units
- Procedures and functions
- Triggers and their types
- Packages and package bodies
- SQL in PL/SQL
- Executing SQL statements in PL/SQL
- Retrieving data with cursors
- Using explicit and implicit cursors
- Advanced PL/SQL Concepts
- PL/SQL collections (arrays, nested tables, and associative arrays)
- Bulk operations
- Dynamic SQL
- Advanced exception handling
- Performance Optimization
- Tuning PL/SQL code for performance
- Identifying and resolving performance bottlenecks
- Using SQL tuning techniques
External Resources
Sign in to enroll and start your certification.
How to Get Certified

Complete the Course
Answer the certification questions by selecting a difficulty level:
Beginner: Master the material with interactive questions and more time.
Intermediate: Get certified faster with hints and balanced questions.
Advanced: Challenge yourself with more questions and less time

Earn Your Certificate
To download and share your certificate, you must achieve a combined score of at least 75% on all questions answered.
Course Features
Honorary Certification
Receive a recognized certificate before completing the course.
Learning Pack
Get a carefully curated set of materials to help you learn better in this course.
Pricing Plans
Currency
Sign in to change your currency
I'm not ready to enroll?
Our team is here to help you choose the best options for your learning goals.
Frequently Asked Questions
For detailed information about our Certified PL/SQL Developer course, including what you’ll learn and course objectives, please visit the "About This Course" section on this page.
The course is online, but you can select Networking Events at enrollment to meet people in person. This feature may not always be available.
The course doesn't have a fixed duration. It has 23 questions, and each question takes about 5 to 30 minutes to answer. You’ll receive your certificate once you’ve answered most of the questions. Learn more here.
The course is always available, so you can start at any time that works for you!
We partner with various organizations to curate and select the best networking events, webinars, and instructor Q&A sessions throughout the year. You’ll receive more information about these opportunities when you enroll. This feature may not always be available.
You will receive a Certificate of Excellence when you score 75% or higher in the course, showing that you have learned about the course.
An Honorary Certificate allows you to receive a Certificate of Commitment right after enrolling, even if you haven’t finished the course. It’s ideal for busy professionals who need certification quickly but plan to complete the course later.
The price is based on your enrollment duration and selected features. Discounts increase with more days and features. You can also choose from plans for bundled options.
Choose a duration that fits your schedule. You can enroll for up to 7 days at a time.
No, you won't. Once you earn your certificate, you retain access to it and the completed exercises for life, even after your subscription expires. However, to take new exercises, you'll need to re-enroll if your subscription has run out.
To verify a certificate, visit the Verify Certificate page on our website and enter the 12-digit certificate ID. You can then confirm the authenticity of the certificate and review details such as the enrollment date, completed exercises, and their corresponding levels and scores.
Can't find answers to your questions?
Discussion Forum
Join the discussion!
No comments yet. Sign in to share your thoughts and connect with fellow learners.