Picture of Markus Winand

Conferences offer a great variety of topics.

SQL should not be missing.

Events with Markus Winand and SQL

I've submitted quite some proposals for conferences in 2020. You'll find them here as soon as they are confirmed.

February 2020

February 27 — Warsaw, Poland

Warsaw PostgreSQL Users Group

More Than a Query Language: SQL in the 21st Century

Did you know the purely relational dogma of SQL was already abandoned in 1999?

The last SQL standard that was limited to the relational idea was SQL-92. From SQL:1999 onwards, the SQL language was extended with non-relational operations and non-relational data structures. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many SQL users haven’t heard of it until today.

This talk provides the big picture on the evolution of the SQL standard and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.

Free registration required. Event website ⇗

March 2020

March 10 — Zürich, Switzerland

Voxxed Days Zürich 2020

More Than a Query Language: SQL in the 21st Century

“Great News–The Relational Model is Dead” was a prominent comment on the release of the new SQL standard in 1999. The message behind the provoking statement was that SQL has evolved beyond the relational model. As much as this move was discussed at that time, it took decades until database vendors caught up with this idiomatic change. Many developers haven’t heard of it until today.

This talk provides the big picture on the evolution of SQL and introduces some selected modern SQL features by example. You will see that SQL has changed as much as our requirements have changed over the past decades.

Tickets CHF 333. Student discount available. Event website ⇗

March 12 — Linz, Austria

Enterprise Java User Group Austria

Mehr als eine Abfragesprache: SQL im 21. Jahrhundert

“Great News–The Relational Model is Dead” war ein prominenter Kommentar als 1999 ein neuer SQL-Standard verabschiedet wurde. Der Hintergrund dieser provokanten Aussage war, dass sich SQL damit über das relationale Modell hinausentwickelt hat. Obwohl dieser Schritt damals viel diskutiert wurde, haben manche Datenbankhersteller Jahrzehnte gebraucht, um diesen Paradigmenwechsel zu vollziehen. Viele Entwickler haben bis heute nichts davon gehört.

Dieser Vortrag erzählt die Geschichte dieser revolutionären Änderung und stellt einige ausgewählte Funktionen von modernem SQL vor. Dabei wird deutlich, dass sich SQL in den letzten Jahrzehnten genauso geändert hat wie die Anforderungen, die an moderne Softwareentwicklung gestellt wird.

Free registration required. Event website ⇗

March 23-27 — Vienna, Austria

5-day SQL-Training (German)

Performance and Modern SQL Training (German)

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.

Topics: SQL Performance (indexing), SQL Reloaded (from Join to NULL), Analysis and Aggregation, Recursive Queries.

Tickets: € 2990,— (plus 20% VAT). Full content, all dates and enrollment ⇗

May 2020

Mai 12 — Eindhoven, The Netherlands

DB2 Symposium

The Join Rule of Indexing (full day training)

Good performance of a row oriented relational database depends on indexes. Without indexes every SQL becomes a table scan and performance would be horrible. Markus Winand, who is the author of “SQL Performance Explained”, has much experience in tuning SQL in many relational database. When it comes to good indexing Db2, Oracle, SQL Server, MySQL and many other databases are very much alike. Markus will present his “join rule of indexing” which is an easily applicable rule that improves performance of non-trivial queries by an order of magnitude regardless. This session is a guided tour from the basic of B-tree indexing to the ultimate goal of understanding the join rule of indexing. Although indexes can speed up select queries they are also overhead for insert, update and deletes. So Markus will also teach you a structured approach to design a minimum number of indexes which support all queries. This approach will also be used to proof the join rule of indexing.

This session is intended for developers who write SQL, DBA’s who assist the development team with tuning and quality assurance team members. This session does apply not only apply to Db2 but also to all other relational databases, so feel free to sign-up your Oracle, SQL Server and other colleagues.

Topics:

  • A brief introduction to B-tree indexes

  • Multi-column indexes and the relevance of the index column order

  • Reading and understanding execution plans

  • The “index demand” as a means to reason about index designs

  • Join algorithms and how they are affected by indexing

Tickets EUR 895 (early bird: EUR 695). Register now at the website of this event ⇗

May 15 — Stuttgart, Germany

PgConf.DE

Mehr als eine Abfragesprache: SQL im 21. Jahrhundert

“Great News–The Relational Model is Dead” war ein prominenter Kommentar als 1999 ein neuer SQL-Standard verabschiedet wurde. Der Hintergrund dieser provokanten Aussage war, dass sich SQL damit über das relationale Modell hinausentwickelt hat. Obwohl dieser Schritt damals viel diskutiert wurde, haben manche Datenbankhersteller Jahrzehnte gebraucht, um diesen Paradigmenwechsel zu vollziehen. Viele Entwickler haben bis heute nichts davon gehört.

Dieser Vortrag erzählt die Geschichte dieser revolutionären Änderung und stellt einige ausgewählte Funktionen von modernem SQL vor. Dabei wird deutlich, dass sich SQL in den letzten Jahrzehnten genauso geändert hat wie die Anforderungen, die an moderne Softwareentwicklung gestellt wird.

Event website ⇗

September 2020

September 28-October 2 — Vienna, Austria

5-day SQL-Training (Englisch)

Performance and Modern SQL Training (Englisch)

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.

Topics: SQL Performance (indexing), SQL Reloaded (from Join to NULL), Analysis and Aggregation, Recursive Queries.

Tickets: € 2990 (plus 20% VAT). € 500 early bird discount! Full content, all dates and enrollment ⇗

Connect with Markus Winand

Markus Winand on LinkedInMarkus Winand on XINGMarkus Winand on Twitter