SQL advanced course (EN/NL/FR)
Startdata en plaatsen
placeLeuven 10 jun. 2024Toon rooster event 10 juni 2024, 09:00-17:00, Leuven |
computer Online: Online 10 jun. 2024Toon 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…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
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
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.