SQL (Structured Query Language) is one of the most useful tools in the data journalism tool belt. It’s a pretty simple language that does something pretty powerful: it lets you communicate with your database and spell out exactly the questions you want to ask about your data. Using the lightweight SQLite database manager, we’ll focus on queries that can be used in many different database programs. Join us for a gentle introduction to SQL that will convince you this stuff isn’t so hard. This is the first of three SQL sessions using SQLite.
Suggested Technical Experience: Familiarity with spreadsheets will be useful, but no previous database experience or other technical knowledge required.
Troy Thibodeaux leads the data journalism team at The Associated Press. The data team works with reporters and editors across AP, building software, analyzing and visualizing data, to tell stories in word and pixel. They also manage the data sharing network, which has helped news organizations across the U.S. localize important data stories. He lives in New Orleans with his family and a new dog, and like most New Orleanians, he loves to talk about the place.
No tipsheets have yet been uploaded for this event.