SQL 1: Exploring data (repeat)
Learning to manipulate data is a bit like learning a new language. Actually, it is a language, called structured query language (SQL). This session is an introduction to using SQL to zero in on your data by viewing slices and chunks of it and putting it into a useful order so you can spot the stuff you need to get started toward a story. We'll use SQLite and DB Browser, a free database manager.
This session is good for: People with some experience working with data in columns and rows, in spreadsheets or database managers.
Fedor Zarkhin is a data reporter at The Oregonian. His most recent project identified people seriously harmed by a botched $27 million plan to move mentally ill residents out of locked facilities. He has also written about senior care, asbestos, and a decades-old whale explosion. Fedor prefers to analyze data using the Python library pandas, but he's not above a quick pivot table in Excel or a group by in MySQL. @fedorzarkhin
No tipsheets have yet been uploaded for this event.