020 3397 3290

Selenium  Java Basics
Latest Course

Training

Software Testing Courses

http://www.kpsglobal.co.uk/sap-sales-distribution-sd.html
Phone: 020 3397 3290 , Email: info@kpsglobal.co.uk

Oracle PL/SQL

Duration

4-6 WEEKENDS

Mode of Training

Class room

Make a deposit (£ 50)



Content and Learning
PL/SQL Fundamentals
  • What is PL/SQL?
  • Basic Elements
  • Variables and Constants
  • Data Types
  • Initialising Variables and Assigning Values
  • Using SQL Statements in Code
  • Generating Output to SQL or SQL Developer
Program Logic
  • IF THEN ELSIF ELSE Statements
  • CASE Statements
  • The Basic Loop Construct
  • WHILE and FOR Loops
  • Nested and Labeled Loops
  • The GOTO Statement
  • The CONTINUE Statement
Using Cursors
  • What is a Cursor?
  • Implicit and Explicit Cursors
  • Cursor Operations
  • Declaring, Opening and Closing Cursors
  • Fetching Rows
  • Status Checking
  • Using Cursors FOR UPDATE
  • The Cursor FOR Loop
  • Parameterised Cursors
Exceptions and Nested Blocks
  • The EXCEPTION Section
  • Types of Exception
  • Handling Named System-Raised Exceptions
  • Handling Un-named System-Raised Exceptions
  • User-Declared Exceptions and Application Errors
  • WHEN OTHERS THEN NULL
  • Nested and Labelled Blocks
  • Propagation of Exceptions
  • Scope of Variables and Cursors
  • Scope of Goto Statements
PL/SQL Records and Index-By Tables
  • Declaring Record Types
  • Handling PL/SQL Records
  • Nested Records
  • Declaring PL/SQL Index-By Tables or Associative Arrays
  • PL/SQL Table Built-in Functions
  • Manipulating PL/SQL Tables or Associative Arrays