SQL Workshop for KU Libraries

July 25, 2018

9:00 am - 12:00 pm

Instructors: Jamene Brooks-Kieffer

Helpers: Erika Dickey, Brad Engelbert, Jennifer Johnson, Miloche Kottman

General Information

This hands-on workshop draws on the Library Carpentry SQL lesson to introduce manipulating relational databases using this powerful query language. The Carpentries aim to help researchers get work done in less time and with less pain by teaching basic research computing skills. Increasingly, library professionals work in contexts that can benefit from these same skills. For more information on the Library Carpentry curriculum, please see "Library Carpentry: software skills training for library professionals". Participants will be encouraged to help one another and to apply what they have learned to their own work problems.

Who: This workshop is offered for KU Libraries employees. You don't need to have any previous knowledge of the tools that will be presented at the workshop.

Where: Watson Library Room 455, 1425 Jayhawk Boulevard, Lawrence, KS 66045. Get directions with OpenStreetMap or Google Maps.

When: July 25, 2018. Add to your Google Calendar.

Equipment: Participants will be using DB Browser for SQLite installed on KU Libraries' laptop computers running Windows 10. To install DB Browser for SQLite on a personal computer, follow the instructions below. Participants are required to abide by The Carpentries' Code of Conduct.

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 jamenebk@ku.edu for more information.


Schedule

Wednesday, July 25, 2018

09:00 Introductions
09:15 Basic queries
10:00 Aggregation
10:45 Break
11:00 Joins and Aliases
11:45 Discussion
12:00 END
Afterward Reference...

Notes

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


Setup

To install DB Browser for SQLite on a personal computer, follow the instructions described below. For installation on your work computer, you may need to arrange Windows administrative permission with your supervisor.

DB Browser for SQLite

SQL is a specialized programming language used with databases. We use DB Browser for SQLite, a graphical user interface for the SQLite database manager. Follow the link to install DB Browser for SQLite and select the installer for your system. This application comes with SQLite, so you won't need to install SQLite separately.

Note that on Windows, the PortableApp download is recommended as the regular version may take a long time to install on certain systems.