Tipsheets

Browse more 5,000 tipsheets from our national conferences and Watchdog Workshops on how to cover specific beats, conduct a great interview and learn countless tips on where to find the information you need.

Logged-in members can download any tipsheet, for free. Contact the Resource Center 573-882-3364 or [email protected] for questions.

Search results for "sql" ...

  • Interviewing your data with SQL

    If you flip over pivot tables, but wish you had more data tools, this tipsheet is for you. Structured Query Language, or SQL, can help you use powerful filtering functions, find patterns in millions of records and join multiple data tables.

    Tags: SQL; data analysis; data journalism; data reporting; computer-assisted reporting; Structured Query Language; programming;

    By Meghan Hoyer and Troy Thibodeaux

    2019

  • Which Coding Language Should I Learn?

    A slide deck explaining the differences between programming languages. The slide deck also outlines what programming languages are best for different goals.

    Tags: programming languages; coding; Python; SQL; R; JavaScript; beginner's coding; data journalism

    By Armand Emamdjomeh, Ryan Murphy, Caitlin Ostroff, Jennifer Peebles and Christine Zhang

    2019

  • What Coding Language Should I Learn?

    A tipsheet explaining the pros and cons of various programming languages. The tipsheet also explains what programming languages are best for different functions.

    Tags: JavaScript; Python; Programming; R; SQL; Coding Language

    By Caitlin Ostroff

    2019

  • An Introduction to VisiData

    VisiData is a free, open-source tool that lets you quickly open, explore, summarize, and analyze datasets in your computer’s terminal. VisiData works with CSV files, Excel spreadsheets, SQL databases, and many other data sources. https://jsvine.github.io/intro-to-visidata/

    Tags: datasets; visidata

    By Jeremy Singer-Vine

    2018

  • Advanced SQL

    If you feel comfortable with the Structured Query Language basics that IRE teaches in its boot camps — SELECT, FROM, WHERE, GROUP BY — but are ready to see what else SQL can do, this presentation is for you. It will cover more advanced ways of manipulating and questioning data, such as UPDATE queries, joins, writing sub-queries and other neat tricks. https://docs.google.com/presentation/d/e/2PACX-1vSLBba_AlxTUB-YKBjedfgNAR_T4OXYprjyGWATU9rJnk_ZyoC72uKXmr30i_Y6nwWDcttN4THnOllh/pub?start=false&loop=false&delayms=3000&slide=id.p

    Tags: slq; structured query language; data; manipulation

    By Jennifer Peebles

    2018

  • PostgreSQL Github repo

    Materials for the PostgreSQL hands-on class at NICAR 2018 in Chicago. https://github.com/anthonydb/postgresql-intro-nicar18

    Tags: postgresql

    By Anthony DeBarros

    2018

  • Digging Deep Into Data with SQL

    Structured Query Language, SQL for short and pronounced “sequel,” is the secret sauce of relational databases. Whether you’re talking high cost database engines such as Oracle and SQL Server or open-source products such as MySQL and PostgreSQL, they all rely on dialects of this same powerful language. Some of them have complex features that take months or years to master. But at their core is something remarkably simple: SQL.

    Tags: sql; data; databases; relational; mysql

    By Lauryn Schroeder; Jonah Newman; Daniel Wheaton; Ronald Campbell

    2017

  • Data Wrangling With Python

    This repository contains materials for "Data Wrangling With Python," a hands-on session presented at the 2017 Investigative Reporters and Editors NICAR conference in Jacksonville, Fla. The code covers basic import, transformation, and export of data from CSV files. Output formats include JSON and SQL table creation statements. https://github.com/anthonydb/data-wrangling-python-nicar-2017

    Tags: python; data; wrangling; import; transformation; export; sql; json

    By Anthony DeBarros

    2017

  • Interrogating data with SQL pt. 2

    These links will take you to an introduction and a tutorial used for a hands-on SQL session focusing on part two of Troy Thibodeaux's presentation on interrogating data with SQL. https://github.com/tthibo/SQL-Tutorial/blob/master/tutorial_files/part2.textile https://github.com/tthibo/SQL-Tutorial/tree/master/IRE2016/part2

    Tags: sql; data; analysis

    By Troy Thibodeaux

    2016

  • Interrogating data with SQL pt. 1 - tutorial

    These links will take you to an introduction and a tutorial used for a hands-on SQL session focusing on part one of Troy Thibodeaux's presentation on interrogating data with SQL. https://github.com/tthibo/SQL-Tutorial/blob/master/tutorial_files/part1.textile https://github.com/tthibo/SQL-Tutorial/tree/master/IRE2016/part1

    Tags: sql; data; analysis

    By Troy Thibodeaux

    2016