Workday HCM Demo New Batches Starting from Tuesday... 01-11-2016
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
Oracle PL/SQL videos will be updated soon
To Watch More Videos Click Here

Flash News

AngularJS New Batch Start From 28th OCT & 29th OCT.

Hadoop Dev New Batch Start From 29th OCT & 30th OCT.

IBM COGNOS TM New Batch Start From 30th OCT & 31th OCT.

Informatica Dev New Batch Start From 31th OCT & 01st Nov.

Mean Stack New Batch Start 01st Nov & 02nd Nov.

SAP BODS new Batch Starting From 02nd Nov & 03rd Nov.

SAP S/4 HANA New Batch Start From 03rd Nov & 04th Nov

Tableau New Batch Start From 04th Nov & 05th Nov


Workday HCM Demo Training

Demo Schedule : 09:30P.M EST / 08:30P.M CST / 06:30P.M PST on 31st OCT & 07:00A.M IST on 01st NOV
Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :