Reading period access: From April 30-May 12, access to the Van Pelt-Dietrich Library Center and the Fisher Fine Arts Library will be limited to PennCard holders and other Penn affiliates. See our Service Alerts for more information.

Books on the move: Materials on the fifth floor of the Van Pelt-Dietrich Library Center are being temporarily moved to our off-site storage facility. For your safety, please avoid browsing the fifth-floor stacks. See our Service Alerts for information about requesting books during the transition. 

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