Joining and advanced operations in SQLite
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.
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
No tipsheets have yet been uploaded for this event.