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 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?|
The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.