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
12 Nov3?Leuven  (BE)1350 EUR  (excl. VAT) 
03 Dec3?Woerden  (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 130 evaluations)

Reviews

     
Excellent professeur (capacité technique, linquistique,...) Il sort souvent du cours pour nous apliquer ce dont nous ne comprenons pas. Toutes les questons trouvent une réponse adaptée (, )
     
top.. praktijk gericht (, )
     
Goed en nuttig. Tempo soms erg hoog waardoor weinig tijd om te bezinken (, )
     
goede inleidende cursus over PLSQL, goede manier overgebracht (, )
     
een betere kennis van SQL was nuttig geweest (, )
     
super (, )
     
prima om eerste indruk PLSQL te krijgen. (, )
     
Prima Cursus. Onderwerp Array's was moeilijk. (, )
     
Zeer bruikbare cursus die me zeker van pas zal komen. (, )
     
Uiteraard was de cursus iets te kort en ging het wat snel maar het leek me voldoende voor wat we nodig hebben. (, )

Refresh this page to see other comments.

Also interesting

Enrollees for this training also took the following courses:


SESSION INFO AND ENROLMENT