GIJC15 has ended
Welcome to GIJC15! We have more than 160 panels, workshops, and special events planned for the conference. Be sure to register so you can create a personalized schedule and better network with your colleagues. Unless marked Limited Capacity, sessions are open and you are free to come and go. 
Back To Schedule
Saturday, October 10 • 09:00 - 10:00
Data Track: Structured Query Language (SQL) for Reporters 1

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Get help with software downloading in the Data Pub Thursday 4.30-6.00 p.m.
All data journalists can benefit from learning Structured Query Language or SQL, the language behind database managers. Whether you're hunting for evidence in large databases, needing to mash data tables together, or building an interactive database for your news organization, SQL is a tool for making these data skills possible. This course introduces SQL with an emphasis on how it can help reporters manage data for deeper investigative dives into that data.

These sessions introduce the SQL model and cover the basics of writing SQL queries. Familiarity with spreadsheets is helpful but no experience with SQL or databases is assumed.

Attendees should install software before the session, and they can get installation help at the Data Pub Thursday between 4.30 p.m. and 6 p.m.

Microsoft Access is the way to start and it’s only available on Windows.
If not Access, the Windows users should either install SQL Server Express 2014 found here:https://www.microsoft.com/en-us/download/details.aspx?id=42299.

They should select ExpressAdv 32BIT\SQLEXPRADV_x86_ENU.exe for the correct 32-bit installer or ExpressAdv 64BIT\SQLEXPRADV_x64_ENU.exe for the correct 64-bit installer. If they’re not sure which to use, then have them install the 32-bit by default. The software is free but not open source.
Or they can go open source (and free) by installing PostgreSQL from herehttp://www.postgresql.org/download/.  From that page, there are both 32-bit and 64-bit installers. Once PostgreSQL is installed, they should next install Navicat on top of that found here: http://www.navicat.com/download/navicat-for-postgresql. They’ll have to use the 14-day trial version unless they want to purchase it outright.

For Mac users, we’re recommending PostgreSQL for Mac followed by Navicat on top of that. PostreSQL is found here http://www.enterprisedb.com/products-services-training/pgdownload#osx  and Navicat here: http://www.navicat.com/download/navicat-for-postgresql.

You can get installation help at the Data Pub Thursday between 3 p.m. and 4.30 p.m. 

avatar for David Donald

David Donald

Data Editor, Investigative Reporting Workshop
David Donald is Data Editor at the Investigative Reporting Workshop at American University and Data Journalist in Residence at AU's School of Communication. Previously, he has been Data Editor at the Center for Public Integrity and Training Director at Investigative Reporters and... Read More →
avatar for Luuk Sengers

Luuk Sengers

Investigative journalist and university lecturer, Story-Based Inquiry, Groene Amsterdammer
Luuk is an independent investigative journalist, lecturer and media trainer. For the leading Dutch magazine De Groene Amsterdammer he writes about the effects of corporate power on our environment and climate, based on data-analysis. He also teaches research skills, data journalism and interview techniques to professionals and students and helps media and NGOs organise and carry out investigative projects. He... Read More →

Saturday October 10, 2015 09:00 - 10:00 CEST
Birkebeiner 1 (Data Hands-On)

Attendees (0)