Oracle Database 19c: PL/SQL Course

The Oracle Database 19c: PL/SQL Workshop is a professional training program that will help participants harness the capability of PL/SQL, Oracle's procedural programming feature extension to SQL.  

Through this hands-on workshop, participants will engage with several important topics around PL/SQL, including variable declarations, control structures, cursors, triggers, stored procedures and functions.  

In addition to these foundational elements, participants will also gain an understanding of advanced topics such as Dynamic SQL, exception handling, code optimisation, and performance tuning to create database applications that are effective, efficient, scalable, and secure.  

This workshop course is for developers, database administrators, and IT professionals who want to build Oracle skills to prosper in data-centric enterprise environments and implement best practices applicable to the PL/SQL framework and environment.  

The focus is on practical application with the opportunity for real-life application and prompting discovery of Oracle-provided packages and managing some of the inherent dependencies for efficient programming.  

This course is delivered by expert instructors from SSDN Technologies, which is the Best IT Training Company, with the opportunity for the participant to develop job-ready, applicable skills to meet current industry needs and Oracle's best practices. 


Download Content
bannerImg

Learning Options for You

  • Live Training (Duration : 40 Hours)
  • Per Participant

Fee: On Request

Course Prerequisites

To fully benefit from this course, participants should have prior hands-on experience with PL/SQL programming and a solid understanding of Oracle database fundamentals. Familiarity with writing procedures, functions, and triggers is essential to grasp the advanced topics covered in this course.  

  • Proficient understanding of basic PL/SQL concepts, syntax, and constructs 
  • Experience in developing stored procedures, functions, packages, and triggers 
  • Familiarity with Oracle SQL and database objects such as tables, views, and indexes 
  • Knowledge of basic error handling, cursors, and control structures in PL/SQL 

Learning Objectives

The Oracle Database 19c: Advanced PL/SQL course aims to enhance participants’ proficiency in developing high-performance, secure, and reusable PL/SQL code. Learners will explore advanced features such as autonomous transactions, bulk processing, object types, dynamic SQL, and advanced error-handling techniques. The course also covers performance tuning, secure coding practices, and best practices for modular development. By the end of the course, participants will be able to design and implement PL/SQL programs that are scalable, efficient, and aligned with enterprise application requirements. 

Target Audience

The Oracle Database 19c: Advanced PL/SQL course is tailored for experienced PL/SQL developers and Oracle professionals who want to deepen their skills in developing robust, efficient, and maintainable PL/SQL applications. It is ideal for application developers, database developers, technical leads, and software engineers who work extensively with Oracle PL/SQL in complex business environments. This course is also valuable for consultants and support professionals involved in performance tuning and advanced database programming. 

  • PL/SQL developers seeking to master advanced programming techniques 
  • Application developers building enterprise solutions using Oracle databases 
  • Technical leads responsible for code quality, reusability, and performance 
  • Software engineers and system integrators working on large-scale Oracle implementations 
  • Consultants and support teams optimizing and troubleshooting PL/SQL applications 

Register Your Interest

captcha

FAQs

You will learn how to develop and manage PL/SQL stored procedures, functions, packages, and triggers in Oracle Database 19c. The course covers PL/SQL programming fundamentals, advanced techniques, error handling, performance considerations, and integration with SQL.
After completing this course, you can pursue roles such as PL/SQL Developer, Oracle Database Developer, Application Developer, and Database Programmer, or enhance your existing DBA skillset with PL/SQL development expertise.
Basic knowledge of SQL and familiarity with Oracle Database concepts are recommended before enrolling in this course.
The course typically runs for 3 to 5 days, depending on the delivery mode and training provider.
The fee varies by training provider and region. Please contact your authorized training partner for exact pricing.
Yes, participants usually retain access to the official course materials and documentation for reference after the course ends.
Recordings may be provided if you attend a virtual session, depending on the training provider’s policy. Please confirm at the time of enrollment.
The course is taught by Oracle-certified instructors with deep expertise in PL/SQL development and Oracle Database technologies.
The course is available in both online (Live Virtual Class) and in-person classroom formats, depending on your preference and provider.
Yes, you will receive an official certificate of completion from the training provider or Oracle University after successfully completing the course.

Our Learners Say About Our Courses

underline
testimonialImg