IT- und Datenkompetenzen, Fokus 2: SQL @ - ONLINE

Mar 6, 2023

09:00 - 13:00

Instructors: Rabea Müller

Helpers: TBA

General Information

Library Carpentry is made by people working in library- and information-related roles to help you:

Library Carpentry introduces you to the fundamentals of computing and provides you with a platform for further self-directed learning. For more information on what we teach and why, please see our paper "Library Carpentry: software skills training for library professionals".

Who: The course is for people working in library- and information-related roles. You don't need to have any previous knowledge of the tools that will be presented at the workshop.

Where: Online. Get directions with OpenStreetMap or Google Maps.

When: Mar 6, 2023. Add to your Google Calendar.

Requirements: Participants must bring a laptop with a Mac, Linux, or Windows operating system (not a tablet, Chromebook, etc.) that they have administrative privileges on. They should have a few specific software packages installed (listed below).

Accessibility: We are committed to making this workshop accessible to everybody. The workshop organizers have checked that:

Materials will be provided in advance of the workshop and large-print handouts are available if needed by notifying the organizers in advance. If we can help making learning easier for you (e.g. sign-language interpreters, lactation facilities) please get in touch (using contact details below) and we will attempt to provide them.

Contact: Please email for more information.


Code of Conduct

Everyone who participates in Carpentries activities is required to conform to the Code of Conduct.This document also outlines how to report an incident if needed.

Collaborative Notes

We will use this collaborative document for chatting, taking notes, and sharing URLs and bits of code.


Please be sure to complete these surveys before and after the workshop.

Pre-workshop Survey

Post-workshop Survey


Day 1

09:00 Introduction
09:15 Intro to SQL
10:30 Break
10:45 SQL exercises
12:45 Wrap Up and Feedback
13:00 End


Introduction to SQL

  • Introduction to SQL
  • Selecting and sorting data
  • Filtering, Ordering and Commenting
  • Aggregating & calculating values
  • Joins and Aliases
  • Saving queries
  • Reference...


DB Browser for SQLite

You will need to install DB Browser for SQLite to complete these lessons. DB Browser for SQLite provides a graphical user interface for connecting to and interacting with a SQLite database. This application bundles SQLite, so you won’t need to install SQLite separately.
Note: on Windows, the PortableApp download is recommended as the regular version may take a long time to install on certain systems.

Download the data

To import data, you’ll need to open DB Browser for SQLite and download a zip file containing the data files for this tutorial.
1. Download the data files from Zenodo.
2. Open the zip file with the zip utlity on your machine and save the folder and files to a location where you can easily find them. For example, your Desktop.
3. Contained in the zip file are two files, doaj-article-sample.db and doaj-article-sample.db.sql. You can either open the database file (less steps) or import the SQL file (more steps).
You can find detailed instruction on the SQL Setup Page.