home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » 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 » 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

Objectives

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.

Main topics

  • More advanced SELECT:
  • subqueries in WHERE predicates
  • nested table expressions • common table expressions
  • correlated subqueries • EXISTS
  • scalar subqueries
  • group by & having: typical use and "best practices"
  • union • intersect • except • minus
  • inner join, left/right/full outer join of multiple tables, and when to use
  • expressions: case; extract; cast; date & time manipulations
  • overview and use of the most useful scalar functions
  • INSERT, UPDATE, DELETE
  • Hidden mistakes, alternative formulations, query readability, best practices
 

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.

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

Course leader

an ABIS instructor.

Duration

2 days.

Schedule

You can enrol by clicking on a date
datedur.lang.  location  price
26 Jun2NWoerden  (NL)900 EUR  (exempt from VAT)  guaranteed
26 Oct2?Leuven  (BE)900 EUR  (excl. VAT) 
27 Nov2NWoerden  (NL)900 EUR  (exempt from VAT) 
11 Dec2NLeuven  (BE)900 EUR  (excl. VAT) 

Global score

   
4.1/5 (based on 612 evaluations)

Reviews

     
The course was very useful to me mainly because it was taught and presented in a really nice way. The instructor was very cooperative and answered all my queries and this helped to enhance my SQL querying skills. (, )
     
Excellent (, )
     
Très bon cours, cependant la partie sur les subqueries était nettement plus difficile (, )
     
Zeer interessant voor mensen met wat verouderde SQL-kennis (, )
     
goede cursus, goed tempo, goede dagindeling (, )
     
Goed, zeker iets bijgeleerd (, )
     
geeft goed overzicht en voldoende praktijk om te oefenen (, )
     
Nuttig en praktijkgericht (, )
     
Zeer leuke workshop die zowel als opfrissingscursus, als een prima opvolging op de basiscursus kan gebruikt worden. (, )
     
cursusmateriaal lastig als leerstof te gebruiken. Opgaven zijn vaak meer gericht op letterlijke invulling van de opdracht,dan op oefenen van de verschillende methodess. (, )

Refresh this page to see other comments.