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