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
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 . . .
SELECT needle FROM haystack;
Load a dataset and run queries to find the info you need to support your reporting.
May 10, 2015
Explain Firefox's database management extension, SQLite Manager.
Demo how to use the
SELECTstatement and the
FROMcommand to find and view specific data.
Demo how to filter data using the
Demo how to sort data using . . .