Welcome to SQL for accountants: understanding the beast via SpreadSheets

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
Language: English
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‎),