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 Firefox and SQLite to complete this lesson.
| 00:00 | Introduction to SQL | What is SQL? Why is it useful? |
| 00:15 | Basic queries | How do you query databases using SQL? |
| 01:00 | Aggregation | How do you aggregate records in SQL? |
| 02:00 | Joins and aliases | Linking tables together and using shorthand |
| 03:00 | 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.