PL/SQL database programming

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 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 and triggers.

Schedule a training?

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.

REQUEST IN-COMPANY TRAINING

 

Public training calendar

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.

Intended for

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

Background

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 verify whether you have sufficient prior knowledge by completing the online self-test 'Oracle basics'.

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.

Certificate

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

Duration

3 days.

Course leader

Kris Van Thillo (ABIS), Gert Vanstapel (ABIS)

Reviews

The session was really good and nicely presented and explained.

 
  (, )

Great presentation and exercises

 
  (, )

Cursus heeft mij erg geholpen om mijn kennis te vergroten en op te frissen. De docent heeft zaken duidelijk en geduldig uitgelegd.

 
  (, )

Volledige opleiding, met niet alleen aandacht voor de theorie, maar ook voor best practices. Veel oefenmogelijkheden.

 
  (, )

SESSION INFO AND ENROLMENT