Markus Winand teaches efficient SQL. He covers both aspects: the development time to accomplish a task using SQL as well as the runtime of the final solution. He also published the book “SQL Performance Explained“ and is currently working on his next book, which is being published on an ongoing basis at http://modern-sql.com/
Q. You’re speaking at Voxxed Days Bucharest in March. Tell us a bit about your session.
My session is about all the good things that were added to SQL in the past 25 years, but hardly anyone noticed. And that’s a lot: 130 named features to be precise. I’ll showcase the most useful ones.
Q. Why is the subject matter important?
SQL is one of the most common programming languages at all. Even NoSQL vendors are adding rudimentary SQL capabilities to their systems nowadays. If you are dealing with databases, you must know SQL. Yet many developers believe SQL-92 is still the latest release and use SQL like 25 years ago.
Q. Who should attend your session?
My session is for developers and architects coping with databases. Even if you are sucessfully using a NoSQL system, I guess you should at least know where SQL is today.
Q.What are the key things attendees will take away from your session?
You’ll get better solutions to common problems. The whole session is based on common use-cases and compares their legacy SQL solution to the modern SQL solution.
Q. Aside from speaking at Voxxed Days Bucharest, what else are you excited about for 2017?
I’m really excited about the 2016 release of the SQL standard—I’ll briefly cover one of the new features introduced: row pattern recognition. Besides that, I’m so happy that the next major releases of MySQL and MariaDB will support window functions—of course, I’ll explain them in my session.