Databases and SQL
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
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
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@example.com).
11:45am - 1:15pm, Thursday, November 16, 2023