About ABIS
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 
SQL advanced course

Applications are becoming more demanding than before in their use of relational database systems like Db2, Oracle, SQL Server, PostgreSQL, ... Also the SQL used by data warehouse BI tools (e.g. Business Objects) and ERP solutions (e.g. SAP, Siebel) is becoming more advanced.

Questions that arise in this context are:

Do you accept the challenge? By using very concrete SQL examples and exercises, we show that the possibilities and the impact of the extended SQL tool set may have an important positive impact.


datedur.lang.  location  price
06 Mar1ELeuven  (BE)500 EUR  (excl. VAT) 
11 Jun1NWoerden  (NL)500 EUR  (exempt from VAT) 

Intended for

This presentation is intended for users and developers of RDBMS systems like e.g. Oracle, Db2, SQL Server, MySQL, MariaDB, PostgreSQL, ...


A good knowledge of SQL is required (see SQL workshop) and also active experience with one of the major RDBMS systems (see e.g. Db2 for LUW fundamentals course, Db2 for z/OS fundamentals course, Oracle fundamentals course). You can test for yourself to see if you have enough background by printing and filling out the self-test (PDF file - 56 KB).

Main topics

Training method

Using several examples and giving lots of exercises, you will be guided step by step through this material.


1 day.

Course leader

Peter Vanroose, Arnout Veugelen.

Global score

4.0/5 (based on 205 evaluations)


Goede verhouding theorie/praktijk. Veel nuttige info gezien de korte tijd. 2 dagen lijkt mij wel aanbevolen om bij alles meer te kunnen stil staan zodat het beter in de vingers zit. (, )
goed, te weinig tijd (, )
Goed om zo veel zaken in zo'n korte tijd te herhalen/leren kennen (, )
Prima, zet de laatste puntjes op de I. (, )
Zeer boeiende materie. Docent heeft zeer uitgebreide en diepgaande kennis over verschillende DB's. Enkel jammer dat er relatief lang werd stilgestaan bij CTE, en minder lang bij de onderwerpen in de namiddag. (, )
Zeer positief (, )
behoorlijk pittig. Ook omdat de leraar veel en snel praat. (, )
Goed maar veel te kort (, )
Veel nieuwe inzichten gekregen die in praktijk niet waren opgepikt (CTE, null pitfalls, ranking function, cube) (, )
goed, maar de documentatie is summier (alleen slides). Ik mis extra tekst en uitleg zoals bij andere cursussen van Abis. (, )

Refresh this page to see other comments.

Also interesting

Enrollees for this training also took the following courses: