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:
January 2024: 9th through 25th
Always Tue and Thu from 1pm to 3pm (CET; Europe/Vienna)
Enroll ⇗
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.
February 2024: 13th through 22st
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 (non-recursive)
The WITH RECURSIVE clause
Use cases and examples
Price: €549 (excl. VAT) per participant.
October 2023: 3rd and 5th
Tue and Thu from 1pm to 3pm (CEST; Europe/Vienna)
In this module developers learn how to protect the consistency of the data—and thus all also maintain the correctness of decisions based on the data.
Data types, constraints and domains
Deferrable constraints
Transactions in the context of write operations
Transactions in the context of read operations
Transaction isolation and concurrency
October 2023: 17th and 19th
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.
November 20th 2023 through December 4th
Always Mon/Wed/Fri from 1pm to 3pm (CET; Europe/Vienna)
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.