Picture of Markus Winand

What are your plans for Aug 20–24 and Sept 17–21 2018?

Join my 5-days intensive SQL training in Vienna, Austria!

5-Day Intensive Training for Emerging Experts

The next 5-day SQL training in Vienna will take place on Aug 20–24 or Sept 17–21 2018. The final date is set according demand. If you’d like to join one of these dates, please complete the form below.

If this training doesn't fit, file your interest in future trainings here.

Covered Databases

The next training will use the PostgreSQL database as primary database. The training will also cover the following secondary databases: MariaDB, MySQL, SQL Server, and the Oracle database.

Primary database means that I will demo everything using PostgreSQL. I will also demo differences to the secondary databases, but not every single example in all databases.

All exercises are available for all mentioned databases (if the database supports the required functionality).

Language of Instruction

The next training will be held in English. All training material is available in German too. Some training material (“SQL Performance Explained”) is also available in French, Japanese, and Spanish.

As I'm a German native speaker I can also take German questions during the 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

Price

The admittance fee is EUR 2 490.— (plus 20% VAT = EUR 2 988.—) 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 will be a conference hotel in Vienna, Austria.

    The actual venue will be announce no less than 3 weeks before the training.

  • Catering: Lunch, snacks during the breaks

  • 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.

Prerequisites

This training is for developers with some SQL experience.

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

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

Procedure

Please complete the form below if you are interested in either of the two proposed dates.

If one of the two dates gains enough traction, I'll e-mail you a formal quote along with the invoice for a 20% advance payment to guarantee your seat.

For each date, there will be a period in which both parties (you and me) can cancel for free. 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.

Yes, I want to join!

If this training doesn't fit, file your interest in future trainings here.

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

About Markus Winand

Markus Winand is an independent author, trainer and consultant on all things SQL. His book “SQL Performance Explained” has just been translated into a fifth language. It can be purchased as a print edition, and it’s also available to read for free on his use-the-index-luke.com website. Markus is currently working on his second book centered on the idea that things have changed a lot since SQL-92. It is likewise available free of charge online (modern-sql.com). Markus Winand is regularly speaking at international conferences and user groups.

Connect with Markus Winand

Markus Winand on LinkedInMarkus Winand on XINGMarkus Winand on Twitter