Oracle PL/SQL Training Online

14 Lesson

35 Hours

Add to Wishlist

igmGuru offers the best Oracle PL/SQL Training online worldwide. This course is designed by certified professionals with strong real-time experience in Oracle databases and development. Our training program covers all essential topics such as procedures, functions, packages, cursors, triggers, and exception handling. After completing this course, learners can appear for the latest Oracle PL/SQL Developer Certified Associate (1Z0-149) certification exam and become certified in database development.

Enroll Now

Oracle PL SQL Course Overview

Oracle PL/SQL course covers concepts and techniques for managing and manipulating data in Oracle databases efficiently. Build your skills in stored procedures, functions, triggers, cursors, exception handling, and advanced database programming.

Prerequisites

Beginner level SQL knowledge (SELECT, INSERT, UPDATE, DELETE)
Understanding of relational database concepts
Knowledge of programming modules (loops, variables, conditions)
Experience in Oracle SQL Developer (optional)

What You Will Learn

PL/SQL block structure and syntax
Stored procedures, functions, and packages
Cursors and exception handling
Triggers for automation
Collections, records, and dynamic SQL
Bulk processing and performance tuning
Security practices in PL/SQL
PL/SQL integration with tools
Oracle 23c / 23ai (Oracle AI Database) features:
- AI-enabled PL/SQL enhancements
- VECTOR data types for AI workloads
- Blockchain tables and advanced data security
Real-world PL/SQL application development

Target Audience

Database Developers
SQL Developers
Backend Developers
Data Analysts
System Analysts
IT Professionals
Students or Fresh Graduates from computer science or IT backgrounds
Anyone want to prepare for Oracle Certifications like OCA or OCP

Career Opportunities

PL/SQL Developer
Oracle Developer
Database Developer
Backend Developer
Data Analyst
ETL Developer
Software Engineer with Database Focused
Technical Consultant on Oracle Technologies
Database Administrator (DBA)

Key Features

Instructor Led Training : 35Hrs
Experienced Trainers
100% Money-Back Guarantee
100% Job Assistance
Flexible Schedule
24 X 7 Lifetime Support & Access

Oracle PL SQL Certification Training Curriculum

Lesson 1 - Introduction to Oracle Database and PL/SQL

1. Overview of Oracle Database architecture

2. What is PL/SQL and its advantages

3. Differences between SQL and PL/SQL

4. Introduction to Oracle tools: SQL*Plus, SQL Developer

5. Basic SQL refresher (SELECT, INSERT, UPDATE, DELETE)

6. PL/SQL block structure: anonymous blocks

Lesson 2 - PL/SQL Programming Fundamentals

1. Variables, constants, and data types

2. Control structures: IF-THEN-ELSE, CASE

3. Looping constructs: Basic LOOP, WHILE, FOR loops

4. Basic error handling with EXCEPTION block

5. Using DBMS_OUTPUT for debugging

Lesson 3 - Cursors and Cursor Management

1. Implicit vs explicit cursors

2. Cursor attributes: %FOUND, %NOTFOUND, %ROWCOUNT, %ISOPEN

3. Cursor FOR loops

4. Parameterized cursors

Lesson 4 - Stored Procedures and Functions

1. Creating procedures and functions

2. Parameter modes: IN, OUT, IN OUT

3. Using RETURN in functions

4. Exception handling in procedures and functions

5. Invoking stored subprograms

Lesson 5 - Packages

1. Package specification and body

2. Public and private elements

3. Package variables and cursors

4. Benefits of modular programming

5. Package state and initialization

Lesson 6 - Exception Handling and Debugging

1. Predefined and user-defined exceptions

2. RAISE and RAISE_APPLICATION_ERROR

3. Using SQLCODE and SQLERRM

4. Debugging techniques and tools (DBMS_OUTPUT, SQL Developer debugger)

Lesson 7 - Triggers

