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 find and tell stories with data (and sometimes documents, too). She previously was reporter and editor at The (Nashville) Tennessean, Texas Watchdog and the Washington (D.C.) Examiner. She's on Twitter at @jpeebles.
No tipsheets have yet been uploaded for this event.