•  

SQL

A session at WXG 2015

Some people enjoy writing SQL, but no one enjoys reading SQL. That's because most people write bad SQL. We'll start on how to write more legible SQL, add some simple tips for helping people follow along — such as using CTEs (Common Table Expressions) — and then look at how to ask the hard questions of your data without having to export and run some script in Ruby/Python/Other.

By the end you'll be able to do things like:

Compute deltas across periods directly in SQL
Query for things like perc 95/99
Generate random data for testing/sample apps directly in SQL
Document your SQL, which you should do just like your code

(All SQL will have a heavy Postgres slant, because well it's the best, but much can apply to other DBs too)

About the speaker

This person is speaking at this event.
Craig Kerstiens

Craig runs product for Heroku's ecosystem group which comprises their API, CLI, add-ons, and core languages

Sign in to add slides, notes or videos to this session

WXG 2015

England England, Guildford

25th September 2015

Tell your friends!

When

Date Fri 25th September 2015

Where

G Live

Short URL

lanyrd.com/sdqmrf

Official session page

wxg.co.uk/…craigkerstiens

View the schedule

Share

Topics

See something wrong?

Report an issue with this session