M
M

SQLite Lesson 2

This lesson is adapted from information provided by Investigative Reporters and Editors. Much of the following includes IRE practice data for the purpose of training. I've included additional info to further clarify difficult concepts and to make it a little bit fun.

March 20, 2016

bit.ly/cunySQLp2


Queries in the movies


Silvrback blog image
https://vimeo.com/159799705


For part 2 of this intro to SQL, we'll tackle how to group, sum and count. Part 3 will cover how to join.

Keeping with the data about US dams from the previous lesson, let's think of a few additional questions and then translate them into queries, this time . . .

Read More

SELECT needle FROM haystack;

Load a dataset into Firefox's SQLite Manager extension and start running queries to find the exact bits of info you need to concretely support your reporting.

May 09, 2015

Silvrback blog image

bit.ly/ire15sql1


Agenda


  1. Intro

  2. Explain Firefox's database management extension, SQLite Manager.

  3. Demo how to use the SELECT statement and the FROM command to find and view specific data.

  4. Demo how to filter data using the WHERE criteria command.

  5. Demo how to sort data using the ORDER BY command.

  6. Open floor for questions.

Hand off to Part . . .

Read More

Archive
  Subscribe by Email and Never Miss a Post