home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral courses » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » Linux - UNIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » DB2 for z/OS » DB2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Data Science, Big data and analyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
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:

Schedule

datedur.lang.  location  price
22 Nov3?Leuven  (BE)1350 EUR  (excl. VAT) 
18 Dec3NWoerden  (NL)1350 EUR  (exempt from 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

'Stand Alone' versus 'Stored' procedures

Writing SQL in a procedural environment

Explicit declaration • implicit declaration

If-then-else structure

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

Implicit and explicit cursors • attributes • cursor-for loop

Pre-defined exceptions • application exceptions

packages • functions • procedures • triggers

Training method

Classroom instruction with practical exercises.

Duration

3 days.

Course leader

Bart Lemarcq, Kris Van Thillo.

Global score

   
4.2/5 (based on 116 evaluations)

Reviews

     
top.. praktijk gericht (, )
     
een betere kennis van SQL was nuttig geweest (, )
     
PL/SQL gaat m.i. behoorlijk terug in de tijd. (Back to basics) (, )
     
Prima cursus.Zeer heldere uitleg. Adhoc vragen duidelijk beantwoord. Geen moment saai. (, )
     
prima om eerste indruk PLSQL te krijgen. (, )
     
Zeer bruikbare cursus die me zeker van pas zal komen. (, )
     
Tempo viel ondanks de waarschuwingen heel goed mee. Syntax is nieuw, maar conceptueel is een heel deel niet meer zo nieuw. (, )
     
interessant doch heftig (, )
     
prima, zoals verwacht (, )
     
Zeer leerrijk, op een aangename mannier gegeven met goede afwisseling van theorie en oefeningen. (, )

Refresh this page to see other comments.


SESSION INFO AND ENROLMENT