Contents
About PL/SQL Online Training Course Overview
Procedural Language extension to Structured Query Language is usually pronounced as PL/SQL which is mainly used to combine both database language and procedural programming language. The PL/SQL program units helps us to compile database under Oracle database server. It derives the security, portability and robustness automatically from the Oracle database.
Objectives of the Course
- To write PL/SQL codes for developing packages
- To create and manage database sequence and tables
- To improve database security and its performance
- To know complete concepts of several PL/SQL sections like Execution, Declaration and Exception
Pre-requisites of the Course
- There are no pre-requisites for PL/SQL, however, basic knowledge of SQL will be added advantage
Duration of the Course
- 30 Hrs
Who should do the course:
- IT Developers
- Database Admins
- Those who are interested towards career in PL/SQL
PL/SQL Online Training Course Content
PL-SQL (Procedure Language – SQL)
- Introduction to Programming Languages
- Introduction to PL/SQL
- The Advantages of PL/SQL
- PL/SQL Architecture
- PL/SQL Data types
- Variable and Constants
- Using Built_in Functions
- Conditional and Unconditional Statements
- Simple if, if… else, nested if..else, if..else Ladder
- Selection Case, Simple Case, GOTO Label and EXIT
- Iterations in PL/SQL
- Simple LOOP,WHILE LOOP,FOR LOOP and NESTED LOOPS
- SQL within PL/SQL
- Composite Data types (Complete)
- Cursor Management in PL/SQL
- Implicit Cursors
- Explicit Cursors
- Cursor Attributes
- Cursor with Parameters
- Cursors with LOOPs Nested Cursors
- Cursors with Sub Queries
- Ref. Cursors
- Record and PL/SQL Table Types
Advanced PL/SQL
Procedures in PL/SQL
- STORED PROCEDURES
- PROCEDURE with Parameters (IN, OUT and IN OUT)
- POSITIONAL Notation and NAMED Notation
- Procedure with Cursors
- Dropping a Procedure
- Functions in PL/SQL
- Difference between Procedures and Functions
- User Defined Functions
- Nested Functions
- Using stored function in SQL statements
Packages in PL/SQL
- Creating PACKAGE Specification and PACKAGE Body
- Private and Public Objects in PACKAGE
EXCEPTIONS in PL/SQL
-
Types of exceptions
- User Defined Exceptions
- Pre Defined Exceptions
- RAISE_APPLICATION_ERROR
- PRAGMA_AUTONOMOUS_TRANSACTION
- SQL Error Code Values
Database Triggers in PL/SQL
- Types of Triggers
- Row Level Triggers
- Statement Level Triggers
- DDL Triggers