Advanced SQL: Working with dates, sub-queries and more

  • Event: 2019 CAR Conference
  • Speaker: Jennifer Peebles of The Atlanta Journal-Constitution
  • Date/Time: Friday, Mar. 8 at 10:15am
  • Location: Salon 3
  • 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 date functions, writing sub-queries and other neat tricks. We will use SQLite in the class. 

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

Speaker Bios

  • Jennifer Peebles is a newsroom data specialist at the Atlanta Journal-Constitution, helping reporters get and tell stories with data (and sometimes documents). She has previously been a reporter and editor with The (Nashville) Tennessean, the Washington (D.C.) Examiner and the website Texas Watchdog. 

Related Tipsheets

No tipsheets have yet been uploaded for this event.