SQL for Librarians

Key Info
Description - a brief synopsis, abstract or summary of what the learning resource is about: 

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. DB Browser for SQLite (https://sqlitebrowser.orgneeds to be installed before the start of the training. The tutorial covers:
1. Introduction to SQL
2. Basic Queries
3. Aggregation
4. Joins and aliases
5. Database design supplement
Exercises are included with most of the sections.

Authoring Organization(s) Name: 
Library Carpentry
License - link to legal statement specifying the copyright status of the learning resource: 
Creative Commons Attribution 4.0 International - CC BY 4.0
Access Cost: 
No fee
Primary language(s) in which the learning resource was originally published or made available: 
English
More info about
Keywords - short phrases describing what the learning resource is about: 
Data coding
Data handling
Data management
Structured Query Language (SQL)
Publisher - organization credited with publishing or broadcasting the learning resource: 
Library Carpentry
Media Type - designation of the form in which the content of the learning resource is represented, e.g., moving image: 
Interactive Resource - requires a user to take action or make a request in order for the content to be understood, executed or experienced.
Contact Organization(s): 
Library Carpentry
Educational Info
Purpose - primary educational reason for which the learning resource was created: 
Instruction - detailed information about aspects or processes related to data management.
Learning Resource Type - category of the learning resource from the point of view of a professional educator: 
Lesson - detailed description of an element of instruction in a course, [could be] contained in a unit of one or more lessons, and used by a teacher to guide class instruction. Example: presentation slides on a topic.
Target Audience - intended audience for which the learning resource was created: 
Data professional
Librarian
Intended time to complete - approximate amount of time the average student will take to complete the learning resource: 
More than 1 hour (but less than 1 day)