Advanced SQL: Working with dates, sub-queries and more
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.
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.
No tipsheets have yet been uploaded for this event.