Picture of Markus Winand

Conferences offer a great variety of topics.

SQL should not be missing.

Events with Markus Winand and SQL

October 2019

October 1 — Amsterdam, The Netherlands

Percona Live Amsterdam

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.

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.

Tickets: from € 450,— (use discount code CMESPEAK-MARKUS for 20% off). Event website ⇗

October 16-18 — Milan, Italy

PgConf.EU

Be Inclusive: Welcome Non-key Columns in B-Tree Indexes

PostgreSQL 11 introduced the INCLUDE clause for b-tree indexes. The main intention of this clause is to enable Index Only Scans without including selected columns into the index key. But the INCLUDE clause has many other interesting capabilities that might be even more useful than the support of Index Only Scans.

This talk gives you a brief introduction into b-tree indexes, Index Only Scans and what the INCLUDE clause does. It demonstrates where cases the INCLUDE clause can be beneficial and discusses a few more subtle benefits that are not commonly known. Finally, the talk also shows the limits of the INCLUDE clause in PostgreSQL 11.

Tickets: € 360,—. Event website ⇗

October 24-25 — Hamburg, Germany

code.talks

Mehr als eine Abfragesprache: SQL im 21. Jahrhundert

SQL-92 war der letzte Standard, der auf die relationale Idee beschränkt war. Ab 1999 wurde SQL um nicht-relationale Operationen und Datenstrukturen erweitert. Obwohl dieser Schritt damals viel diskutiert wurde, dauerte es Jahrzehnte, bis die Datenbankhersteller dieses Paradigmenwechsel verdaut hatten. Viele Entwickler haben bis heute nichts davon gehört.

Das Jahr 2018 markiert aber den Wendepunkt. Mit dem Erscheinen von MySQL 8.0 hat auch die letzte der gängigen SQL-Datenbanken den Paradigmenwechsel vollzogen und unterstützt die wichtigsten nicht-relationalen Konzepte von SQL.

Dieser Vortrag gibt einen Überblick über die Evolution von SQL seit 1999 und stellt einige der neuen Funktionen anhand häufiger Anforderungen vor. Dabei wird auch aufgezeigt, wann diverse Hersteller begonnen haben, nicht-relationales SQL zu unterstützen. Letztendlich zeigt der Vortrag, dass sich SQL in den letzten Jahrzehnten genauso weiterentwickelt hat, wie die Anforderungen mit denen man in der Entwicklung zu tun hat.

Tickets from € 555,— (two free tickets to give away! Contact me). Event website ⇗

November 2019

November 4-8 — Antwerp, Belgum

Devoxx

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.

Tickets from € 575,— Event website ⇗

November 10 — Sofia, Bulgaria

Bulgaria PHP Conference (BGPHP)

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 from € 234,— Conference Website ⇗

November 28 — Vilnius, Lithuania

Big Data Conference

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.

Tickets from € 504,— Event website ⇗

March 2020

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). € 500 early bird discount! Full content, all dates and enrollment ⇗

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