Loading…
This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
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. 
View analytic
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 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. 


Speakers
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 Editors and the National Institute for Computer-Assisted Reporting. His work has received two Philip Meyer Awards for the best use of social science methods in... Read More →
avatar for Luuk Sengers

Luuk Sengers

Trainer, Lecturer, Investigative Journalist, Freelance journalist
Luuk Sengers Luuk Sengers is docent onderzoeksjournalistiek, onder meer aan de opleiding Internationale Research Journalistiek(IRJ). Daarnaast traint en adviseert hij professionals in het gebruik van onderzoekstechnieken. Samen met Mark Lee Hunter ontwikkelde Sengers de internationaal gewaardeerde Story-Based Inquiry methode, een systematische en snelle manier om onderzoek te doen.


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

Attendees (38)