IT- und Datenkompetenzen, Fokus 2: SQL @ fdm.nrw - 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:
- 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. 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:
- 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.
Contact: Please email muellerr@zbmed.de 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.
Surveys
Please be sure to complete these surveys before and after the workshop.
Schedule
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 |
Syllabus
Introduction to SQL
- Introduction to SQL
- Selecting and sorting data
- Filtering, Ordering and Commenting
- Aggregating & calculating values
- Joins and Aliases
- Saving queries
- Reference...
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.