1. Types of triggers: BEFORE, AFTER, INSTEAD OF

2. Row-level vs statement-level triggers

3. Creating DML triggers for INSERT, UPDATE, DELETE

4. Trigger mutating table errors and solutions

5. Use cases: auditing, validation, complex business rules

Lesson 8 - Collections and Records

1. Associative arrays, nested tables, VARRAYs

2. Declaring and using collections

3. %ROWTYPE and RECORD data types

4. Using collections with BULK COLLECT and FORALL

Lesson 9 - Dynamic SQL and Advanced Features

1. EXECUTE IMMEDIATE syntax and usage

2. Using DBMS_SQL package

3. Advantages of dynamic SQL

4. Working with large objects (LOBs)

Lesson 10 - Performance Tuning

1. Using bulk processing for performance (BULK COLLECT, FORALL)

2. SQL optimization in PL/SQL

3. Profiling PL/SQL code (DBMS_PROFILER)

4. Avoiding common performance pitfalls

Lesson 11 - Security and Best Practices

1. Wrapping PL/SQL code for security

2. Privileges and roles management

3. Secure coding practices to avoid SQL injection

4. Auditing PL/SQL activities

Lesson 12 - PL/SQL in Applications and Integration

1. Using PL/SQL in Oracle Forms and Reports

2. PL/SQL with Oracle Application Express (APEX)

3. Calling PL/SQL from external applications (Java, .NET)

4. Creating reusable utility packages

Lesson 13 - New Features in Oracle Database 23c

1. Introduction to Oracle Database 23c (Latest Innovations & Release Highlights)

2. New PL/SQL language enhancements in 23c

3. JSON Relational Duality: Handling JSON and relational data seamlessly

4. Native Blockchain Tables for tamper-proof data storage

5. AutoML integration for data-driven decision making within the database

6. Expanded support for Graph and Spatial data types

7. Improved SQL macros and simplified coding patterns

8. Enhanced performance and scalability features

9. Using new security capabilities and compliance improvements

10. Migration considerations from earlier Oracle versions to 23c

Lesson 14 - Capstone Project

1. Design and develop a business application using PL/SQL packages, procedures, triggers, and exception handling

2. Requirements: data validation, auditing, complex business logic, performance optimization

3. Final project presentation and code review

Talk To Us

We are happy to help you

1-800-7430-173 (US Toll Free)

+91 7240740740 (India)

Drop Us a Query

Fields marked * are mandatory

Name

Phone Number

Comments

Request For Live Demo Class

PL SQL Training Fees

Online Class Room Program

US $ 799.00

100% Money Back Guarantee

Duration : 35 Hrs
Plus Self Paced

Classes Starting From

Fast Track Batch 22 Jun 2026
Weekday Batch 22 Jun 2026
Weekend Batch 27 Jun 2026

Corporate Training

Customized Training Delivery Model
Flexible Training Schedule Options
Industry Experienced Trainers
24x7 Support

Trusted By Top Companies Worldwide

Want to know Today's Offer

Oracle PL/SQL Certification Exam

The official certification associated with PL/SQL is Oracle Database PL/SQL Developer Certified Associate.

Exam Format

Exam Name: Oracle Database PL/SQL Developer Certified Associate (Exam Code: 1Z0-149)
Duration: 120 minutes (2 hours)
Number of Questions: 78 multiple-choice
Passing Score: 63%
Type: Scenario-based multiple-choice questions
Mode: Online (proctored) or at a certified Pearson VUE test center

Exam Cost

Typically ranges from $245 to $300 USD, depending on your country and local taxes.

Advanced Certification Exams for Oracle PL/SQL

Oracle Database SQL Certified Associate (Exam 1Z0-071)
Oracle PL/SQL Developer Certified Associate
Oracle Database PL/SQL Developer Certified Professional

Reviews

Login

Email ID*

Password*

Forgot Password?

Oracle PL/SQL Training Online