SQL 1: Exploring data (repeat)

  • Event: 2019 CAR Conference
  • Speaker: Fedor Zarkhin of The Oregonian/OregonLive
  • Date/Time: Saturday, Mar. 9 at 9:00am
  • Location: Salon 4
  • Audio file: No audio file available.

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.

Speaker Bios

  • 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

Related Tipsheets

No tipsheets have yet been uploaded for this event.