PLsql Course Overview

PL/SQL is a procedural extension of SQL, which makes it extremely straightforward to write numerical code which includes SQL as if it had been one language. In contrast, many other programming languages require mapping information types, preparing announcements and processing result collections, all of which require understanding of specific APIs.

The information types in PL/SQL really are a super-set of these from the database, so that you rarely will need to perform data type conversions if utilizing PL/SQL. Consult your typical Java or even .NET programmer how exactly they locate managing date values coming out of a database. They could only wish for the ease of PL/SQL.

In contrast, building all of the business logic because PL/SQL from the database signifies customer code needs just a single database call per transaction, reducing the system overhead significantly.


Course Objectives

Benefits of PL/SQL:

  • Block Structures: PL/SQL is made up of blocks of code, that may be nested inside each other. Every block forms a component of a job or even a logical module. PL/SQL Blocks can be kept in the database and then compacted.
  • Greater Performance: PL/SQL engine procedures multiple SQL statements concurrently as one block, thus reducing network traffic.
  • Exception Handling: PL/SQL manages exceptions (or mistakes) effectively throughout the implementation of an PL/SQL program. After an exception has been caught, specific actions may be taken depending on the type of the exclusion or it may be shown to the consumer using a message.


  • Introduction to PL/SQL
  • Blocks in PL/SQL
  • PL SQL First Program: Hello World
  • PL/SQL Data Types
  • Complex Data Types in PL/SQL
  • PL/SQL Decision Making Statements
  • Loops in PL/SQL
  • Subprograms: Procedures and Functions in PL/SQL
  • Exception Handling in PL/SQL
  • SQL in PL/SQL
  • Packages in PL/SQL
  • Triggers in PL/SQL
  • Object Types in PL/SQL
  • Dynamic SQL in PL/SQL
  • Nested Blocks in Pl/Sql
  • PL/SQL Identifiers