Bild von Markus Winand

Konferenzen bieten eine enorme Themenvielfalt.

Da darf SQL auch nicht fehlen.

Markus Winand spricht auf Konferenzen

September 2018

17.-21. September — Wien, Österreich

Mein „modern 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,— (inkl. USt) für fünf Tage mit Verpflegung. Alle Infos und Anmeldung ⇗

25.-27. September — Mainz, Deutschland

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 ab € 440,— (ein Tage, frühbucher bis 3. Mai) bis € 2349,— (5-Tage, Vollpreis). Mein Vortrag.

26.-28. September — Krakau, Polen

DevConf 2018

Modernes SQL: Evolution eines Dinosauriers

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!

Tickets ab PLN 499,— bis PLN 899,—. Zur Konferenz ⇗

Oktober 2018

5.-6. Oktober — Zagreb, Kroatien

WebCamp Zagreb

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. Mein Vortrag ⇗

27. Oktober (Samstag) — München, Deutschland

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.

Kostenlose Registrierung erforderlich. Zur Konferenz ⇗

27.-28. Oktober — Prag, Tschechien

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!

Eintritt: €240-€280 für zwei Tage Konferenz. Zur Konferenz ⇗

December 2018

11. Dezember (abends) — Düsseldorf, Deutschland

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!

Kostenlose Registeriung erforderliche. Wird noch auf meetup.com angekündigt ⇗

12. Dezember — Frankfurt, Deutschland

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.

Eintritt: €693 (ein Tage, Frühbucher) - €1399 (drei Tage, Vollpreis). Konferenz Webseite ⇗

Mit Markus Winand verbinden

Markus Winand auf LinkedInMarkus Winand auf XINGMarkus Winand auf Twitter