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


Queries in the movies

Silvrback blog image

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 . . .

Read More

SELECT needle FROM haystack;

Load a dataset and run queries to find the info you need to support your reporting.

May 09, 2015

Silvrback blog image



  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 . . .

Read More

   Subscribe by email and never miss a post.

This update link alerts you to new Silvrback admin blog posts. A green bubble beside the link indicates a new post. Click the link to the admin blog and the bubble disappears.

Got It!