General Information

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

• automate repetitive, boring, error-prone tasks
• create, maintain and analyze sustainable and reusable data
• work effectively with IT and systems colleagues
• better understand the use of software in research
• and much more...

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.

When: Jan 20-24, 2025. 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:

• The room is wheelchair / scooter accessible.
• Accessible restrooms are available.

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.

Registration for this event is fully booked.

---

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.

Report a Code of Conduct Incident

---

Collaborative Notes

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

---

Surveys

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

Pre-workshop Survey

Post-workshop Survey

---

Schedule

---

Syllabus

---

Setup

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 doaj-article-sample.zip 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.