Using SQL to Dig Into Databases

    When Excel is not enough for your data analysis - graduate to SQL! 
    #CIJCourses

    Ben Pimlott, PC lab 3/4
    Goldsmiths, University of London
     

    Goldsmiths University of London
    11 November 2017

    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. 

    Big organisations (10+ people) - £142.50
    Freelancers/small orgamisations (9 people and fewer) - £127.50
    Full-time students - £55
    Goldsmiths students: contact marina(at)tcij.org for Goldsmiths discount. 

    Please REGISTER HERE FIRST
    If you want to pay by PayPal - please see below. You can make a payment even if you do not have a PayPal account. 

    Course Outline

    You will be able to get 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. We’ll learn how to work the space, the main statements, how to join tables and how to update records. 
     
    Who it isn’t for: It s not recommended for those who are already coders or those with no knowledge of data journalism or with little experience working in a spreadsheet.
     
    Prior knowledge: be comfortable in Excel. You should be comfortable with basic maths, sorting, filtering and pivot tables.
    TIMETABLE
     
    Saturday 11th November
     
    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 / CAR, cross-border, 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).
     
    'Very knowledgable, but down-to-earth [trainer]. Communicated in a very accessible and humorous way. Gave great real world examples and tips.'
     
    Please REGISTER FIRST then make a payment. CIJ bank details can be found on the registration form. 
    Don't have a PayPal account? No worries! You can make a PayPal payment with a credit/debit card. Just click below. 

    Pay now