The Oracle database system is widely used – as a data source for application development. As an application developer in this environment – Java, .Net., Python, ... – you will need to be able to work with SQL and PL/SQL. This training offers you the necessary guidance to do so!

The aim of this course is to

• explain the basic features of PL/SQL: data types, procedural statements, exceptions;
• describe and practice more advanced PL/SQL capabilities: PL/SQL collections (and related statements), advanced exception handling;
• introduce the main Oracle packaged applications and demonstrate their global added value;
• demonstrate the benefits of working with stored procedures, functions, packages and triggers.

• Introduction PL/SQL
  'Stand Alone' versus 'Stored' procedures
• SQL support
  Writing SQL in a procedural environment
• Variables and constants - records, collections
  Explicit declaration • implicit declaration
• Logical comparisons
  If-then-else structure
  case
• Conditional and iterative control
  For-loop • do-while loop • loop-endloop • goto
  continue
• Cursor management
  Implicit and explicit cursors • attributes • cursor-for loop
  collections (nested table, varrays, associative arrays)
  cursor or collection?
• Error treatment
  Pre-defined exceptions • application exceptions
• Procedural objects
  packages • functions • procedures • triggers
• Oracle Supplied Packages

Live instructor-led training, with plenty of opportunities for hands-on exercises and discussion.

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. 
Training can be implemented in English, Dutch, or French.
If interested in organising this training internally, get in touch with us; we can even customise it to meet your specific needs.

Participants are expected to have an understanding of relational database systems and to be able to write basic SQL statements (course SQL and relational databases fundamentals). A basic knowledge of the Oracle database system (see Oracle fundamentals course) is recommended.

This course is intended for application programmers, (APEX) developers and DBAs - basically anyone who will ‘build’ anything in an Oracle environment.