SQL advanced course (EN/NL/FR)

Tijdsduur
Locatie
Op locatie, Online
Startdatum en plaats

SQL advanced course (EN/NL/FR)

ABIS
Logo van ABIS
Opleiderscore: starstarstarstarstar_border 8 ABIS heeft een gemiddelde beoordeling van 8 (uit 1 ervaring)

Tip: meer info over het programma, prijs, en inschrijven? Download de brochure!

Startdata en plaatsen

placeLeuven
10 jun. 2024
Toon rooster
event 10 juni 2024, 09:00-17:00, Leuven
computer Online: Online
10 jun. 2024
Toon rooster
event 10 juni 2024, 09:00-17:00, Online

Beschrijving

Questions we try to answer during this 1 day advanced SQL ABIS training are:

  • How to cope with SQL instructions required by modern applications?
  • 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?

This training is intended for users and developers for database systems. A good knowledge of SQL is required.

Remark: Course description in English; Dutch and French versions are available on the ABIS website. Courses are planned in…

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Nog niet gevonden wat je zocht? Bekijk deze onderwerpen: SQL, Microsoft SQL Server, MySQL, Data Science en PostgreSQL.

Questions we try to answer during this 1 day advanced SQL ABIS training are:

  • How to cope with SQL instructions required by modern applications?
  • 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?

This training is intended for users and developers for database systems. A good knowledge of SQL is required.

Remark: Course description in English; Dutch and French versions are available on the ABIS website. Courses are planned in Dutch, English, and French. Consult the ABIS website for alternate course formats.

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 aggregation)
  • 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

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

Background/Prerequisites: A good knowledge of SQL is required (see SQL workshop) and active experience with one of the major RDBMS systems is very welcome (see e.g. Db2 for LUW fundamentals course, Db2 for z/OS fundamentals course, Oracle fundamentals course). 

Training Method/Didactics: 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.

Duration: 1 day.

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.
  • Vraag informatie aan over deze cursus. Je ontvangt vanaf dan ook een seintje wanneer iemand een ervaring deelt. Handige manier om jezelf eraan te herinneren dat je wilt blijven leren!
  • Bekijk gerelateerde producten mét ervaringen: SQL.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Download gratis en vrijblijvend de informatiebrochure

(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)

Heb je nog vragen?

(optioneel)