Expert in Oracle PL SQL Training Crash Course
Expert in Oracle PL SQL Training Course By Elevate Academy Team DB Management Course World Class Instructor 1:1 with Industry…
- Tesbo Courses
Slash Courses
Classic Courses
Elevate Academy delivers a high-impact Oracle PL/SQL training program designed to help you build deep technical expertise in database programming. This hands-on course equips learners to write, optimize, and manage PL/SQL code effectively, preparing them for success in data-driven roles across industries.
This program is featured in our elite collection of top-rated courses, trusted globally by top companies to train and upskill their IT professionals.
Elevate Academy’s Expert in Oracle PL/SQL course offers a deep dive into one of the most essential languages in database programming. With guidance from industry experts, participants will gain hands-on experience in writing optimized PL/SQL code, managing procedures, and troubleshooting real-world issues. This course prepares learners to become confident PL/SQL developers capable of handling complex database environments.
This training covers all core aspects of Oracle PL/SQL, including programming logic, performance optimization, data manipulation, secure coding, and structured error handling—empowering learners to write effective code and contribute meaningfully to any database development team.
Getting started with PL/SQL
What is Oracle PLSQL?
Why Oracle PLSQL?
What can PLSQL do?
How PLSQL works
Advantages of using PLSQL
Websites that use PLSQL
PL/SQL Software Requirements
Downloading Oracle Database
Install the Oracle Database
Unlock The HR Schema
Download and Configure Oracle SQL Developer Software
HR Schema Create Code
PLSQL Architecture
PLSQL Blocks
Declare Section
Begin Section
Exception Section
End Section
Anonymous Blocks
Named Blocks
PLSQL Engine
Database Server
Data Types
Scalar Data Types
Number Types
Character Types
Boolean
Date/Time
Collection Data Types
VARRAY
Table
Nested Tables
LOB Data Types
BLOB
CLOB
NCLOB
BFILE
Reference Data Types
Cursor
Record
Ref Cursor
Pointer
User-Defined Data Types
Variables
Introduction
Declare Variable
Naming Rules
Initializing Variables
Variable Scope
Local Variable
Global Variable
Variable Attributes
Delimiters and Commenting
Bind Variables
Constants
Introduction
Declare Constant
Literals
IF Statements
Summary
IF THEN
IF THEN ELSE
IF THEN ELSIF
Nested IF Statement
CASE Statements
Simple CASE Statement
Simple CASE Expression
Searched CASE Statement
Searched CASE Expression
Loops
Overview
Loop Types
Simple LOOP
FOR LOOP
FOR LOOP Counter
Continue, Continue When
Nested LOOP
While LOOP
GOTO Statement
CRUD
What is CRUD?
Create Table
Insert Values
Hands on insert values
Read Table
Read Query
Hands on read query
Update Table
Hands on update table
Delete Tables
Hand on delete tables
JOINS
What is joins?
Advantages of JOINS
Types of Joins
INNER JOIN
Hands on INNER JOIN
LEFT JOIN
Hands on LEFT JOIN
RIGHT JOIN
Hands on RIGHT JOIN
CROSS JOIN
Hands on CROSS JOIN
Aggregate Functions
What are aggregate functions?
Purpose of Aggregate functions
count()
Hands on count ()
sum ()
Hands on sum ()
average ()
Hands on average ()
min ()
Hands on min ()
max ()
Hands on max ()
group_concat ()
Hands on group_concat ()
first ()
Hands on first ()
last ()
Hands on last ()
Introduction
What is Cursor
Types of Cursors in PLSQL
Using Cursors with Records
Looping with Cursors
PLSQL Cursors with Parameter
Cursor Attributes
For Update Clause
Where Current of Clause
Reference Cursors
Implicit Cursor
%FOUND
%NOTFOUND
%ROWCOUNT
ISOPEN
Explicit Cursor
Declaring the Cursors
Opening the Cursors
Fetching The Cursors
Closing the Cursors
Associative Array (index-by table)
Indexed by String
Indexed by PLS_INTEGER
Declaring Associative Array Constant
VARRAY (Variable-size Array)
VARRAY (Variable-size Array)
Nested Table
Local Type
Standalone Type
Collection Constructors
Introduction
Initializing Collection Variable To Empty
Executing Collection
Assigning Values to Collection Variables
Data Type Compatibility
Assigning Null values to VARRAY or Nested Table
Assigning Set Operations to Nested Table
Multidimensional Collections
Introduction
Two Dimensional Varray
Nested Tables and Varrays of Integer
Nested Tables and Varrays of String
Collection Comparisons
Varray and Nested Table Variables to NULL
Nested Tables for Equality and Inequality
Nested Tables with SQL Multiset Conditions
Collection Methods
DELETE
TRIM
EXTEND
EXISTS
FIRST and LAST
COUNT
LIMIT
PRIOR and NEXT
Record Variables
Initial Values of Record Variables
Declaring Record Constants
RECORD Types
Declaring Items using %ROWTYPE Attribute
Introduction
What is Dynamic SQL
When you need Dynamic SQL
Native Dynamic SQL
EXECUTE IMMEDIATE Statement
OPEN FOR, FETCH, and CLOSE Statements
Repeated Placeholder Names
DBMS_SQL Package
DBMS_SQL.RETURN_RESULT Procedure
DBMS_SQL.GET_NEXT_RESULT Procedure
DBMS_SQL.TO_REFCURSOR Function
DBMS_SQL.TO_CURSOR_NUMBER Function
Introduction
Nested, Package and Standalone Subprograms
Invocations
Properties
Subprogram Parts
Forward Declaration
Subprogram Parameters
Subprogram Invocations Resolution
Overloaded Subprograms
Recursive Subprograms
Function Result Cache
SQL Statement can Invoke
What are Functions & Procedures
Why we Use?
Creating and using Stored Procedure
USING IN & OUT Parameter
Named & Mixed Notations
Creating and Using Functions
Local Sub Programs
Overloading the subprograms
Handling Exceptions in Sub programs
Finding & Removing the Sub programs
Regular & Pipelined Table Functions
What is Package?
Why we use Packages
Package Specification
Appropriate Public Items
Creating Package Specifications
Package Body
Package Instantiation and Initialization
Package State
SERIALLY_REUSEABLE Packages
Compile-Time Warnings
DBMS_WARNING Package
Overview of Exception Handling
Exception Categories
Advantages of Exception Handlers
Guidelines for Avoiding and Handling Exceptions
Internally Defined Exceptions
Predefined Exceptions
User-Defined Exceptions
Redeclared Predefined Exceptions
Raising Exceptions Explicitly
RAISE Statement
User Defined Exception with RAISE Statement
Initially Defined Exception with RAISE Statement
Current Exception with RAISE Statement
RAISE_APPLICATION_ERROR Procedure
Exception Propagation
Propagation of Exceptions Raised in Declarations
Exception Handlers
Unhandled Exceptions
Retrieving Error Code and Error Message
Continuing Exception after Handling Exceptions
Retrying Transactions after Handling Exceptions
Handling Errors in Distributed Queries
Overview Transactions and Isolation Levels
READ UNCOMMITTED
READ COMMITTED
REPEATABLE READ
SERIALIZABLE
Committing and Rolling back Transactions
COMMIT
ROLLBACK
Savepoints
SAVEPOINT
ROLLBACK TO
Explicit Locking
LOCK TABLE
Overview of Triggers
Reasons to Use Triggers
DML Triggers
Detecting Triggering DML Statement
INSTEAD of DML Triggers
Compound DML Triggers
Triggers for Ensuring Referential Integrity
System Triggers
SCHEMA Triggers
Database Triggers
INSTEAD OF CREATE Triggers
Subprograms Invoked by Triggers
Trigger Compilation, Invalidation and Recompilation
Exception Handling in Triggers
Trigger Restrictions
Trigger Size Restriction
Trigger LONG and LONG RAW Data Type Restrictions
Mutating-Table Restriction
Trigger Enabling and Disabling
Trigger Changing and Debugging
Data Transfer Utilities
Triggers for Publishing Events
Develop strong PL/SQL programming skills to write efficient, scalable code. Learn how to streamline and automate complex database operations with confidence.
Gain expertise in crafting intricate SQL and PL/SQL blocks. Work with nested queries, joins, and subqueries to extract and manipulate data effectively.
Apply best practices to enhance PL/SQL performance. Learn how to use indexing, caching, and tuning strategies to optimize query execution.
Become proficient in handling and debugging PL/SQL errors. Learn practical techniques to diagnose and fix common coding issues quickly.
Design and implement modular, reusable code with stored procedures and functions. Enhance maintainability and efficiency across database systems.
Ensure your PL/SQL code is secure and compliant. Apply proven strategies for protecting sensitive data and following security best practices.
June 13, 2025In today’s fast-paced digital world, the demand for skilled software professionals is higher than ever. Whether you’re a student aiming…
Expert in Oracle PL SQL Training Course By Elevate Academy Team DB Management Course World Class Instructor 1:1 with Industry…
Master in Oracle DBA Training Crash Course By Elevate Academy Team DB Management Course World Class Instructor 1:1 with Industry…
Core MSSQL Training Crash Course By Elevate Academy Team DB Management Course World Class Instructor 1:1 with Industry Expert 400+…
Refer your friends or colleagues to Elevate and earn gift vouchers worth up to ₹1000 for each successful enrollment.
Help others upskill while you enjoy exclusive rewards—it’s a win-win!
