VIDEO: An introduction to SQL for data journalists

The database query language SQL pops up in all sorts of places when you’re working with data — especially big data — and can be a very useful way to query data in spreadsheets, APIs and coding. This video, made for students on the MA in Data Journalism at Birmingham City University, explains what SQL is, the different places you will come across it, and how to get started with SQL queries.

You’ll find related resources and tutorials in the repo here.

UPDATE: Thanks to Tony Hirst in the comments for pointing me to his post about browser-based SQL tools.

This video is shared as part of a series of video posts.

This entry was posted in data journalism, online journalism and tagged , , , on by .
Unknown's avatar

About Paul Bradshaw

Paul teaches data journalism at Birmingham City University and is the author of a number of books and book chapters about online journalism and the internet, including the Online Journalism Handbook, Mobile-First Journalism, Finding Stories in Spreadsheets, Data Journalism Heist and Scraping for Journalists. From 2010-2015 he was a Visiting Professor in Online Journalism at City University London and from 2009-2014 he ran Help Me Investigate, an award-winning platform for collaborative investigative journalism. Since 2015 he has worked with the BBC England and BBC Shared Data Units based in Birmingham, UK. He also advises and delivers training to a number of media organisations.

1 thought on “VIDEO: An introduction to SQL for data journalists

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.