Note: This is base content and may
change based on requirements
PL/SQL course contents
Basics of PL/SQL
Ø PL/SQL
architecture
Ø PL/SQL and
SQL*Plus
Ø PL/SQL Basics,
Variables, Constants, data types & error handling
Ø PL/SQL wrapper
utility
PL/SQL structures
Ø Simple blocks
Ø Control
structures
Ø PL/SQL records
Ø Recognizing the
Basic PL/SQL Block and Its Sections
Ø Describing the
Significance of Variables in PL/SQL
Ø Distinguishing
Between PL/SQL and Non-PL/SQL Variables
Ø Declaring
Variables and Constants
Ø Executing a
PL/SQL Block
Error checking – exception handling
Ø Defining
exceptions
Ø Using the when
others clause
Ø Ensuring complete
error checking
Ø Passing error
messages to calling routine
Boolean logic in PL/SQL
Ø Identifying the
Uses and Types of Control Structures
Ø Constructing an
IF Statement
Ø Constructing and
Identifying Different Loop Statements
Ø Controlling Block
Flow Using Nested Loops and Labels
Ø Using Logic
Tables
Ø If-then-else
structure
Ø Testing for
numbers characters and Booleans
Cursors in PL/SQL
Ø Cursor basics
Ø Using a cursor for
a multi-row SQL query
Alteration in PL/SQL
Ø For loop
Ø While loop
PL/SQL
tables
Ø Defining PL/SQL tables
Ø Reasons to use PL/SQL tables
Ø Populating a PL/SQL table
Ø Retrieving from a PL/SQL
table
Dynamic SQL in PL/SQL
Ø Introduction to the dbms_sql
package
Ø Creating a dynamic SQL
statement
Nested blocks in PL/SQL
- Creating nested blocks
- Understanding scope in
nested blocks
Triggers in PL/SQL
Ø Triggers and database events
Ø Defining a trigger
Ø Timing a trigger
Ø Enabling and disabling a
trigger
Stored procedures, functions and packages
Ø Basics of stored procedures
Ø Basics of functions
Ø Basics of packages
Ø Defining stored procedures
& functions
Ø Function and stored
procedures prototypes
Ø Passing arguments to
functions and stored procedures
Ø Recompiling functions and
stored procedures
Ø Pinning packages in the SGA
with dbms_shared_pool.keep
Ø Package forward declaration
Ø Package dependency
Ø Package overloading
Ø Listing package information
Bulking in PL/SQL
Ø Bulk queries
Ø Bulk DML (forall statement)
Ø Using cursor attributes
Ø Analyzing impact of bulk
operations
The course is yet to be scheduled