Mail :
India : +91-8143-111-555
USA : +1-703-445-4802
uk : +44-20-3287-2021
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog Blog

Workday HCM Demo New Batches Starting from Friday... 30-3-2018
Search Course Here

Live Chat
Oracle PL/SQL  Online Training

Oracle PL/SQL


The PL/SQL programming training is an intense course that is designed to give the student hands-on exposure to Oracle PL/SQL. The student learns by coding, and this class has dozens of in-class exercises and the student will be guided from very simple PL/SQL programs to increasingly complex PL/SQL coding techniques.
  • Attendees must be familiar with Web-based applications and have basic Microsoft Windows navigation skills and basic file-management skills.
  • It is a 20 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

  • It is a 5 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Introduction to PL/SQL
    • Understanding the benefits and structure of PL/SQL
    • Examining PL/SQL Blocks
    • Generating output messages in PL/SQL
  • Declaring PL/SQL Variables
    • Identify valid and invalid identifiers
    • Declare and initialize variables
    • List and describe various data types
    • Identify the benefits of using the %TYPE attribute
    • Declare, use, and print bind variables
  • Writing Executable Statements
    • List Lexical Units in a PL/SQL Block
    • Use SQL Functions in PL/SQL
    • Use Data Type Conversion
    • Use Nested Blocks as Statements
    • Reference an Identifier Value in a Nested Block
    • Qualify an Identifier with a Label
    • Use Operators in PL/SQL
    • Using Sequences in PL/SQL Expressions
  • Using SQL Statements within a PL/SQL Block
    • Identify and use the SQL Statements in PL/SQL
    • Retrieve Data in PL/SQL with the SELECT statement
    • Avoid Errors by Using Naming Conventions When Using Retrieval and DML Statements
    • Manipulate Data in the Server Using PL/SQL
    • The SQL Cursor concept
    • Use SQL Cursor Attributes to Obtain Feedback on DML
    • Save and Discard Transactions
  • Writing Control Structures
    • Control PL/SQL Flow of Execution
    • Conditional processing Using IF and CASE Statements
    • Handle Nulls to Avoid Common Mistakes
    • Build Boolean Conditions with Logical Operators
    • Use Iterative Control with Looping Statements
  • Working with Composite Data Types
    • Learn the Composite Data Types of PL/SQL Records and Tables
    • Use PL/SQL Records to Hold Multiple Values of Different Type
    • Inserting and Updating with PL/SQL Records
    • Use INDEX BY Tables to Hold Multiple Values of the Same Data Type
  • Using Explicit Cursors
    • Define Cursors
    • Explain Explicit Cursor Operations
    • Controlling Explicit Cursors
    • Use Explicit Cursors to Process Rows
    • Cursors and Records
    • Cursor FOR Loops Using Subqueries
    • Explicit Cursor Attributes
    • The %NOTFOUND and %ROWCOUNT Attributes
  • Handling Exceptions
    • Define Exception
    • Handling Exceptions with PL/SQL
    • Predefined Exceptions
    • Trapping Predefined and Non-predefined Oracle Server Errors
    • Functions that Return Information on Encountered Exceptions
    • Trapping User-Defined Exceptions
    • Propagate Exceptions
    • Basic RAISE Statement
  • Creating Stored Procedures and Functions
    • Overview of Stored Procedures and Functions
    • Differentiate between anonymous blocks and subprograms
    • Understand the Header Area of a Stored Procedure and Function
    • Create Simple Procedures and Functions
    • Create a Simple Procedure with an IN Parameter
    • Execute a Procedure and a Function


IST Time/Date EST Time/Date CST Time/Date PST Time/Date
10AM / 17-12-2016 08PM / 16-12-2016 07PM / 16-12-2016 06PM / 16-12-2016
Oracle PL/SQL videos will be updated soon
To Watch More Videos Click Here

Flash News

AngularJS New Batch Starting From 8th April & 9th April.

Hadoop Dev New Batch Starting From 8th April & 9th April.

IBM COGNOS TM New Batch Starting From 8th April & 9th April.

Informatica Dev New Batch Starting From 8th April & 9th April.

Mean Stack New Batch Starting From 8th April & 9th April.

SAP BODS new Batch Starting From 8th April & 9th April.

SAP S/4 HANA New Batch Starting From 8th April & 9th April.

Tableau New Batch Starting From 8th April & 9th April.


(1) Workday Technical Demo Training

Demo Schedule : 09:30 P.M EST / 08:30 P.M CST / 6:30 P.M PST on 13th April & 07:00 A.M IST on 14th April

Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :