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.

Prerequisites

You will need to install DB Browser for SQLite.

Schedule

Setup Download files required for the lesson
00:00 1. Introduction to SQL What is SQL?
Why is it significant?
What is the relationship between a relational database and SQL?
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.