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)  guaranteed
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.2/5 (based on 600 evaluations)

Reviews

     
Goede training, goede balans opgaven en theorie (, )
     
serves the purpose (, )
     
Prima workshop om wat meer aan SQL te kunnen snuiven. (, )
     
Goede cursus, uitstekende docent, leuke opbouw in moeilijkheidsgraad van de oefeningen (, )
     
goed, veel praktijk, (, )
     
correcte verhouding oefening en theorie (, )
     
Goed, zeker iets bijgeleerd (, )
     
Erg goed (, )
     
Zeer leerzaam. (, )
     
Goed tot uitstekend (, )

Refresh this page to see other comments.


SESSION INFO AND ENROLMENT