SQL boot camp *pre-registered attendees only

  • Event: 2018 IRE Conference
  • Speakers: Jaimi Dowdell of Reuters; Jennifer LaFleur of Investigative Reporting Workshop
  • Date/Time: Saturday, Jun. 16 at 9:00am
  • Location: Coral C
  • Audio file: No audio file available.

Skill level: intermediate

If you flip over pivot tables, but wish you had more data tools, this session is for you. Structured Query Language, or SQL, can help you find patterns in millions of records, help you join databases and make you sound extra cool when you talk with your news nerd friends. In addition to learning these skills, you’ll learn the song that will help you remember these skills.

This class will be taught by two experienced data reporters and former IRE training directors, and materials will include the IRE Computer Assisted Reporting boot camp binder, full of exercises, cheat sheets and tips to help you boost your data analysis and storytelling skills. We will use a free database manager that can be easily installed and used on any computer.

Preregistration is required and seating is limited. Laptops will be provided for the training.

Workshop prerequisites: The only prerequisites are a reasonable comfort level with using a spreadsheet and the love of music. No previous SQL skills necessary.

NOTE: Registration is required for this session. Click here to sign up.

Speaker Bios

  • Jaimi Dowdell is a data journalist for Reuters. Previously she was training director for Investigative Reporters and Editors and data editor for the St. Louis Post-Dispatch. @JaimiDowdell [email protected]

  • Jennifer LaFleur is the Investigative Reporting Workshop's data editor and teaches at American University. She previously was a senior editor at Reveal from The Center for Investigative Reporting, where she managed a team of data journalists, investigative reporters and fellows. She is the former data journalism director at ProPublica and has held similar roles at newspapers. She is a former IRE training director and serves on IRE's board.

Related Tipsheets

No tipsheets have yet been uploaded for this event.