SQL workshop
During this practical 3-day workshop at ABIS, you will get familiar with intermediate level SQL, which will allow you to read and formulate more complex SQL statements.
A good knowledge of SQL—the de facto standard language for querying and manipulating databases—is essential for anyone who wants to do more than the simplest queries on one or two tables. During this workshop, you will be challenged to formulate advanced data queries using subqueries, set operations, and various functions.
This interactive workshop offers:
- in-depth SQL training, both theoretical and (especially) practical
- translating an analysis question into an SQL query
- reading and writing complex SQL queries in a clear, 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?
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 | |||||
|---|---|---|---|---|---|
| date | dur. | lang. | location | price | |
| 03 Nov | 2 | Woerden | 1190 EUR (exempt from VAT) | ||
| 03 Nov | 2 | web based | 1190 EUR (excl. VAT) | ||
| 01 Dec | 2 | web based | 1190 EUR (excl. VAT) | ||
| 01 Dec | 2 | Leuven | 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. If not, you can go straight on to our SQL advanced course.
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 "Basic SQL".
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
- 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
Reviews
4.4/5 (based on 62 evaluations; the most recent ones are shown below)
|
Good course to get you started with sql queries, I recommend; Trainer explained the concept clearly and slowly.
|
| (N.N., ) |
Excellent course covering all major topics for SQL
|
| (Matteo, ) |
Heldere uitleg en zeer nuttige cursus
|
| (Ayla Melgert, APG Heerlen, ) |
Een zeer leerzame en goed gestructureerde cursus. De inhoud was duidelijk, relevant en praktisch toepasbaar
|
| (Stijn, ) |
Good exercises, nice and open atmosphere in classroom.
|
| (Amarens, ) |
It was great as a recap for my SQL knowledge. Nicely organised. Teacher was a nice person that always wanted to help.
|
| (Marc, ) |
Ik ben heel tevreden, gezien ik heel wat geleerd heb en het gevoel heb dat we dit ook effectief kunnen toepassen in de praktijk.
|
| (Emma, ) |
Heel praktisch gericht wat een enorm voordeel is om veel te oefenen. Door deze werkwijze was ik vlugger mee.
|
| (Jessica, ) |
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.
|
| (Sarah Verlinde, Vlaamse Overheid - AHOVOKS, ) |
goede instructor/docent
|
| (N.N., Vlaamse Overheid - AHOVOKS, ) |
goede instructor/docent
|
| (N.N., Vlaamse Overheid - AHOVOKS, ) |
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.
|
| (N.N., Vlaamse Overheid - FB, ) |
Vraiment interessant comme cours
|
| (Malek Aref, Sigedis, ) |
Satisfait pour cette remise à niveau
|
| (N.N., Sigedis, ) |
Excellente formation, très bien dispensée
|
| (Hugues Colbrant, BNP Paribas Fortis, ) |
Super balance entre théorie et exercices
|
| (Daniellyson Teixeira de Vasconcelos, ) |
Het was goed maar voor mij ging het zo nu en dan te snel. Heeft te maken met mijn niveau uiteraard
|
| (N.N., Rabobank Nederland, ) |
Heel fijne opleiding, precies waar ik naar op zoek was als gebruiker van sql zonder formele achtergrond daarbij.
|
| (Merijn Lucke, APG Amsterdam, ) |
De cursus is goed ingericht, theorie en oefening wisselen elkaar af. Top trainer
|
| (Hoessein Bensi Ali, APG Amsterdam, ) |
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.
|
| (N.N., ) |
Zeer relevante en bruikbare cursus.
|
| (Sabine de Win, APG Heerlen, ) |
Positief, goede afwisseling theorie en oef. Veel nieuwe zaken bijgeleerd.
|
| (N.N., ) |
Also interesting
Enrollees for this training also took the following courses:
- SQL and relational databases fundamentals
- SQL advanced course
- Oracle SQL performance
- Modern data warehousing and business intelligence
| SESSION INFO AND ENROLMENT |