Picture of Markus Winand

Those in the IT field who neglect education quickly fall behind.

When did your developers get their last SQL update?

SQL Training in your Office

Markus Winand is fascinated by the endless possibilities of modern SQL. You can feel that when you work with him in person. Sign up for a on-site training with Markus Winand and move your development team to the next level.

Note that basic SQL knowledge is a requirement for all trainings provided Markus Winand. Markus specializees in turning outdated SQL-92 knowledge into solid and modern SQL know-how.

In addition to the two-day trainings from the course list, “SQL-Performance Kick-Start” and “SQL Reloaded”, Markus regularly holds trainings that cover customer specific topics. Let Markus advise you in person. To give you some ideas, you’ll find a few popular topics below.

Training Catalog

Here are some popular training topics. Of course you can also ask about other topics. Please note that the mentioned duration is just a rough indication—it may vary based upon the databases you want to cover and how you combine multiple modules.

SQL-Performance Kick-Start 2 days

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

SQL Reloaded ~2 days

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

Analysis and Aggregation ~1 day

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

Recursive Queries ~½ day

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

Data Consistency ~2 hours

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

JSON Coming soon

This module is currently under construction. Inquire now to be informed immediately when the module is available.

Topics:

  • Understanding SQL as a transformation language

  • Generating JSON documents from tables

  • The SQL/JSON path query language

  • Turning JSON documents into a tabular form

  • Sorting and retrieving JSON document in tables

Although not strictly required it is recommended to take the SQL Reloaded training before this one.

What Participants Say

SQL Performance Tuning by @MarkusWinand was an eye-opener!

It was, by far, the best course I ever attended

Set Up a Training Now

Privacy: The provided data is solely used to make you an offer and subsequent invoicing.

Availability

May 2023

MonTueWedThuFri
12345
89101112
1516171819
2223242526
293031

June 2023

MonTueWedThuFri
12
56789
1213141516
1920212223
2627282930

July 2023

MonTueWedThuFri
34567
1011121314
1718192021
2425262728
31

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