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

Schedule

datedur.lang.  location  price
11 Jun1NWoerden  (NL)500 EUR  (exempt from VAT) 
SESSION INFO AND ENROLMENT

Intended for

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

Background

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.

Duration

1 day.

Course leader

Peter Vanroose, Arnout Veugelen.

Global score

   
4.0/5 (based on 205 evaluations)

Reviews

     
Prima! Prettige leraar en veel geleerd. Met enige voorbereiding en voorkennis is het goed te volgen. (, )
     
Goede opbouw en verderzetting van de onderwerpen. Duidelijk uitgelegd. (, )
     
Goed en interessant (, )
     
formation très intéressante (, )
     
Duidelijke cursus (, )
     
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. (, )
     
heel interessant (, )
     
Goed maar veel te kort (, )
     
Veel nieuwe inzichten gekregen die in praktijk niet waren opgepikt (CTE, null pitfalls, ranking function, cube) (, )
     
Good combination between exercises and theory (, )

Refresh this page to see other comments.

Also interesting

Enrollees for this training also took the following courses:


SESSION INFO AND ENROLMENT