Library Carpentry: SQL: Instructors' Guide


Tips and Tricks


Making a handout

To make a handout for this lesson, adapt/print from https://librarycarpentry.org/lc-sql/reference.


General notes of SQL

database (dā’tə-bās’) noun: “A collection of data arranged for ease and speed of search and retrieval by a computer”

— The American Heritage® Science Dictionary

Overall

Import CSV in SQLite

For instructors demonstrating the use of SQLite, Aaron Culich recommends using a Directory of Open Access Journals (DOAJ) example, importing a dataset CSV file from the CERN repository Zenodo. The example is below:

$ sqlite3 output.db
sqlite> .mode csv
sqlite> .import dataset-final-20160825-zenodo.csv
sqlite> .schema

Resources