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 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
No tipsheets have yet been uploaded for this event.