home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » 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 » 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

Objectives

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.

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
 

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).

Training method

Classroom instruction with practical exercises.

Course leader

Bart Lemarcq, Kris Van Thillo.

Duration

3 days.

Schedule

You can enrol by clicking on a date
datedur.lang.  location  price
22 Nov3?Leuven  (BE)1350 EUR  (excl. VAT) 
18 Dec3NWoerden  (NL)1350 EUR  (exempt from VAT) 

Global score

   
4.2/5 (based on 111 evaluations)

Reviews

     
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 (, )
     
Prima (, )
     
een betere kennis van SQL was nuttig geweest (, )
     
goede inleidende cursus over PLSQL, goede manier overgebracht (, )
     
zeer goed en compleet (, )
     
prima om eerste indruk PLSQL te krijgen. (, )
     
PL/SQL gaat m.i. behoorlijk terug in de tijd. (Back to basics) (, )
     
Prima cursus (, )
     
Uiteraard was de cursus iets te kort en ging het wat snel maar het leek me voldoende voor wat we nodig hebben. (, )
     
Goede cursus met enthiousiaste cursurleider. (, )

Refresh this page to see other comments.