Well-rested you learn best.
That’s why my online courses take place as a series of short 2 hour sessions.
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 puts great importance to talking to all participants in his trainings. This is the only way to recognize and update outdated knowledge.
“I was able to quickly understand and solve performance problems in my daily work thanks for the training“
Florent Guilleux, software engineer
“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.“
Melvin Bossink, Senior System Administrator
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.
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
Get in touch ⇗
This training clarifies the most common uncertainties developers have when working with SQL, and it teaches them to find the right solution more quickly.
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
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.
GROUP BY & HAVING in detail with enhanced use cases
GROUPING SETS
Window functions and the OVER clause
Ranking
Grouping consecutive events
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.
The WITH clause (non-recursive)
The WITH RECURSIVE clause
Use cases and examples
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
This module is currently under construction. Inquire now to be informed immediately when the module is available.
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
“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“
Privacy: The provided data is solely used to make you an offer and subsequent invoicing.
The training takes place online. The preferred technology is currently Zoom. 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).