SQL advanced course

SQL is a living, modern language. It entails a lot more possibilities than it did traditionally.

Are you practising SQL already for quite some years? Learn in this one-day course at ABIS how you can do more with SQL!

Applications are becoming more demanding than before in their use of database systems like Oracle, Db2, SQL Server, PostgreSQL ... and the SQL used by data warehouse BI-tools (e.g. Business Objects) and ERP solutions (e.g. SAP, Siebel) is also becoming more advanced.

By using modern SQL syntax, also relatively complex questions for the RDBMS remain readable and maintainable.

Questions that we try to answer during this advanced SQL training are:

  • How will we cope with these modern - often dynamic - SQL statements?
  • How to write SQL queries which are as readable and as maintainable as possible?
  • Can we take advantage of relatively new standard SQL features, which could provide interesting possibilities?
  • Can we use unknown SQL-syntactic features that can simplify existing SQL code, or make it more readable and more efficient?

Do you accept the challenge? By using very concrete SQL examples and exercises, we show that the possibilities of the extended SQL tool set may have an important positive impact.

Schedule a training?

Delivered as a live, interactive training – available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.

REQUEST IN-COMPANY TRAINING

 

Public training calendar
datedur.lang.locationprice 
23 Jun1web based 655 EUR (excl. VAT)
23 Jun1Leuven 655 EUR (excl. VAT)
SESSION INFO AND ENROLMENT

Intended for

This training is intended for users and developers for database systems like e.g. Oracle, Db2, SQL Server, MySQL, MariaDB, PostgreSQL, Hive, ...

Background

A good knowledge of SQL is required (see e.g. our SQL workshop).

You can test for yourself to see if you have enough background by filling out the on-line self-test "SQL Intermediate".

Main topics

  • Overview of the reference material for the SQL standard and of the different RDBMS platforms
  • Nested Selects, Common Table Expressions ("WITH" clause), and correlated references in a nested select
  • Clever ways to combine inner and outer joins
  • "Time travel" queries
  • Where clause: predicates, regular expressions, and some unexpected side effects of NULL values
  • A first encounter with OLAP functions (for a.o. ranking and windowing)
  • Possible applications of the Order By and Fetch First clauses; pagination
  • Select from Insert, Update, Delete
  • Update and Delete with correlated subqueries
  • The Merge statement
  • Recursive SQL

Training method

Using several examples and giving lots of exercises, you will be guided step by step through this material. After the training, you get access to our on-line database environment, so you can practise at home/work.

Certificate

At the end of the session, the participant receives a "Certificate of Completion".

Duration

1 day.

Course leader

Peter Vanroose (ABIS), Arnout Veugelen (ABIS), Sandy Schillebeeckx (ABIS).

Reviews

4.2/5 (based on 83 evaluations; the most recent ones are shown below)

Learned/refreshed lots of SQL content in a good pace and well done explanation

 
  (, )

It was good and it is as expected

 
  (, )

Great course, with a great instructor.

 
  (, )

great!

 
  (, )

Really nice and useful course

 
  (, )

The material of the course was quite good and comprehensive.

 
  (, )

The course pointed out a lot of new stuffs I wasn't aware of.

 
  (, )

A great course. Highly recommended!

 
  (, )

Click here to see more comments...

The course was good but instead of doing it in one day it could have been devided in two days for 4 hours each , that way we might have not been too exhausted.

 
  (, )

Positief beleefd, begin was erg elementair maar werd steeds hoger in niveau.

 
  (, )

Ik vond het een hele nuttige cursus, alleen wat te veel voor op 1 dag

 
  (, )

Très bon cours

 
  (, )

Goede duidelijke cursus.

 
  (, )

zeer kundige en enthousiaste docent. veel facetten van sql besproken

 
  (, )

goed, maar moeilijk

 
  (, )

Also interesting

Enrollees for this training also took the following courses:


SESSION INFO AND ENROLMENT