SQL for Librarians

This Library Carpentry lesson introduces librarians to relational database management system using SQLite. At the conclusion of the lesson you will: understand what SQLite does; use SQLite to summarise and link databases.


You will need to install Firefox and SQLite to complete this lesson.

Linux and Mac OS x

SQLite command line tools come preinstalled on Linux and Mac OS x.

In order to check they are available type sqlite3 at the terminal command line. To exit type .exit.


On Windows download the Windows Installer Copy the file to a directory and open the directory using the windows command line. Type sqlite3.

For a more detailed explanation see this tutorial.


Setup Download files required for the lesson
00:00 1. Introduction to SQL What is SQL? Why is it significant?
00:15 2. Basic queries How do you query databases using SQL?
01:00 3. Aggregation How do you aggregate records in SQL?
02:00 4. Joins and aliases Linking tables together and using shorthand
03:00 5. Database design supplement What is SQL? Why is it significant?
03:15 Finish

The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.