Picture of Markus Winand

Small teams and lone fighters need quality training too.

Join a small group of up to four and strengthen your SQL foo.

Live SQL Online Training for Expert Developers

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.

Modules, Dates and Prices

Recursive Queries 2x2h

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)

Data Consistency 2x2h

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.

Topics:

  • 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

Price: €549 (excl. VAT) per participant.

Dates:

  • April 2023: 25th and 27th

    Tue and Thu from 1pm to 3pm (CEST; Europe/Vienna)

SQL-Performance Kick-Start 7x2h

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.

Topics:

  • 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.

Dates:

  • May 2023: 3rd through 17th

    Always Mon/Wed/Fri from 1pm to 3pm (CEST; Europe/Vienna)

Covered Databases

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.

Prerequisites

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.

Yes, I want to join!

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.

SQL Renaissance Ambassador

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.

Connect with Markus Winand

Markus Winand on LinkedInMarkus Winand on XINGMarkus Winand on Twitter