Picture of Markus Winand

Conferences offer a great variety of topics.

SQL should not be missing.

Events with Markus Winand and SQL

October 2019

code.talks

October 24-25 — Hamburg, Germany

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 24 — Berlin, Germany

Workshop: Processing JSON in SQL

Half day workshop (12:30 - 16:30)

From Documents to Tables and Back: Processing JSON in SQL

Even though SQL started as a language to process relational data, SQL has evolved into a polyglot data processing language in the past decades. One of the more recent additions enables SQL to create and process JSON documents.

This workshop is an introduction to cope with JSON data in SQL. It provides the big picture on the features defined in the SQL standard but also explains how various SQL databases diverge from it and extend it.

To goal of this workshop is to learn how to use SQL to reduce and simplify the code needed to transform data from JSON into a tabular form and vice versa.

Ticket: € 190. Book here ⇗

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