Event box

What & Who: Caltech Library is offering an introductory Databases and SQL workshop designed for researchers working with data. This hands-on workshop, spread over two days, will cover selecting, sorting and deduplicating data, creating subsets, calculating derivative data and data aggregations, data formats, and accessing databases from Python programs. The workshop is designed to complement the Managing Data with Pandas workshop.

When: Tuesday November 29 & Thursday December 1, 2022.

Where: Online via Zoom

Curriculum:
Tue, 11/29: SQLite command line and data browser, data selecting, sorting, duplicating, filtering, calculations, data aggregation, joining data tables
Thu, 12/1: data formats, creating and modifying tables, programming with Python

Daily schedule:
11:45am-12:00noon: Setup, discussion, troubleshooting (as needed, optional)
12:00noon-1:15pm: Instruction (approximately 15 mins at end for optional review, discussion, troubleshooting)

Registration: This event is open to the Caltech community.  Please register using the link below.

For more information: If you have any questions about the workshop please contact the Library (library@caltech.edu).

Dates & Times:
11:45am - 1:15pm, Tuesday, November 29, 2022
11:45am - 1:15pm, Thursday, December 1, 2022
Location:
Categories:
Classes
Registration has closed. (This event has to be booked as part of a series)

Event Organizer

Stephen Davison