SQL for accountants: understanding the beast via SpreadSheets
By Peter Rabbitson (ribasushi) from drinkers.pm
Date: Saturday, 23 August 2014 11:30
Duration: 50 minutes
Target audience: Beginner
Tags: clippy crud dbix::class_not rdbms relational sql
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.
Attended by: osfameron, Denis Kanchev, Dmitry Yaskolko (sotona), Laurent Dami (dami), H.Merijn Brand (Tux), Diego Kuperman (diegok), Julien Fiegehenn (simbabque), Sabina Nenkova, Radek Kotowicz, Alexander Hartmaier (abraxxa), Kamen Naydenov (pau4o), Marc Egea i Sala (meis), Anton Berezin (Grrrr), Amalia Aida, Rikus Goodell, Johnathan Swan, Ahti Nurminen (ade), steve mynott (itz), Gianni Ceccarelli (dakkar), David Schmidt (davewood), Steffen Winkler (STEFFENW),