Library services during winter break: Van Pelt-Dietrich Library Center will be closed on 12/25 and on 1/1-1/2, and will be open all other weekdays between 12/25 and 1/1. All other libraries will be closed from 12/25 to 1/4. Circulation of books and materials, as well as other services, will also be affected. See our Service Alerts for more details. 

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.

Maps and More

Campus Libraries Map

Staff Information

Resources for Staff Committees