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: Gianni Ceccarelli (‎dakkar‎), Laurent Dami (‎dami‎), H.Merijn Brand (‎Tux‎), osfameron, Anton Berezin (‎Grrrr‎), Diego Kuperman (‎diegok‎), Steffen Winkler (‎STEFFENW‎), Alexander Hartmaier (‎abraxxa‎), steve mynott (‎itz‎), David Schmidt (‎davewood‎), Ahti Nurminen (‎ade‎), Julien Fiegehenn (‎simbabque‎), Amalia Aida, Dmitry Yaskolko (‎sotona‎), Radek Kotowicz, Rikus Goodell, Marc Egea i Sala (‎meis‎), Denis Kanchev, Kamen Naydenov (‎pau4o‎), Sabina Nenkova, Johnathan Swan,