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