Getting started with SQL

  • Event: 2016 CAR Conference
  • Speaker: Malik Singleton of CUNY Graduate School of Journalism
  • Date/Time: Friday, Mar. 11 at 9:00am
  • Location: Denver V
  • 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 the Firefox SQLite Manager.

This session will be most useful if: You have some experience working with data in columns and rows, in spreadsheets or database managers.

Speaker Bios

  • Malik Singleton teaches interactive data reporting at CUNY Graduate School of Journalism and also trains faculty in instructional technology at NYU. He has worked in various newsrooms, including TIME.com, Crain's New York Business, Black Enterprise Magazine, and LA Weekly Newspaper. He earned his BA from Morehouse College and his MS from Pace University.

Related Tipsheets

  • SELECT needle FROM haystack
    This tipsheet 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. You'll learn SQLite and the Firefox SQLite Manager.