Naresh i Technologies

PL/SQL Online Training

—

by

NIT Manager
in

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

Trigger Auditing