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.