Those in the IT field who neglect education quickly fall behind.
When did your developers get their last SQL update?
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.
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
Although not strictly required it is recommended to take the SQL Reloaded training before this one.
SQL Performance Tuning by @MarkusWinand was an eye-opener!
Brian on Twitter
It was, by far, the best course I ever attended
Bobicescu Silviu on LinkedIN 2019
Privacy: The provided data is solely used to make you an offer and subsequent invoicing.
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.
