Master programming syntax, solve interactive challenges & run live code in Syntaxis Explore Arena →
Programming Languages / Beginner

PL/SQL Tutorial

A focused PL/SQL curriculum covering syntax, core language or platform semantics, data/control flow, tooling, and advanced features through atomic topic-specific lessons.

80 lessons~13.3 hoursvOracle PL/SQL workspace_premium Certificate available
YOUR PROGRESS
0%

Course curriculum

MODULE 01
Blocks & Variables
10 lessons
1Anonymous block
10 min
2DECLARE section
10 min
3Variable assignment
10 min
4Constants
10 min
5Anchored %TYPE
10 min
6Anchored %ROWTYPE
10 min
7Nested blocks
10 min
8Labels
10 min
9NULL statement
10 min
10DBMS_OUTPUT
10 min
MODULE 02
Control Flow
10 lessons
1IF THEN
10 min
2IF ELSIF ELSE
10 min
3Simple CASE
10 min
4Searched CASE
10 min
5Basic LOOP
10 min
6WHILE LOOP
10 min
7Numeric FOR LOOP
10 min
8REVERSE FOR LOOP
10 min
9EXIT WHEN
10 min
10CONTINUE WHEN
10 min
MODULE 03
SQL in PL/SQL
10 lessons
1SELECT INTO
10 min
2DML and SQL%ROWCOUNT
10 min
3RETURNING INTO
10 min
4Implicit cursor attributes
10 min
5Cursor declaration
10 min
6Cursor FOR LOOP
10 min
7Parameterized cursor
10 min
8Cursor records
10 min
9FOR UPDATE cursor
10 min
10WHERE CURRENT OF
10 min
MODULE 04
Exceptions
10 lessons
1Predefined exception
10 min
2User-defined exception
10 min
3RAISE
10 min
4RAISE_APPLICATION_ERROR
10 min
5WHEN OTHERS
10 min
6SQLCODE and SQLERRM
10 min
7Exception propagation
10 min
8PRAGMA EXCEPTION_INIT
10 min
9Nested exception handler
10 min
10Reraising exception
10 min
MODULE 05
Procedures & Functions
10 lessons
1CREATE PROCEDURE
10 min
2IN parameter
10 min
3OUT parameter
10 min
4IN OUT parameter
10 min
5CREATE FUNCTION
10 min
6RETURN statement
10 min
7Default parameters
10 min
8Named notation
10 min
9Local subprogram
10 min
10Overloading
10 min
MODULE 06
Packages
10 lessons
1Package specification
10 min
2Package body
10 min
3Public procedure
10 min
4Private procedure
10 min
5Package variable
10 min
6Package initialization
10 min
7Package constant
10 min
8Package cursor
10 min
9Package overloading
10 min
10Forward declaration
10 min
MODULE 07
Collections & Records
10 lessons
1RECORD type
10 min
2Associative array
10 min
3Nested table
10 min
4VARRAY
10 min
5FIRST and LAST
10 min
6NEXT and PRIOR
10 min
7COUNT collection
10 min
8EXTEND
10 min
9DELETE collection element
10 min
10BULK COLLECT
10 min
MODULE 08
Advanced PL/SQL
10 lessons
1FORALL
10 min
2Dynamic SQL EXECUTE IMMEDIATE
10 min
3Dynamic SQL USING
10 min
4REF CURSOR
10 min
5Pipelined function
10 min
6Deterministic function
10 min
7Autonomous transaction
10 min
8Compound trigger
10 min
9Invoker rights AUTHID
10 min
10Native compilation hint
10 min
Certificate Included

PL/SQL Certificate

Earn this credential in either of two ways: complete 100% of the course, or take the master exam directly and score 85% or higher. You do not need to finish the course before attempting the exam.

Course completion path
Finish every published lesson → completion certificate is issued automatically.
Mastery exam path
15 MCQs · 100 marks · 30 minutes · 85% pass · 4 attempts.
Fresh questions each attemptNo backtrackingPublic verificationAdd to LinkedIn
Sign in to earn certificate