Disable Preloader

The course covers the lengths and breaths of database admin and management. Learn how to operate the stored data and infer meaningful results. Leverage instructor-led online learning and grow your knowledge on the move! PL/SQL is a procedural language that overcomes the shortcomings faced by Structured Query Language. It is an extension of SQL and we can even use SQL queries without any hassle in any PL/SQL application or program. In this PL/SQL tutorial, we will go through the basic concepts of PL/SQL in detail.

Module List

  • Introduction
  • Introduction to PL/SQL
  • Declare PL/SQL Identifiers
  • Write Executable Statements
  • Interaction with the Oracle Server
  • Control Structures
  • Deploying Packages
  • Triggers
  • Composite Data Types
  • Explicit Cursors
  • Exception Handling
  • Stored Procedures
  • Stored Functions and Debugging Subprograms
  • Packages
  • Manage Dependencies

PL SQL Course Details

  • 1.1 Overview of PL/SQL
  • 1.2 Identify the benefits of PL/SQL Subprograms
  • 1.3 Overview of the types of PL/SQL blocks
  • 1.4 Create a Simple Anonymous Block

  • 2.1 List the different Types of Identifiers in a PL/SQL subprogram
  • 2.1.1 Usage of the Declarative Section to Define Identifiers
  • 2.1.2 Use variables to store data
  • 2.1.3 Identify Scalar Data Types
  • 2.2 The %TYPE Attribute
  • 2.2.1 What are Bind Variables?
  • 2.2.2 Sequences in PL/SQL Expressions

  • 2.1 Describe Basic PL/SQL Block Syntax Guidelines
  • 2.1.1 Learn to Comment the Code
  • 2.1.2 Deployment of SQL Functions in PL/SQL
  • 2.1.3 How to convert Data Types?
  • 2.2 Describe Nested Blocks
  • 2.2.1 Identify the Operators in PL/SQL

  • Invoke SELECT Statements in PL/SQL
  • Retrieve Data in PL/SQL
  • SQL Cursor concept
  • Avoid Errors by using Naming Conventions when using Retrieval and DML Statements
  • Data Manipulation in the Server using PL/SQL
  • Understand the SQL Cursor concept
  • Use SQL Cursor Attributes to Obtain Feedback on DML
  • Save and Discard Transactions

  • Conditional processing using IF Statements
  • Conditional processing using CASE Statements
  • Describe simple Loop Statement
  • Describe While Loop Statement
  • Describe For Loop Statement
  • Understand the SQL Cursor concept
  • Use SQL Cursor Attributes to Obtain Feedback on DML
  • Use the Continue Statement

Training Advantages
35 contact hours
Industry Case Studies
Industry case studies
Real time training


PL/SQL is Oracle's procedural language extension to SQL. PL/SQL allows you to mix SQL statements with procedural constructs.

Top-notch professionals in that field who understands how to convey things in technical as well as subject matter experts.

It increases quality and reduces development time due to re-use of previous work, real mapping to the problem domain and modular architecture

You can reach us through +302-440-1478. Or you can share your queries through info@etraitsolution.com. Estimated turnaround time will be 24 hours for emails.