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
date | dur. | lang. | location | price | |
06 Feb | 2 | Leuven | 1140 EUR (excl. VAT) | ||
06 Feb | 2 | web based | 1140 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!
Duration
2 days.
Course leader
an ABIS instructor.
Reviews
4.3/5 (based on 117 evaluations; the most recent ones are shown below)
|
Very good only at some points it went too fast for me.
| (Olivia Cristina, ) |
I really liked the course, it was well structered and the content was also really nice
| (Adriana Sansal, ING - Haarlerbergpark, ) |
very nice and informative course. I learned a lot. the concept are very well explained in this course
| (Maryam, ) |
Online gevolgd, dus accomodatie niet relevant. Algemeen: intens, moeilijk en boeiend.
| (Harald Eberhardt, KBC Global Services, ) |
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, ) |
Click here to see more comments...
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, ) |
De cursus is goed ingericht, theorie en oefening wisselen elkaar af. Top trainer
| (Hoessein Bensi Ali, APG, ) |
Zeer relevante en bruikbare cursus.
| (Sabine de Win, APG, ) |
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., ) |
Positief, goede afwisseling theorie en oef. Veel nieuwe zaken bijgeleerd.
| (N.N., ) |
Als autodidact veel aan gehad.
| (N.N., Sociale Verzekeringsbank, ) |
Prima cursus met verhouding tussen praktijk en theorie uitstekend
| (Marcel Faymonville, Sociale Verzekeringsbank, ) |
inhoud ok, zeer goed gegeven, zowel voor de beginners, als de gevorderden
| (Eric Verswyvel, HZIV, ) |
Geeft goede handvaten om zelf met queries aan de slag te gaan.
| (Rob Kemkes, ING - Bijlmerdreef, ) |
Een zeer handige cursus met tips and trics die ik zeker kan gebruiken in de praktijk
| (N.N., Federale Pensioendienst, ) |
Voldoet zeker aan de behoefte!
| (Bob Merx, APG, ) |
Zeer uitdagend, maar heeft wel geleid tot extra inzichten en een nieuwe manier van SQL te benaderen. Je bouwt voor jezelf extra controles in om de juiste resultaten te bekomen.
| (N.N., Vlaamse Overheid - AHOVOKS-Afd Studietoelagen, ) |
Een goede inhoud , een goed tempo.
| (Caroline Domogala, Vlaamse Overheid - AHOVOKS-Afd Studietoelagen, ) |
Super
| (N.N., Vlaamse Overheid - AHOVOKS-Afd Studietoelagen, ) |
goede cursus om de basis uit te leggen.
| (Michelle de Böck, ) |
prima bootcamp, duidelijke uitleg, goede docent
| (Daniëlle, ) |
Prima, een aanrader en veel van op gestoken
| (Tim Beurskens, APG, ) |
Heel goed
| (N.N., Vlaamse Overheid - Financiën en Begroting, ) |
Heel goede cursus, zeer competente docent!
| (Jos Engels, APG, ) |
goede uitleg, presentatie.
| (Joris, ) |
Aangenaam tempo. Nuttige nieuwe informatie
| (Jelle Braum, Caitlann Consulting, ) |
Très bon cours, très clair et structuré. Syllabus complet.
| (Pascale, ) |
Erg nuttig, en enthousiast gegeven.
| (Michiel, ) |
Zeer boeiend en leerzaam, maar ook positief vermoeiend. Veel hersenkrakers.
| (Ruben, ) |
Really good, I think I learned some useful things
| (Luca Vanderbist, Sigedis, ) |
I am satisfied because I learned how to correctly manipulate some queries . Group by and temporary tables
| (Zaneza Nkezabera, Sigedis, ) |
Better then expected! It was not too technical and quite easy to follow. I was never bored or left in the dark :-)
| (Geert Joris, Sigedis, ) |
Enorm goed verzorgd, zowel de inhoud, de correctheid van de voorbeelden als de faciliteiten
| (Willem Dauwen, publiq, ) |
Zeer goed,veel opgefrist en bijgeleerd
| (N.N., ) |
Heel goed
| (N.N., ) |
Een goed begeleide cursus waarbij je voldoende wordt uitgedaagd zelf met SQL te leren werken.
| (Céline Kegels, ) |
Ok, af en toe net iets te snel (correlated q)
| (N.N., ) |
Also interesting
Enrollees for this training also took the following courses:
SESSION INFO AND ENROLMENT |