Winning for you at work


Forgotten Password?
  1. Home
  2. Events
  3. Using SQL to Dig into Databases

Using SQL to Dig into Databases

When

Saturday 11 November 2017

9:00 - 9:30am registration

Download as vCalendar (for Microsoft Outlook etc.)

Import event to your Google Calendar

Where

Media Research Building (first floor) Department of Media and Communications Goldsmiths, University of London Lewisham Way London SE14 6NW

Details

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.

Course Outline
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.

TIMETABLE
 
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 info@tcij.org
Or make a bank transfer (details in the registration form)

More information on the The Centre for Investigative Journalism website

Price

Big organisations £114.00 (instead of £142.50) Freelancers and small organisations (9 people and fewer) - £102.00 (instead of £127.50)

Tags: , data journalism, professional training, Centre for Investigative Journalism, SLQ