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 data.

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 What is a query?
How do you query databases using SQL?
01:00 3. Aggregation What does aggregation mean?
How do you aggregate records in SQL?
02:00 4. Joins and aliases How do I join two tables if they share a common point of information?
What are aliases good for?
03:00 5. Saving queries How can I save a query for future use?
How can I remove a saved query?
03:30 6. Other database tools Are there other database tools that I can use besides DB Browser and SqliteOnline?
03:35 7. Database Design (Draft) What is database design?
04:20 Finish

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