EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE
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.
Creating Procedures, Functions and Packages
Executing & Using Procedures, Functions & Packages
Private & Public Execution
One-time only Procedures
Assigning Default Values and Constants
Defining Records and Tables of Records
Restrictions on Embedded SQL
Manipulating Multiple Records
Defining and using Ref Cursors.
For Update and Where Current of Clauses
Embedded Insert, Update, Delete commands.
Exiting Loops to a Label
Block Labels and Nested Blocks
Basic, FOR, While and Cursor For loops
Nested Loops and Variable Scope
Handling Runtime Errors
System Handled Exceptions
User Defined Exceptions
PRAGMA INIT and Compiler Instructions
How to continue processing after an Exception
See why people choose JBI
10/02/2018: A leading Financial institution commissioned JBI to run a series of Agile/Scrum courses for various teams - inhouse. Pre-course consultation...
10/02/2018: Background The Development Team found itself having legacy modules developed in Ruby script. These modules would rapidly render dynamically changing...
06/02/2018: Originating from Facebook, React is a component based front-end library that allows you to build applications out of a tree of small, testable,...
12/10/2017: The Graduate Programme provided a gateway into technology within investment banking. Graduates (Computer Science, Engineering, Maths, Physics...
27/02/2018: Mariella has put together this short briefing on the bookmarks functionality in Power BI... "I love it!" she says.. Bookmarks has been available...
27/02/2018: Our world is changing; this is hardly anything new. New startups emerge consistently, almost on a daily basis, each claiming to have the latest...
Bring a JBI course to your office
and train a whole team onsite
0800 028 6400 or request quote
Get in touch
0800 028 6400
Excellent feedback, consistently !
"great tips help reduce build times"
"we got access to exclusive content"
"Short course meant less time off"
"what an inspiring trainer !"
"colleagues at 2 sites joined via web"
"I passed my exam the next day"