The Museum Library is closed from 12/21/24 to 1/21/25 due to facilities projects. Patrons will not be able to request materials or scans from the Museum Library's print collections, retrieve materials from the stacks, or pick up or return books during this time. See our Service Alerts for more information.

  • Workshop

SQL Basics: Get Tables Into and Out of a Database​

Have database files to merge and extract for analysis? With this session, you'll be able to get the files you need, in a useable format, quickly via the lightweight DB Browser for SQLite.

This event has already occurred

calendar_month
September 3, 2024, 12:00pm - 1:15pm
location_on
Hybrid: Virtual and in-person at Yablon Financial Resources Lab, Room 244, Van Pelt-Dietrich Library Center
group
Open to Penn Students, Faculty, and Staff

Hosted by: Lippincott Library

Graphic of three stacked discs

Have database files to merge and extract for analysis? With this session, you'll be able to get the files you need, in a useable format, quickly via the lightweight DB Browser for SQLite. Learn how to interpret database documentation, load data into SQLite, combine data from multiple tables, and export tables for use outside of SQLite.

Activity expectations

  • Code-along with instructor: 35 min.
  • Solo/Group practice: 25 min.
  • Lecture: 15 min.

Prerequisite

Install DB Browser for SQLite on your machine OR extract the PortableApp on one of the Lippincott Library’s on-site computers.

Staff Information

Resources for Staff Committees