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

SQL Reloaded 6x2h

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)

Analysis and Aggregation 4x2h

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.

Topics:

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

Dates:

  • February 2024: 13th through 22st

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

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:

  • October 2023: 3rd and 5th

    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:

  • October 2023: 17th and 19th

    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:

  • November 20th 2023 through December 4th

    Always Mon/Wed/Fri from 1pm to 3pm (CET; 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