YAPC::NA 2014 • Orlando, FL

SQL for accountants: understanding the beast via SpreadSheets

By Peter Rabbitson (‎ribasushi‎) from drinkers.pm
Date: Tuesday, 24 June 2014 09:00
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: