Small teams and lone fighters need quality training too.
Join a small group of up to four and strengthen your SQL foo.
Big companies can easily afford hiring a trainer for their employees — but how about small companies and lone fighters?
They join my small group trainings. Check out the dates for my training modules and book them as you like. You might meet up to three other participants in each training and they will bring a wholly different background with them. In this group trainings, we will even cover multiple databases — whatever the participants use.
Each training module consists of a series of several two-hour long units. This allows you to reflect on the training content and clarify any questions directly in the next unit. Additionally, each participant gets a one hour private consulting voucher—for questions that don’t fit into the public class.
This training clarifies the most common uncertainties developers have when working with SQL, and it teaches them to find the right solution more quickly.
Topics:
Syntactic components: keywords, names, values
Type safety and the predefined data types
The most important main clauses of SQL and how they interact
SELECT, FROM & JOIN, WHERE, UNION & co., ORDER BY, FETCH FIRST
NULL and the three-valued logic of SQL
Collations
Price: €1390 (excl. VAT) per participant.
Dates and times:
13:00 - 15:30 (CEST)
Starting September 2th 2025 always Tue & Thu
Enroll ⇗
9:00 a.m. - 11:30 a.m. (PST)
Starting Oct 7th 2025 always Tue & Thu
Online analytical processing (OLAP) can simplify and accelerate many applications—also those processing transactions. Using these features not only reduces development time, it also improves the performance of the application.
GROUP BY & HAVING in detail with enhanced use cases
GROUPING SETS
Window functions and the OVER clause
Ranking
Grouping consecutive events
Price: €995 (excl. VAT) per participant.
Starting October 7th 2025 always Tue & Thu
9:00 a.m. - 11:30 a.m. (PDT)
Starting November 4th 2025 always Tue & Thu
Modern SQL can process hierarchies and graphs directly in the database. This often means that you can avoid the need to cross a technology border, thus reducing the complexity and error-proneness of the application.
The WITH clause
The SEARCH and CYCLE clauses
Use cases and examples
Price: €549 (excl. VAT) per participant.
13:00 - 15:30 (CET)
Starting November 11th 2025 always Tue & Thu
Starting Dec 2nd 2025 always Tue & Thu
In this module developers learn how to protect software from the problems caused by concurrency.
What could possibly go wrong?
How to notice something goes wrong?
Constraints have their limits
Transaction isolation
Coping with deadlocks & co
Price: €795 (excl. VAT) per participant.
Starting November 18th always Tue&Thu
In this training, developers learn how to resolve the most common cause of SQL performance issues: the index/query mismatch. After this training, developers can do more than just solve performance problems—they can proactively avoid them during their everyday work.
How does an index work?
Multi-column, partial and function-based indexes
Execution plans
Join algorithms
Building and using data clusters
Indexing sort and grouping operations
Optimizing top-n and pagination queries
Drawbacks of indexes
Price: €1550 (excl. VAT) per participant.
Starting Nov 3rd 2025 always Mon/Wed/Fri
Starting January 8th 2026 always Tue/Thu
These trainings cover the following databases: Google BigQuery, IBM Db2 (LUW), MariaDB, MySQL, SQL Server, SQLite and PostgreSQL.
Note: Due to the different capabilities of these systems some content might not be applicable to your environment. Don’t worry, during the enrollment process I’ll let you know any limitations that are applicable in your case.
The databases used in the training depends on the participants.
Theses trainings are for developers with some SQL experience. They are conducted on databases installed on the trainer’s computer. Some modules include exercises for which the participants need their own database if they choose to do the exercises.
The open small group trainings are intended for no more than two participants from a single company. Let’s arrange a private training if you want to train more people.
Privacy: The provided data is solely used to contact you about upcoming dates and invoicing.
As the SQL Renaissance Ambassador, it’s my mission to make developers aware of the evolution of SQL in the 21st century. My book “SQL Performance Explained” has been published in five languages and can be read online free of charge at use-the-index-luke.com. My next book is currently in the works and can already be read online as it’s being written (modern-sql.com). I am available as a trainer, speaker and consultant for all companies and developers interested in SQL. You’ll find more info at winand.at.
