Library Carpentry: SQL

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 and download the doaj-article-sample database. See Setup for instructions and further information.

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. Selecting and sorting data What is a query?
How do you query databases using SQL?
How do you retrieve unique values in SQL?
How do you sort results in SQL?
00:35 3. Filtering How can I filter data?
01:05 4. Aggregating & calculating values How can we aggregate values in SQL for reports?
Can SQL be used to make calculations?
01:25 5. Ordering and commenting What is the order of execution in SQL queries?
How can you organise and comment more complex SQL queries?
01:40 6. Joins and aliases How do I join two tables if they share a common point of information?
How can I use aliases to improve my queries?
02:25 7. Saving queries How can I save a query for future use?
How can I remove a saved query?
02:55 8. Database design What is database design?
03:40 9. Other database tools Are there other database tools that I can use besides DB Browser and SqliteOnline?
03:45 10. Extra challenges (optional) Are there extra challenges to practice translating plain English queries to SQL queries?
04:20 Finish

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