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.
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.
Topics:
The WITH clause (non-recursive)
The WITH RECURSIVE clause
Use cases and examples
Price: €549 (excl. VAT) per participant.
Dates:
March 2023: 28th and 30th
Tue and Thu from 1pm to 3pm (CEST; Europe/Vienna)
Enroll ⇗
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
April 2023: 25th and 27th
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.
May 2023: 3rd through 17th
Always Mon/Wed/Fri from 1pm to 3pm (CEST; 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.
