Picture of Markus Winand

Well-rested you learn best.

That’s why my online courses take place as a series of short 2 hour sessions.

Personal Contact Makes the Difference

To move experienced developers forward, it is not enough just to teach them new features. Is is also important to address topics that have become outdated. Prerecorded videos cannot do this. This requires a dialogue that cannot be realized without personal contact. Therefore Markus Winand attaches great importance to talking to all participants in his trainings. This is the only way to recognize and update outdated knowledge.

What Participants Say

“I was able to quickly understand and solve performance problems in my daily work thanks for the training“

“Markus started at the beginning where it became quickly clear that he has a real talent of explaining important complex concepts in a very easy to understand way.“

Training Catalogue

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 6x2h

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 5x2h

This training clarifies the most common uncertainties developers have when working with SQL, and it teaches them to find the right solution more quickly. This training also introduces some less well-known design principles that have nevertheless proven themselves over the past decade.

Topics:

  • Syntactic components: keywords, names, values

  • Type safety and the predefined data types

  • Queries: structure and logical order of execution

  • Joins

  • NULL and the three-valued logic of SQL

  • Collations

Analysis and Aggregation 3x2h

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:

  • Avoiding self-joins

  • Multiple groupings

  • Window functions

  • Ranking

  • Grouping consecutive events

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

Data Consistency 1x2h

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

What Participants Say

“I was able to quickly understand and solve performance problems in my daily work thanks for the training. The theoretical part explains the actual useful concepts. Markus is a very knowledgeable pedagogue who also provides relevant practical advice thanks to his consulting experience.“

“I followed the SQL-Performance Kick-Start in a one-on-one training with Markus. The course was very well structured and thought off. Markus started at the beginning where it became clear quickly that he has a real talent of explaining important complex concepts in a very easy to understand way. When necessary he did not find it a problem teaching a little out of scope. The most important aspects where repeated to really understand the entire indexing tuning approach. I am very confident after the training and i can even say that it became clear to me how proper indexing works, what to do and not do and ultimately positively change our production ERP performance“

Configure your Training

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

Prerequisites

The training takes place online. The preferred technology is currently Google Hangouts. A different technology can be used upon request if the participant provides the required licenses.

The suitability of your infrastructure can be tested before booking (please put a note in the form above).

Availability

November 2020

Mon.Tue.Wed.Thu.Fri.
23456
910111213
1617181920
2324252627
30

December 2020

Mon.Tue.Wed.Thu.Fri.
1234
7891011
1415161718
2122232425
28293031

January 2021

Mon.Tue.Wed.Thu.Fri.
1
45678
1112131415
1819202122
2526272829

Connect with Markus Winand

Markus Winand on LinkedInMarkus Winand on XINGMarkus Winand on Twitter