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
| date | dur. | lang. | location | price | |
| 23 Mar | 3 | Woerden | 1425 EUR (exempt from VAT) | ||
| 27 May | 3 | Leuven | 1425 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
Bart Lemarcq, Kris Van Thillo.
Reviews
4.4/5 (based on 36 evaluations; the most recent ones are shown below)
|
Very good curriculum arrangement with challenging exercises.
|
| (N.N., ING - De Entree, ) |
Goed les gegeven, cursus materiaal goed, to the point kernachtig
|
| (N.N., ING - De Entree, ) |
Goede cursus. Afwisseling theorie en oefeningen. Aanpassing aan niveau van beide cursisten.
|
| (Durk, ) |
Cours bien structuré et support bien fait
|
| (Gaëtan, ) |
Super: animateur à l'écoute et au niveau de chacun
|
| (Chantal, ) |
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
|
| (Pierre Devos, ) |
Très bonne; formateur dynamique et explications claires
|
| (Philippe, ) |
très bien
|
| (N.N., ) |
Click here to see more comments...
Le formateur est symphatique, plain d'humour, ce qui favorise l'apprentissage de manière détendue
|
| (N.N., CPH, ) |
Cours bien construit, très clair
|
| (Pierre, ) |
veel stof in korte tijd. maar prima voor eerste indruk en eerste oefeningen. In praktijk (werkplek) wordt wel verder ontwikkeld.
|
| (N.N., ) |
top.. praktijk gericht
|
| (N.N., APG, ) |
Goed, maar oefeningen zijn soms te ingewikkeld, om vast te stellen wat de kern van de oefening is, kom hier niet voor ingewikkelde formules, maar om de basis van het maken van procedures te begrijpen
|
| (N.N., ING - Haarlerbergpark, ) |
Goed en nuttig. Tempo soms erg hoog waardoor weinig tijd om te bezinken
|
| (N.N., ) |
Goede cursus met enthiousiaste cursurleider.
|
| (N.N., ) |
Prima
|
| (Frieda Finaut, Mazda Motor Logistics Europe, ) |
goede inleidende cursus over PLSQL, goede manier overgebracht
|
| (N.N., Saint-Brice / Unigro, ) |
prima, zoals verwacht
|
| (N.N., ) |
een betere kennis van SQL was nuttig geweest
|
| (Romain Deyaert, Saint-Brice / Unigro, ) |
interessant doch heftig
|
| (Arthur Thys, Saint-Brice / Unigro, ) |
Zeer leerrijk, op een aangename mannier gegeven met goede afwisseling van theorie en oefeningen.
|
| (Lieven Dewit, Eandis, ) |
Also interesting
Enrollees for this training also took the following courses:
| SESSION INFO AND ENROLMENT |