Advanced SQL for analysis

  • Event: 2016 CAR Conference
  • Speaker: Kendall Taggart of BuzzFeed News
  • Date/Time: Friday, Mar. 11 at 3:30pm
  • Location: Denver II
  • Audio file: No audio file available.

If you feel comfortable with the Structured Query Language basics that IRE teaches in its boot camps -- SELECT, FROM, WHERE, GROUP BY -- but are ready to see what else SQL can do, this session is for you. We will cover more advanced ways of manipulating and questioning data, such as UPDATE queries, joins, writing sub-queries, and other neat tricks.  We will use SQLite in the class.

This session will be most useful if: You are comfortable with counting and summing in SQL.

Speaker Bios

  • Kendall Taggart is reporter on the investigations team at BuzzFeed News. Previously, she was a reporter at The Center for Investigative Reporting/Reveal. She's worked on projects about bad charities, dangerous pesticides and the criminal justice system. @KendallTTaggart

Related Tipsheets

No tipsheets have yet been uploaded for this event.