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
Thursday, October 8 • 16:30 - 18:00
Data Pub: Download software for SQL

Sign up or log in to save this to your schedule and see who's attending!

Microsoft Access is the way to start. Of course, 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 here http://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.


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 Andy Lehren

Andy Lehren

Reporter, New York Times
Andrew W. Lehren is a Reporter at The New York Times, and has worked on a range of national, international, and investigative stories. He was one of the newspaper’s lead Reporters analyzing the Wikileaks trove of diplomatic cables, Afghanistan and Iraq war logs, and Guantanamo detainee dossiers. Highlights from those stories were compiled into a bestselling book, Open Secrets. He contributed to the Pulitzer Prize-winning series that examined... Read More →

Thursday October 8, 2015 16:30 - 18:00
Bagler'n Data-Pub

Attendees (11)