SQL Workshop

As a followup to our last workshop on election mapping, we will be running a workshop on Intermediate SQL since this is such a requested skill. This course will not be introducing the basic levels of SQL. To prepare, we highly recommend taking our first two courses on SQL and PostGIS in our Map Academy: http://academy.cartodb.com/courses/sql-postgis/

We will be doing SQL in PostgreSQL, the most beautiful open source implementation of the SQL standard. One of our favorite parts of Postgres is the inclusion of PostGIS (http://www.postgis.net), which allows one to do spatial analysis (!) within SQL.

This workshop will focus on:

• Aggregate functions and GROUP BY

• Subqueries

• Fun spatial queries

• Cool tricks

This workshop is being taught by Andy Eschbacher and Stuart Lynn, map scientists at CartoDB. Please bring a laptop!