Using SQL to Dig into Databases
WhenSaturday 11 November 2017
9:00 - 9:30am registration
Download as vCalendar (for Microsoft Outlook etc.)
Media Research Building (first floor) Department of Media and Communications Goldsmiths, University of London Lewisham Way London SE14 6NW
Using SQL to Dig into Databases: If you’ve already been bitten by the #data journalism bug, you should know that #SQL is like #Excel, but on steroids! It makes data crunching flexible, faster, safer and more sophisticated. It’s more like talking to a person than doing maths. This one day course will teach you all you need to know to start using SQL.
You will be able to get and answers from your data, report deeper and make tables talk to each other. This workshop is designed for intermediate data-journalism skills and entry-level programmers.
You should already be comfortable in Excel. You should be comfortable with basic maths, sorting, filtering and pivot tables.
It is not recommended for those who are already coders or those with no knowledge of data journalism or with little experience working in a spreadsheet.
9:00 - 9:30am Registration
9:30 - 10:00am Introductions: What is SQL and how can it help you?
10:00am - 12:30pm SQL Basics and constructing a query
12:30 - 1:15pm Lunch break
1:15 - 2:45pm Interviewing data with SELECT statements
2:45 - 4:00pm Joining tables for deeper reporting
4:00 - 5:30pm Updating tables, Q&A & how to continue learning (by doing)
About the trainer:
Crina Boroş is an investigative journalist reporting on HSBC leaks, UK and offshore money-laundering, Afghan victims’ compensation, women’s rights, EU lobbying, workers’ abuse, civil service transparency and accountability. Her work for Greenpeace's Energy Desk on fishing quotas was recently shortlisted for the 2017 Paul Foot award. She specialises in data journalism, freedom of information and undercover reporting. She has produced front-page headline-generating features, statistical analysis and watchdog reporting. She is a CAR (data journalism) trainer and member of Investigative Reporters and Editors (IRE).
What they said: "Very knowledgable, but down-to-earth [trainer]. Communicated in a very accessible and humorous way. Gave great real world examples and tips.'"
20% off for NUJ members
REGISTER HERE FIRST - please indicate that you are a member of the NUJ in the invoice question.
To pay: transfer the correct amount via PayPal to firstname.lastname@example.org
Or make a bank transfer (details in the registration form)
More information on the The Centre for Investigative Journalism website
Big organisations £114.00 (instead of £142.50) Freelancers and small organisations (9 people and fewer) - £102.00 (instead of £127.50)