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.
Prerequisites
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
sqlite3at the terminal command line. To exit type.exit.
Windows
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.