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