Picture of Markus Winand

Conferences offer a great variety of topics.

SQL should not be missing.

Markus Winand at Conferences

September 2018

September 17-21 — Vienna, Austria

My Advanced SQL Training

A Training for Seasoned Developers and Analysts

In our data-driven world, the ability to process data has become very crucial for every company. Unfortunately, many developers and analysts still use SQL as it was taught 25 years ago—because most courses are still based on SQL-92. This 5-day training is the ideal way to turn outdated SQL-92 knowledge into modern SQL know-how.

The contents of the course is based on the recurring problems I have observed in my training and consulting assignments over the past nine years. It provides proven solutions to common requirements.

  • SQL-Performance Kick-Start: Because in-depth indexing know-how is crucial.

  • SQL Reloaded: Essential basics that people are often afraid to ask.

  • Analysis and Aggregation: Versatile techniques everybody should understand.

  • Recursion: Advanced algorithms implemented in pure SQL

Ticket: € 2988,— (tax incl.) for five days with catering. Check it out and register now ⇗

September 25-27 — Mainz, Germany

BASTA!

Modernes SQL: Evolution eines Dinosauriers

SQL hat sich in den letzten Jahren erheblich weiterentwickelt. Denn das rein relationale Dogma wurde bereits im Jahr 1999 aufgegeben. Es folgte eine stetige Erweiterung um praktikable Lösungen für Probleme, die mit der relationalen Algebra nur sehr umständlich zu lösen sind. Heute kann man mit SQL sogar in so manchem NoSQL-System sehr komplexe Auswertungen schneller, effizienter und vor allem korrekter umsetzen, als mit anderen Programmiersprachen. Seit SQL-92 hat sich einiges getan!

Tickets from € 440,— (single day with early bird discount until May 3rd) to € 2349,— (5 days full price). My (german) talk.

September 26-28 — Krakow, Polen

DevConf 2018

Modernes SQL: Evolution of a dinosaur

SQL has evolved considerably in recent years. The purely relational dogma was already abandoned in 1999. What followed was continuous extension through the incorporation of handy features to address problems that are hard to solve with relational algebra. Today, SQL is Turing complete, can process graphs, has semantic understanding of XML and JSON, is able to automatically keep historic versions, can analyze time series using regular expressions and much more.

This session walks through the SQL standards from 1999 to the current version of 2016. It demonstrates some selected features on the basis of common problems and compares the traditional SQL-92 solution to the modern SQL approach. Of course, the presentation also shows how long these features are supported by various databases so that you immediately know whether the shown solutions work in your environment or not.

In this session, developers and software architects of all levels gain a better understanding where SQL is today so that they are able to make more educated decisions. A lot has happened since SQL-92!

Ticket from PLN 499,— to PLN 899,—. Conference page ⇗

October 2018

October 5-6 — Zagreb, Croatia

WebCamp Zagreb 2018

Modernes SQL: Evolution of a dinosaur

Most developers use SQL like 25 years ago. A lot has changed since then. Modern SQL makes every developer's life easier.

SQL has evolved considerably in recent years. The purely relational dogma was already abandoned in 1999. What followed was continuous extension through the incorporation of handy features to address problems that are hard to solve with relational algebra. Today, SQL is Turing complete, can process graphs, has semantic understanding of XML and JSON, is able to automatically keep historic versions, can analyze time series using regular expressions and much more.

This session walks through the SQL standards from 1999 to the current version of 2016. It demonstrates some selected features on the basis of common problems and compares the traditional SQL-92 solution to the modern SQL approach. Of course, the presentation also shows how long these features are supported by various databases so that you immediately know whether the shown solutions work in your environment or not.

In this session, developers and software architects of all levels gain a better understanding where SQL is today so that they are able to make more educated decisions. A lot has happened since SQL-92!

Ticket: 600kn. My talk ⇗

October 27 (Sat) — Munich, Germany

SQL Saturday #772

Epidemic Plague: Superficial Indexing

Proper indexing is a very time and cost-effective way to improve SQL performance. Yet hardly anyone gets it right or knows how different ways to write a query affects indexing and performance. In this session I'll explain why this knowledge is sparse and what developers can do about it. Finally we will go through the most important indexing mistakes by example and discuss them during a short live quiz with the audience.

Free registration required. Conference Website ⇗

October 28 (Sun) — Prague, Czech Replublic

phpCE

Modern SQL: Evolution of a dinosaur

SQL has evolved considerably in recent years. The purely relational dogma was already abandoned in 1999. What followed was continuous extension through the incorporation of handy features to address problems that are hard to solve with relational algebra. Today, SQL is Turing complete, can process graphs, has semantic understanding of XML and JSON, is able to automatically keep historic versions, can analyze time series using regular expressions and much more.

This session walks through the SQL standards from 1999 to the current version of 2016. It demonstrates some selected features on the basis of common problems and compares the traditional SQL-92 solution to the modern SQL approach. Of course, the presentation also shows how long these features are supported by various databases so that you immediately know whether the shown solutions work in your environment or not. Teaser: MySQL and MariaDB have got huge updated lately.

In this session, developers and software architects of all levels gain a better understanding where SQL is today so that they are able to make more educated decisions. A lot has happened since SQL-92!

Ticket: €240-€280 for two conference days. Conference Website ⇗

December 2018

December 11 (evening) — Düsseldorf, Germany

Web Engineering Düsseldorf

Modern SQL: Evolution of a dinosaur

SQL has evolved considerably in recent years. The purely relational dogma was already abandoned in 1999. What followed was continuous extension through the incorporation of handy features to address problems that are hard to solve with relational algebra. Today, SQL is Turing complete, can process graphs, has semantic understanding of XML and JSON, is able to automatically keep historic versions, can analyze time series using regular expressions and much more.

This session walks through the SQL standards from 1999 to the current version of 2016. It demonstrates some selected features on the basis of common problems and compares the traditional SQL-92 solution to the modern SQL approach. Of course, the presentation also shows how long these features are supported by various databases so that you immediately know whether the shown solutions work in your environment or not.

In this session, developers and software architects of all levels gain a better understanding where SQL is today so that they are able to make more educated decisions. A lot has happened since SQL-92!

Free registration required. Event yet to be announced on meetup.com ⇗

December 12 — Frankfurt, Germany

IT-Tage

Oracle Row Pattern Matching: Datenanalyse auf neuem Level

Das Erkennen von Mustern in Zeitreihen wurde durch die MATCH_RECOGNIZE-Klausel in Oracle 12c erheblich vereinfacht. Leider ist diese Klausel unter Entwicklern noch wenig bekannt und wird daher kaum genutzt. Dieser Vortrag führt in das Thema ein und zeigt einige typische (und weniger typische) Anwendungen, die sich mit MATCH_RECOGNIZE wesentlich einfacher lösen lassen als mit anderen SQL-Funktionen.

Ticket: €693 (one day, early bird) - €1399 (three days, regular price). Conference Website ⇗

Connect with Markus Winand

Markus Winand on LinkedInMarkus Winand on XINGMarkus Winand on Twitter