PL/SQL database programming (EN/NL/FR)

This 3-day ABIS course explains the Oracle programming language PL/SQL and provides extensive practical practice. Extremely useful for anyone who will be working with Oracle as a database application and/or APEX developer (and administrator)! Classroom training, implemented interactively. Prior knowledge of SQL is required; insight into Oracle database structures is desirable.

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.

Intended for

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

Backgroud

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.

You can test for yourself to see if you have enough background by filling out the on-line self-test 'SQL and relational databases fundamentals' and the on-line self-test 'Oracle fundamentals course'.

Main topics

• 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

Training method

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.

Certificate

At the end of the session, the participant receives a 'Certificate of Completion'.

Duration
3 days.