Topconf Linz 2017

TRACK: Java & JVM

10 SQL Tricks That You Didn't Think Were Possible

SQL is the winning language of Big Data. Whether you're running a classic relational database, a column store ("NewSQL"), or a non-relational storage system ("NoSQL"), a powerful, declarative, SQL-based query language is what makes the difference. The SQL standard has evolved drastically in the past decades, and so have its commercial and open source implementations. However, most people in the Java ecosystem haven't noticed, and are thus using only 10% of their database's features. In this fast-paced talk, we're going to look at very peculiar, yet very interesting data problems and how we can solve them with SQL. We'll explore common table expressions, hierarchical SQL, table-valued functions, lateral joins, ordered-set aggregate functions, row value expressions, window functions, and advanced data types, such as XML and JSON. And we'll look at Oracle's mysterious MODEL and MATCH_RECOGNIZE clauses, devices whose mystery is only exceeded by their power. Most importantly, however, we're going to learn that everyone can write advanced SQL. Once you learn the basics in these tricks, you're going to love SQL even more.


See the presentation

Download and open PDF file

Lukas Eder

Founder and CEO
Data Geekery GmbH

date

2017-03-01

starts

13:40

ends

14:20

room

Ursulinensaal

level

Intermediate

topics

SQL, Big Data, Analytics, Awesome

OTHER TALKS YOU MIGHT BE INTERESSTED IN ...

track

starts

2017-03-01, 10:20

room

Ursulinensaal

track

starts

2017-03-01, 11:10

room

Ursulinensaal

track

starts

2017-03-01, 12:00

room

Ursulinensaal

track

starts

2017-03-01, 14:30

room

Ursulinensaal

track

starts

2017-03-01, 15:30

room

Ursulinensaal