Advanced SQL for analysis

  • Event: 2015 CAR Conference
  • Speaker: Elizabeth Lucas of Kaiser Health News
  • Date/Time: Saturday, Mar. 7 at 10:10am
  • Location: M105
  • 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, different types of joins, writing sub-queries, merging results from two queries, and other neat tricks. Some of this SQL is too advanced for Microsoft Access, so we will use MySQL in the class.

This session will be most useful if: You are comfortable with the counting, summing, in SQL and are familiar with joining tables.

Speaker Bios

  • Liz Lucas is the data editor at Kaiser Health News (KHN) and a member of the investigative team. Previously she worked at IRE as the NICAR Data Library director and trainer. She lives in St Louis. @eklucas

Related Tipsheets

No tipsheets have yet been uploaded for this event.