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
23 May2?Leuven  (BE)900 EUR  (excl. VAT)  guaranteed
26 Jun2NWoerden  (NL)900 EUR  (exempt from VAT) 
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 626 evaluations)

Reviews

     
Het is fijn dat er veel tijd is om oefeningen te maken. Uitleg was goed en er was genoeg ruimte voor vragen. (, )
     
prima had wel een dagje langer gekund voor mij (, )
     
Goed, maar liever nog een dag langer en nog meer oefenen per onderdeel. (, )
     
geheel naar wens (, )
     
Erg goed (, )
     
Goede verhouding tussen theorie en praktijk. Veel geleerd. (, )
     
Uitstekend, sluit prima aan bij mijn leerdoel (, )
     
Over het algemeen goed (, )
     
good course. A litlle bit to much focuse on basic structure, and not more complexe function (, )
     
really good workshop, nice presentation with clear and useful explanation (, )

Refresh this page to see other comments.