Joining and advanced operations in SQLite

  • Event: 2015 CAR Conference
  • Speaker: Matt Kiefer of Stanford University
  • 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 a John S. Knight Journalism Fellow at Stanford University, researching and prototyping automation tools to monitor civil and human rights. He's on leave from his job as data editor at the Chicago Reporter, a non-profit newsroom that investigates inequality. @matt_kiefer

Related Tipsheets

No tipsheets have yet been uploaded for this event.