EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE


Oracle PL/SQL Training Course


Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

Oracle PL/SQL training course (code: ORACPLSQL)

Extract And Manipulate Your Corporate Oracle Data With PL/SQL


SEE MORE COURSES IN THIS CATEGORY

TRAINING COURSE OVERVIEW

Our Oracle PL/SQL training course provides a thorough introduction to the preferred server-side programming language for integrating directly with the Oracle database kernel. The JBI PL/SQL Foundation course provides a thorough introduction to PL/SQL language coding for delegates with some prior programming experience. Basic features such as declarations, assignments, IF/THEN/ELSE, looping, Case and many more are covered in detail, and then the course moves on to major language topics such as building functions, procedures, packages and DML-based triggers. A few DBMS built-in packages such as DBMS_OUTPUT and UTL_FILE are introduced.


AUDIENCE

The course is suitable for technical personnel involved in the development and maintenance of Oracle applications and databases



DETAILHIGHLIGHTS

PL/SQL

PLSQL Blocks 
Creating Procedures, Functions and Packages 
Executing & Using Procedures, Functions & Packages 
Private & Public Execution 
One-time only Procedures 
Overloading

Declarations and variable assignment.

Data Types 
Bind variables 
Assigning Default Values and Constants 
Table Arrays 
Defining Records and Tables of Records

SQL*Plus commands in PL/SQL

Embedded SQL 
Restrictions on Embedded SQL

Cursors

Defining Cursors 
Manipulating Multiple Records 
Parameterising Cursors
Defining and using Ref Cursors.

Data Manipulation

For Update and Where Current of Clauses 
Embedded Insert, Update, Delete commands.

Conditional Branches

Labels 
Exiting Loops to a Label 
Block Labels and Nested Blocks

Loops

Basic, FOR, While and Cursor For loops 
Nested Loops and Variable Scope

Exception handling

Handling Runtime Errors 
System Handled Exceptions 
User Defined Exceptions 
PRAGMA INIT and Compiler Instructions 
How to continue processing after an Exception

Debugging Your PL/SQL

  • Produce procedural programs using PL/SQL
  • Perform transactions using PL/SQL.
  • Manipulate data using advanced techniques including nested functions.
Receive the latest version of this course into your inbox


See why people choose JBI

"At jbi even the sales team are technical so you are able to ask questions before the course"

Garima Aon

Call our Tech Team :  0800 028 6400  request info



PUBLIC COURSES (LONDON, UK)
 

30th Oct 2017 - 3 days £995
Book

see all dates


X

Show Discount for this course



PRIVATE COURSES


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400
or request quote


  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote


 

 

 

 

Get in touch
0800 028 6400




 

 

view all case studies

 

 

Our inspiring and up-to-date courses gain exceptional feedback

►"great tips to help reduce build times"
► "we got access to exclusive content"
► "intensive course meant less time off"

►"what an inspiring trainer !"
► "colleagues at 2 sites joined via web"
► "I passed my exam the next day"

Newsletter ! Get exclusive news about upcoming programs, technical insights & special offers