SQL workshop

During this practical workshop, you will get familiar with intermediate level SQL, which will allow you to read and formulate more complex SQL statements.

A profound training in SQL, the 'de facto standard language for Relational Database Management Systems', is necessary when you want to do more than simple queries on one or two tables. Besides the traditional RDBMS (like Oracle, Db2, SQL Server, PostgreSQL, MySQL ... ), SQL is also supported by non-relational systems such as Hive (used in Hadoop and Spark) and by e.g. SQLite and MS Access.

This course provides a thorough training, both theoretical and (mainly) practical, in the use of SQL, and primarily its data manipulation aspects, i.e., translating business questions into an SQL query. After successful completion of the course, the students will be able to read complex SQL and will be able to formulate their own complex SQL statements in a readable and maintainable way.

This training is mainly practical in nature; it builds on the course SQL and relational databases fundamentals and precedes the more advanced SQL advanced course.

Schedule a training?

REQUEST IN-COMPANY TRAINING

 

Public training calendar
datedur.lang.locationprice 
02 Jun2web based 1190 EUR (excl. VAT)
02 Jun2Leuven 1190 EUR (excl. VAT)
SESSION INFO AND ENROLMENT

Intended for

The training is intended for anyone who wants to write or read SQL queries: 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-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

  • More advanced SELECT:
  • subqueries in WHERE predicates
  • nested table expressions — common table expressions (WITH clause)
  • 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

Training method

Most of the time is devoted to practical exercises and to discussing the solutions. Exercises can be made either on Oracle, Db2 for z/OS, Db2 for LUW, MySQL, MariaDB, SQL Server, or PostgreSQL. (Indicate your choice on the registration form.) 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

2 days.

Course leader

an ABIS instructor.

Reviews

4.4/5 (based on 75 evaluations; the most recent ones are shown below)

It was great as a recap for my SQL knowledge. Nicely organised. Teacher was a nice person that always wanted to help.

 
  (, )

Good course to get you started with sql queries, I recommend; Trainer explained the concept clearly and slowly.

 
  (, )

Excellent course covering all major topics for SQL

 
  (, )

Good exercises, nice and open atmosphere in classroom.

 
  (, )

Ik ben heel tevreden, gezien ik heel wat geleerd heb en het gevoel heb dat we dit ook effectief kunnen toepassen in de praktijk.

 
  (, )

goede instructor/docent

 
  (, )

goede instructor/docent

 
  (, )

Heel praktisch gericht wat een enorm voordeel is om veel te oefenen. Door deze werkwijze was ik vlugger mee.

 
  (, )

Click here to see more comments...

Het gaat soms snel. Maar doordat er begeleiders langskomen, lukt het wel om de stukken die ik moeilijk vind ook te begrijpen.

 
  (, )

Goede sql workshop, eerste dag een beetje makkelijk voor zij die al ervaring hebben met SQL. Op het einde van de tweede dag werd het dan weer een beetje veel.

 
  (, )

Vraiment interessant comme cours

 
  (, )

Satisfait pour cette remise à niveau

 
  (, )

Excellente formation, très bien dispensée

 
  (, )

Super balance entre théorie et exercices

 
  (, )

Het was goed maar voor mij ging het zo nu en dan te snel. Heeft te maken met mijn niveau uiteraard

 
  (, )

De cursus is goed ingericht, theorie en oefening wisselen elkaar af. Top trainer

 
  (, )

Heel fijne opleiding, precies waar ik naar op zoek was als gebruiker van sql zonder formele achtergrond daarbij.

 
  (, )

Zeer relevante en bruikbare cursus.

 
  (, )

great course, this has given me the knowledge and practice to start querying on my own. before this course i was a bit hesitant to use SQL.

 
  (, )

Positief, goede afwisseling theorie en oef. Veel nieuwe zaken bijgeleerd.

 
  (, )

Prima cursus met verhouding tussen praktijk en theorie uitstekend

 
  (, )

Als autodidact veel aan gehad.

 
  (, )

inhoud ok, zeer goed gegeven, zowel voor de beginners, als de gevorderden

 
  (, )

Geeft goede handvaten om zelf met queries aan de slag te gaan.

 
  (, )

Een zeer handige cursus met tips and trics die ik zeker kan gebruiken in de praktijk

 
  (, )

Also interesting

Enrollees for this training also took the following courses:


SESSION INFO AND ENROLMENT