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
19 Feb2NLeuven  (BE)900 EUR  (excl. VAT) 
05 Apr2EWoerden  (NL)900 EUR  (exempt from VAT) 
28 May2ELeuven  (BE)900 EUR  (excl. VAT) 
25 Jun2NWoerden  (NL)900 EUR  (exempt from 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 filling out the on-line self-testthe on-line self-test.

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 606 evaluations)

Reviews

     
Zeer goed opgebouwd - pedagogisch aangepakt (, )
     
Prima workshop om wat meer aan SQL te kunnen snuiven. (, )
     
Excellente introduction au SQL (, )
     
Als iemand zonder enige IT-kennis en achtergrond (buiten SQL fundamentals) vond ik dit zéér moeilijk vandaar een zwakke Niveau beoordeling + de voorbeelden in de cursus zijn te simpel i.v.m. de oefeningen. De trainer was wel zéér goed. (, )
     
Goed, zeker iets bijgeleerd (, )
     
heel goed om verder te oefenen (, )
     
geheel naar wens (, )
     
geeft goed overzicht en voldoende praktijk om te oefenen (, )
     
maybe a bit too much about easy topics, but very great presentation (, )
     
very good, structured, informative (, )

Refresh this page to see other comments.

Also interesting

Enrollees for this training also took the following courses:


SESSION INFO AND ENROLMENT