Ten SQL Tricks that You Didn’t Think Were Possible (Lukas Eder)

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 makes the difference. The SQL standard has evolved drastically in the past decades, and so have its commercial and open source implementations. In this fast-paced talk, we’re going to look at very peculiar and interesting data problems and how we can solve them with SQL. We’ll explore common table expressions, hierarchical SQL, table-valued functions, lateral joins, 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.

[@ruixue6955]

6:53 trick 1: everything is a table
8:25
9:30 trick 2: Data Generation with Recursive SQL
12:09 trick 3: running total calculations

[@jbucata]

Ten tricks listed at 6:24

[@sebbes333]

Ok, so SQL is Turing complete?! Now make an operating system with SQL! :D

[@KuriaNdungu]

Sound jumps back to the start at 1:20
it synchronizes back with image at 5:02

[@xk7830]

Kuria Ndungu vipi brathe

[@matthewiskra771]

Trying to follow with incomplete examples is frustrating. It would have been nice to have a link to ready-to-run SQL.
(I'm not at the end, so I'll withdraw this comment if links are at the end instead of in the description)

[@chadkrause6574]

most of these things I'd handle on the back end rather than the database side. very cool tricks but hard to pull off especially if you're a beginner like me. I do mainly web app development so things like displaying 0 instead of a negative is easier done in the front end or API than it is on the database. Plus, why should I waste computing time when I can make the client, who doesn't pay for computing time, do it?

[@lukas_eder]

Fair enough, but watch this talk and think again where you want to invest your time learning: th-cam.com/video/wTPGW1PNy_Y/w-d-xo.html

[@ebichu8126]

I think Lukas wants to demonstrate the power of SQL functionality which we can consider before we go into backend coding.

[@adlantls]

sequel is not one language but many. it's a specification implemented in different ways. All implementations are lingos not languages.
java is a language, it has one and only implementation, not specific to this or that database and migrating is almost effortless in java. Try to migrate sql procedures and feel hate for your dbms.

[@priyanshudebnath1418]

I want to like but the likes are 444 I don't want to ruin that

[@numbers638]

It's no more 444 💀

[@priyanshudebnath1418]

@@numbers638 I Know so in agony I roar

[@gregf9160]

SQL is Boolean Algebra. If you're doing anything outside of that constraint, you are almost certainly doing something wrong. In some of these examples, I think you're trying to be too clever.

[@MrMikomi]

You do what works, functionally and non-functionally.

[@RidingWithGerdas]

Sound quality is legit shit