Joining and advanced operations in SQLite

  • Event: 2015 CAR Conference
  • Speaker: Matt Kiefer of The Chicago Reporter
  • Date/Time: Saturday, Mar. 7 at 4:30pm
  • Location: M109
  • Audio file: No audio file available.

The final session of this workshop will focus on “join” operations. We'll take multiple data sets and learn how to combine their records on a shared key -- a simple yet powerful tool for exploring correlations while piecing together your story. This class will also introduce the SQLite command line interface, including importing/exporting data and basic scripting concepts to show how you can automate database tasks and queries.

Attendance at the earlier SQLite session is not required to participate in this session.

Speaker Bios

  • Matt Kiefer is the data editor for The Chicago Reporter, a non-profit newsroom that investigates issues of race and poverty. He's also the creator of FOIAMail, an open-source FOIA automation project. @matt_kiefer

Related Tipsheets

No tipsheets have yet been uploaded for this event.