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 workshop

It is said that relational database systems are easy to use. This is true when compared with non-relational systems. Nevertheless a profound training in SQL, the 'de facto standard language for RDBMS', is still necessary when you want to do more than simple queries on one or two tables.

This course gives a thorough training, both theoretical and (mainly) practical, in the use of SQL, and primarily its data manipulation aspects, i.e., translating database questions into an SQL query.

After successful completion of the course, the students will be able to read complex SQL and especially also be able to formulate complex SQL statements in a readable and maintainable way.

This course is mainly practical in nature; it builds on the course SQL and relational databases fundamentals and precedes the more advanced SQL advanced course.

Schedule

datedur.lang.  location  price
26 Oct2?Leuven  (BE)900 EUR  (excl. VAT) 
27 Nov2NWoerden  (NL)900 EUR  (exempt from VAT) 
11 Dec2NLeuven  (BE)900 EUR  (excl. VAT) 
SESSION INFO AND ENROLMENT

Intended for

Analysts, application programmers, database administrators, system programmers, end users. You can test for yourself to see if this course contains enough new information for you by printing and filling out the self-test (PDF file - 89 KB).

Background

Some experience with relational databases and SQL (see course SQL and relational databases fundamentals) is an absolute prerequisite. You can test for yourself to see if you have enough background by filling out the on-line self-test.

Main topics

Training method

Most of the time is devoted to practical exercises and to discussing the solutions. Exercises can be made either on DB2 for z/OS, DB2 for LUW, Oracle, MySQL, MariaDB, SQL Server, or PostgreSQL. (Please indicate your choice on the registration form.)

Duration

2 days.

Course leader

an ABIS instructor.

Global score

   
4.1/5 (based on 635 evaluations)

Reviews

     
Goede training, goede balans opgaven en theorie (, )
     
good, well explained but i know the content for the most (, )
     
Excellent. I totally recommend it. (, )
     
The course design is crisp. (, )
     
goed, veel praktijk, (, )
     
Très bien, enfin le cours que je cherchais depuis des années :-) (, )
     
Très bon cours, cependant la partie sur les subqueries était nettement plus difficile (, )
     
Het is fijn dat er veel tijd is om oefeningen te maken. Uitleg was goed en er was genoeg ruimte voor vragen. (, )
     
Alles was in orde. (, )
     
interessant (, )

Refresh this page to see other comments.


SESSION INFO AND ENROLMENT