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.
Before You Start:
You will need to install DB Browser for SQLite and download the doaj-article-sample database. See Setup for instructions and further information.
| 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. Ordering and commenting |
What is the order of execution in SQL queries?
How can you organize and comment more complex SQL queries? |
| 01:20 | 5. Aggregating & calculating values |
How can we aggregate values in SQL for reports?
Can SQL be used to make calculations? |
| 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. Creating tables and modifying data | How can I create, modify, and delete tables and data? |
| 04:05 | 10. Other database tools | Are there other database tools that I can use besides DB Browser and SqliteOnline? |
| 04:10 | 11. Extra challenges (optional) | Are there extra challenges to practice translating plain English queries to SQL queries? |
| 04:45 | 12. Good Style | What is good SQL Style, and how can I abide by SQL conventions? |
| 04:55 | Finish |
The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.