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
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 09, 2015
bit.ly/ire15sql1
Agenda
Intro
Explain Firefox's database management extension, SQLite Manager.
Demo how to use the
SELECTstatement and theFROMcommand to find and view specific data.Demo how to filter data using the
WHEREcriteria command.Demo how to sort data using . . .