Library Carpentry Workshop - ONLINE

Jan 20-24, 2025

09:30 - 12:00

Instructors: Silvia Di Giorgio, 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.

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:

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 victoria.yan@embl.de to register for the event.

ZB MED


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.


Surveys

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

Pre-workshop Survey

Post-workshop Survey


Schedule

Day 1

09:30 Introduction
9:45 Intro to SQL
10:30 Break
10:45 SQL
11:50 Wrap Up and Feedback
12:00 End

Day 2

09:30 SQL
10:30 Break
10:45 The Unix Shell
11:50 Wrap Up and Feedback
12:00 End

Day 3

09:30 Unix Shell
10:30 Break
10:45 Unix Shell
11:50 Wrap Up and Feedback
12:00 End

Day 4

09:30 Python
10:30 Break
10:45 Python
11:50 Wrap Up and Feedback
12:00 End

Day 5

09:30 Python
10:30 Break
10:45 Python
11:50 Wrap Up and Feedback
12:00 End

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.

The Bash Shell

Bash is a widely used shell that allows you to perform simple tasks more quickly. Instructions for setup can be found in the lesson.

Python

Python is a popular language for research and is also suitable for general programming. A guide is available in the lesson.