Oracle PL/SQL Programming

1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5
Please Log in or register to rate

Oracle PL/SQL Programming


The Oracle PL/SQL language is a flexible extension to SQL and is mainly intended to increase productivity, performance, scalability and security.

In this training, you will gain the essential knowledge allowing you to understand how to write PL/SQL programs. You will learn how to create Anonymous Blocks, Stored Procedures and Functions. During the course you’ll also learn how to design modular Packages, and increase the efficiency of automation using Triggers. In this course, each module is reinforced with structured hands-on exercises.


Target Audience:
This course is mainly intended for Database Administrators, Database Developers, Business Intelligence professionals, QA professionals, Data Analysts, and other roles responsible for developing PL/SQL code.

– Basic working knowledge of relational databases
– Basic understanding of the Microsoft Windows operating system
– Familiarity with programming languages
– Familiarity with the SQL language concepts and syntax

Course Topics

Module 1 – PL/SQL Variables:
Declaring variables, executable statements, global variables, substitution variables

Module 2 – PL/SQL Blocks:
Interacting with the Database Engine, using nested blocks

Module 3 – SELECT and DML within PL/SQL Blocks:
SELECT INTO statement, DML with PL/SQL blocks, using Implicit Cursors

Module 4 – Conditions and Loops:
Using IF, CASE, LOOP, WHILE and FOR, exit and continue, nested loops

Module 5 – Composite Data Types:
Using records, %rowtype, Table Of, Table Of Methods – NEXT, PRIOR, FIRST, LAST, Table of Records

Module 6 – Using Cursors:
Single FETCH vs Multiple FETCH, looping through a Cursor, %rowtype, %found, Cursor For Loop, Cursor with Parameters, Bulk Collect

Module 7 – Error Handling:
Predefined exceptions, non predefined exceptions. SQLCODE, SQLERRM, user defined errors

Module 8 – Using Stored Procedures:
Procedures with IN parameter, using OUT parameters, using IN/OUT parameters, nesting procedures

Module 9 – Using Functions:
Using RETURN, error handling

Module 10 – PL/SQL Packages:
Creating Package SPEC, creating package BODY, Overloading – Procedures and Functions, Forward Declaration, Oracle Supplied Packages

Module 11 – PL/SQL Triggers:
BEFORE Triggers, Using OLD/NEW, using AFTER triggers, using INSTEAD OF Triggers, autonomous transactions

Module 12 – Dynamic SQL:
Using PL/SQL Dynamic SQL

Module 13 – Dependencies: 
Handling Database dependencies

Detailed Course Outline

Oracle PL/SQL Programming detailed syllabus

© Copyright - Skilit - Site by Dweb