Practical teaching
In addition to class hours, you will practice the topics covered with your instructor and mentor dur
Create account & apply
DATABASE MANAGEMENT · INTERMEDIATE LEVEL
Oracle PL/SQL
Master Oracle PL/SQL programming to automate and enhance database operations. Topics include stored procedures, functions, triggers, and exception handling. This course helps developers optimize database interactions for enterprise applications. Training is delivered by experienced instructors with practical lab work and real-world scenarios.
Intermediate12 weeks48 hoursOn-site
Your selected course will be carried into Ingress Portal.
COURSE HIGHLIGHTS
Mentors
The knowledge and skills you learn at the academy will be further strengthened with the mentor syste
Academic transcript
Assignments and projects are checked by the instructor, and your knowledge and skills are determined
CONDENSED SYLLABUS
See the structure without reading a textbook.
Modules stay collapsed for quick scanning. Open any module to inspect its topics.
01Introduction and Basic Concepts3 lessons+
Advantages of PL SQL
What is PL SQL?
Comparison of PL SQL with SQL
02Blocks and types of blocks4 lessons+
Block Structure
Types of Blocks
Writing Anonymous blocks
PL/SQL Blocks
03PL SQL Variables and scalar data types3 lessons+
Declarations of variables
PL SQL Data types
Declarations of constants
04Writing Control Structure3 lessons+
Case
Conditional selection statements
If
05Loop Statements6 lessons+
For Loop
Basic Loop
Cursor For Loop (Implicit cursor)
Exit and Exit when
While Loop
Continue and Continue when
06Composite Data Types5 lessons+
VARRAY
Collections
Records
Associative Arrays
Nested Table
07Using Explicit Cursors3 lessons+
What is Explicit Cursor?
Cursor Attributes
Difference between implicit and explicit cursor
08Exception Handling2 lessons+
System Defined exceptions
User defined exceptions
09Procedure2 lessons+
What is a procedure?
Procedure parameters
10Functions3 lessons+
Calling methods
What is function?
Creating and using Functions
11Working with Packages3 lessons+
Calling methods
Creating and using Functions
What is function?
12Packages4 lessons+
Package Body
What is Package?
Package Specification
Creating and using packages
13Dynamic SQL4 lessons+
EXECUTE IMMEDIATE Statement
Native Dynamic SQL
When You Need Dynamic SQL
OPEN FOR, FETCH, and CLOSE Statements
14Triggers7 lessons+
Reasons to Use Triggers
DML Triggers
Compound DML Triggers
INSTEAD OF DML Triggers
SCHEMA Triggers
System Triggers
DATABASE Triggers
15Autonomous transaction2 lessons+
Advantages of Autonomous Transactions
Declaring Autonomous Routines
UPCOMING GROUPS
Choose the cohort you can actually attend.
Only current, open groups are shown.
STARTS
To be announced
On-site- Schedule
- To be announced
- Format
- On-site
- Duration
- 12 weeks · 48 hours
- Language
- Confirm with advisor
YOUR INSTRUCTOR TEAM
Specialists matched to the modules they teach.
Course delivery is supported by practitioners across engineering, architecture and production backend development.
Saida Kerimli
PL/SQL DeveloperYelo Bank“The program helped me connect individual skills into the way real teams design, build and deliver software.”
See real graduate stories from the Ingress community.
Explore graduate resultsAPPLICATION THROUGH INGRESS PORTAL
Your course stays selected while you create your account.
We use one Portal account for applications, assessments and future learning progress. You will not need to email your details or select the training again.
Questions first? Talk to an advisor- 01
Create or sign in to your Portal accountYour contact details stay connected to one student profile.
- 02
Confirm your application detailsOracle PL/SQL is preselected.
- 03
Submit your applicationThe admissions team receives it immediately and can follow up from the Portal.
SELECTED TRAININGOracle PL/SQLOn-site
Continue in Ingress Portal Already registered? The Portal will let you sign in instead.