SQL for accountants: understanding the beast via SpreadSheets
Source: YAPC::NA 2014 on the 2014-06-24.
Speaker: Peter Rabbitson (ribasushi)
In order to enjoy this talk you do not need to know Perl, nor SQL, nor do you need to be an accountant.
This is a basic-to-advanced crash-course in SQL syntax and concepts. We will cover most of the road from speaking basic CRUD SQL, through joins, resultsets and subqueries all the way to weirdness like relational division. All of this will happen without looking at any perl code (yes, this is not a DBIx::Class talk :)
Even if you are a seasoned SQL veteran some of the presented techniques will no doubt surprise you, or at least make you roll your eyes.