Building on what you’ve learned in the first two sessions, we will introduce joins: a powerful feature of SQL that lets you combine the contents of multiple tables based on shared data. Combining information across multiple spreadsheets is tricky in Excel, so this is where SQL really starts to shine.
SQL was born to do data mashups, and this class will help you put them to work.
Suggested technical Experience: Anyone who attended SQLite II or who has familiarity with SELECT, aggregate functions and GROUP BY in SQL.
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.