PL/SQL database programming

During the development and/or control of programs for database processing, application programmers, developers and DBAs need more than the basic relational possibilities of Oracle SQL.

Therefore the objectives of this course are:

  • to describe and exercise the procedural characteristics that are added by PL/SQL to SQL;
  • to know the advantages of using stored procedures, functions and triggers.

Schedule

datedur.lang.locationprice 
28 Jan3NLeuven 1710 EUR (excl. VAT)
28 Jan3Nweb based 1710 EUR (excl. VAT)
05 May3web based 1710 EUR (excl. VAT)
05 May3Leuven 1710 EUR (excl. VAT)
SESSION INFO AND ENROLMENT

Intended for

This course is designed for application programmers, developers and DBAs.

Background

Knowledge of Oracle relational database systems, SQL and the concepts behind procedural languages (see 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

  • Conditional and iterative control:

For-loop • do-while loop • loop-endloop • goto

  • Cursor management:

Implicit and explicit cursors • attributes • cursor-for loop

  • Error treatment:

Pre-defined exceptions • application exceptions

  • Procedural objects:

packages • functions • procedures • triggers

  • Oracle Supplied Packages

Training method

Classroom instruction with practical exercises.

Duration

3 days.

Course leader

Kris Van Thillo.

Reviews

The session was really good and nicely presented and explained.

 
  (, )

Great presentation and exercises

 
  (, )

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

 
  (, )

Also interesting

Enrollees for this training also took the following courses:


SESSION INFO AND ENROLMENT