Picture of Markus Winand

Every development team needs an SQL expert.

With this training, a member of your team can become this SQL expert.

5-Day SQL-Update for Developers and Analysts

After this 5-day training, the participants clearly stand out from the field: they master modern SQL, know design principles for scalable databases and have gained practical experience through numerous exercises. During these five days, Markus Winand conveys the extensive SQL experience that he’s accumulated during his eight years as a developer with an international bank and a further eight years as an independent SQL trainer and consultant for companies of all sizes.

Dates 2019:

If these trainings don't fit: contact me for alternatives (online, in-house, you name it).

What Participants Say

“The best SQL training developers can get“

“A truly productive training”

Contents

SQL-Performance Kick-Start

In this module, 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

This module 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

  • NULL and the three-valued logic of SQL

  • Queries: structure and logical order of execution

  • Joins

  • The modern interpretation of the relational model

  • Storing versioned (historic) data in SQL databases

  • Immutable facts as a design principle

Analysis and Aggregation

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

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

Covered Databases

This training covers the following databases: MariaDB, MySQL, SQL Server, PostgreSQL, and the Oracle database. IBM Db2 (LUW) and SQLite on request.

The databases actually used in the training is adjusted to the participants.

This training covers window function and the WITH clause and is therefore a great update for MySQL/MariaDB users.

All exercises are available for all covered databases.

Price

The course fee is €2490 (plus 20% VAT, €2988) per participant.

Foreign companies might be entitled for a full VAT refund from Austrian tax authorities. See VAT-Refund Procedure at the website of the Austrian Ministry of Finance for prerequisites and further details.

In the Package

This is what you get for your money:

  • 5 full days (Mon-Fri; 9am–5pm) training with Markus Winand

  • No more than 8 participants

  • The venue is the Hotel am Parkring in Vienna, Austria.

  • Catering: Lunch, snacks during the breaks, drinks all day long

  • One hard copy and PDF of “SQL Performance Explained” (choose: English, German, French, Japanese or Spanish)

  • PDF and wire-bound print of the current draft of my next book covering the other topics of the training (choose: English or German)

  • Training exercises and solutions (runnable scripts for all covered databases)

  • Teammate on demand voucher: 2 times 30 minutes remote coaching valid 30 days after the training.

  • Certificate of completion (singed PDF and hard copy).

Prerequisites

This training is for developers with some SQL experience.

Bring your own device (with a database installed) or ask for a rental device. Detailed requirements will be shared several weeks before the training.

A VirtualBox appliance with a preconfigured free open source databases will be made available for download before the training. Client not included—install your preferred client before the training.

Yes, I want to join!

If these trainings don't fit: contact me for alternatives (online, in-house, you name it).

Privacy: The provided data is solely used to contact you about upcoming dates and invoicing.

Procedure

Please complete the form above if you are interested in this training. I'll e-mail you a formal quote along with the invoice for a 20% advance payment to guarantee your seat.

Note that there is a free cancellation period both parties (you and me). The last date of free cancellation will be stated on the invoice. Please keep the possibility of a cancellation from my side in mind when you are doing your travel plans.

What Participants Say

In this intensive training we learned the basic blocks of database tuning in a great depth and practiced the analysis and tuning of different SQL statements. In addition we looked at typical SQL traps and learned how to avoid them. The last part of the training was a journey into a world of “new” SQL with advanced grouping/aggregation, window functions and recursive queries. The training was rounded off by very good documentation and a real SQL master as a trainer. In summary: the best SQL training developers can get.

A truly productive training. The biggest win for me with the training is increased confidence in the SQL arena. Before I have sometimes managed to come up with solutions that work, buts still feels clumsy, now I always know what to do.

Environment

Climate protection is important. I therefore compensate the climate impacts of your trip to Vienna at atmosfair.de. Please consider the climate balance of the respective means of transport during your travel planning. Avoiding emissions is still the best climate protection.

About Markus Winand

Markus Winand is the SQL Renaissance Ambassador. He is on a mission to introduce developers to the evolution of SQL in the 21st century. His first book “SQL Performance Explained” is available in five languages and can be read for free on his website use-the-index-luke.com. Markus is currently working on his second book that is likewise available free of charge online (modern-sql.com). Markus can be hired as trainer, speaker and consultant via winand.at.

Connect with Markus Winand

Markus Winand on LinkedInMarkus Winand on XINGMarkus Winand on Twitter