Caltech Library Workshop – Databases and SQL, Part 2

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 14 & Thursday November 16, 2023.

Where: Online via Zoom

Curriculum:
Tue, 11/14: SQLite command line and data browser, data selecting, sorting, duplicating, filtering, calculations, data aggregation, joining data tables
Thu, 11/16: 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 ([email protected]).

Dates & Times:11:45am - 1:15pm, Tuesday, November 14, 2023
11:45am - 1:15pm, Thursday, November 16, 2023
Location:Zoom Session (Online)Categories:Classes

Registration is required. There are 28 spaces available.