SQL 1: Intro and filtering

  • Event: 2018 IRE Conference
  • Speaker: Pam Dempsey of The Midwest Center for Investigative Reporting
  • Date/Time: Thursday, Jun. 14 at 2:30pm
  • Location: Coral B
  • Audio file: No audio file available.

Learning to manipulate data is a bit like learning a new language. Actually, it is a language, called structured query language (SQL). This session is an introduction to using SQL to zero in on your data by viewing slices and chunks of it and putting it into a useful order so you can spot the stuff you need to get started toward a story. We'll use SQLite and DB Browser, a free database manager.

This session is good for: People with some experience working with data in columns and rows, in spreadsheets or database managers.

Speaker Bios

  • Pam Dempsey is the executive director of the Midwest Center for Investigative Reporting. She is an award-winning journalist who has done investigative reporting and editing on topics including agribusiness, migrant farm workers, health, housing and Native American government. Dempsey, who is an online, print and radio journalist, has developed community engagement programs and investigative reporting workshops. @pamelagdempsey

Related Tipsheets

No tipsheets have yet been uploaded for this event.