The Penn Libraries has built a new, user-focused library catalog, with a simpler look and easier search features. Explore it at find.library.upenn.edu.

Home Link Icon
  • 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
RSVP

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.