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
31/07/2018: Example programmes delivered: Professional Scrum Master PSM I Agile and Scrum These are 2 day courses which focus on understanding the agile/scrum...
10/02/2018: A leading Financial institution commissioned JBI to run a series of Agile/Scrum courses for various teams - inhouse. Pre-course consultation...
12/10/2017: The Graduate Programme provided a gateway into technology within investment banking. Graduates (Computer Science, Engineering, Maths, Physics...
07/11/2018: Containerized applications are becoming very popular and it’s easy to understand why. They provide so many benefits to organisations, especially...
01/11/2018: Having lots of business data is good. But to get the most from it, you have to be able to analyse it and communicate it to other users in your...
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"
Subscribe to our Newsletter – Receive the latest info on Tech courses & insights Subscribe