SQL for Librarians

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.


You will need to install Firefox and SQLite to complete this lesson.


00:00 Introduction to SQL What is SQL? Why is it significant?
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.