The training is designed to cover the basic concept of writing PL/SQL Code to write professional PL/SQL code for complex business problems. The course also talks about writing optimized PL/SQL Code. The course is going to cover many real-t…
4.8 · Rated by learners Certificate of completion
Duration
25 Hours
Mode
Live + Recorded
Level
Beginner → Pro
Language
English / Hindi
AI practice, included with this course
Rehearse the interview and test yourself before the real thing.
Available in your student dashboard as soon as you enrol —
no extra charge, nothing to install.
Course overview
About the Oracle Fundamentals and PL SQL for beginners program.
The training is designed to cover the basic concept of writing PL/SQL Code to write professional PL/SQL code for complex business problems. The course also talks about writing optimized PL/SQL Code. The course is going to cover many real-time case studies in various scenarios. Implementing the PL/SQL code for business rules, Data Quality Checks, working in Enterprise Data Warehousing and data transformation rules.
Why learn with BISP
Trusted by professionals across 30+ countries.
Industry trainers
Certified consultants with 12+ years of real project experience.
Hands-on practice
Real-time scenarios & live project modules, not just slides.
Placement support
Resume building, mock interviews & job referrals.
Certification
BISP certificate + full guidance for official exams.
Course curriculum
Designed by real-time industry professionals around current job roles.
02Working with a different type of Datatypes6 topics
Date, Time and Interval Types
Boolean Types
Characters, String and National Character Types
Number Types
LOB Types
Composite data types
03Exception Handler6 topics
What is Exception Handling
How to Handle Exception
Structure of Exception Handling
Types of Exception Handling
SAVE Exception in Bulk Collect
PRAGMA init Exception
04Cursors in PL/SQL10 topics
Why cursor is used
Declaring Cursors
Different Types of a cursor
Cursor Attributes
Sending parameter to a cursor
Different ways of using the cursor
Cursor Variable (Reference Cursor)
Advantage of using cursor variable over a normal cursor
Passing Cursor variable as the parameter
Restriction on Cursor Variables
05Working with Procedures, Functions, and Packages12 topics
Basic of stored procedure
Basics of functions
Basics of packages
Advantage of using procedures, function, and packages
Passing cursor variables to procedures, function, and packages
Recompiling functions and stored procedures
Forward declaration
Declaring and using persistent global variables in packages
Creating table Function
Function overloading
Restrict Reference Pragma
Pinning packages in the SGA with dbms_shared_pool.keep
06Overview of some advanced PL/SQL topics4 topics
Table Function
Pipelined table function
Error log tables
Hints in PL/SQL
07Writing PL/SQL blocks using tools4 topics
PL/SQL Developers
Toad
SQL Plus
SQL Developers etc.
08Control Structures4 topics
IF-THEN-ELSE Statement
Case Statement
GOTO Statement
NULL Statement
09Working with Objects & Collection8 topics
Describing Object
Constructor method on objects
Nested Table
VARRAY
Associative Array
Collection Methods
Manipulate Collection
Distinguish between the different types of collections and when to use them
10Dynamic SQL and PL/SQL6 topics
When to use
Declaring dynamic SQL and PL/SQL by using DBMS_SQL package
Declaring dynamic SQL and PL/SQL by using Execute Immediate
Using Dynamic SQL in the FORALL statement
A dynamic statement using binding variables
Advantage of using Dynamic SQL and PL/SQL
11Debugging and Error tracking of PL/SQL code3 topics
Using Error log message tables
Using some built-in packages
Using tools like PL/SQL developers
12Language Fundamentals8 topics
identifiers
literals
Executable and Non Executable statement
Anonymous Block Structure
Nested Block
Named Block
PRAGMA
Scope & Visibility of variables
13Different types of loops6 topics
Simple Loop
WHILE- Loop
FOR- Loop
Labels in Loop
Scope Rules
Exit Statement
14Working with Records4 topics
Declaring Records
The benefit of using the record
Passing Values To and From Record
Comparing two records
15Bulk processing of data using Bulk Collect6 topics
What is Bulk collect operation
How does it impact performance
Declaring BULK COLLECT operation with simple select statement
BULK COLLECT with cursors
BULK COLLECT using FORALL statement
Catching exception in Bulk collect using SAVE EXCEPTION
16Working with Triggers.8 topics
Describe Triggers
Identify the Trigger Event Types and Body
Business Application Scenarios for Implementing Triggers
Create DML Triggers using the CREATE TRIGGER Statement
Identify the Trigger Event Types, Body, and Firing (Timing)
Differences between Statement Level Triggers and Row Level Triggers
Create Instead of and Disabled Triggers
How to Manage, Test and Remove Triggers?
Course details
Who it is for, what you need, and how it is delivered.
Who should learn Oracle Fundamentals and PL SQL for beginners?
Fresh Graduates
Prerequisites
Both SQL and PL/SQL is easy to learn, However having some basic idea about RDBMS and basic idea about some programming language will be an advantage.
Delivery methodology
We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.
Class delivery
Live Interactive classes with expert
Certificate of completion
Earn an industry-recognised BISP Trainings certificate when you finish the course.
Yes. You may attend a demo class before enrollment for training quality evaluation, and interact one-to-one with the trainer for any specific requirement.
Can you schedule training as per my availability?
Yes. We discuss it with the trainer and schedule the training at a convenient time for you.
What if I miss a class?
You get the recorded session. You may also retake the whole training multiple times within a 6-month period with the same trainer.
Is there live project training?
Yes. The curriculum includes real-time scenarios and live project modules, with the trainer explaining every topic end-to-end.
How can I pay for the course?
Enroll securely via the payment gateway on this page using card, UPI or net-banking. EMI options are available.
More queries?
Call us at +91 769-409-5404 & +1 678-701-4914, or write to support@bisptrainings.com.
Call Us: +91 769-409-5404
