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