What I learned about SQL in 2018

Max Maischein — 45 minutes 🐪 🦋

This talk shows how to use SQL Window Functions (ISO SQL:2008) and how to use Common Table Expressions (CTE, ISO SQL:1999).

Using these two techniques, you can often avoid munging the query result afterwards. This potentially saves roundtrips between the program and the database.

The presentation assumes an intermediate familiarity with SQL. To get the most of the presentation, youshpuld be familiar with SELECT and JOIN. The Perl level is suitable for the beginner, but there will be very little Perl.

Talk tags
SQL 2008 DBI
Perl versions
🐪 Perl 5,  🦋 Perl 6
Target audience
Perl 5 programming, Perl 6 programming
Talk duration
45 minutes
Talk status
Related links


Talk announce