Changes coming to Books by Mail: Starting in fall 2025, Books by Mail items will only be shipped to addresses in the contiguous United States 50 miles or further from campus. We will make exceptions for students, faculty, and staff with disabilities. Learn more

Fisher restoration: Fisher Fine Arts Library is open and operating normally during ongoing exterior work. Find more details about this important restoration project.

  • 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.

Maps and More

Campus Libraries Map

Staff Information

Resources for Staff Committees