Skip to content
This is the repo for the GCDRI sessions on databases.
Branch: master
Clone or download
Pull request Compare This branch is 10 commits ahead, 1 commit behind GCDigitalFellows:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
images
sections
.gitignore
README.md
dbcheatsheet.md
nypl_search.py
nypldb.db
shortlink.pptx

README.md

Introduction to Databases

A database is a collection of data that is structured to allow for manipulation. This session will introduce one type of database, the relational database, using SQLite, a portable implementation often used in mobile phones and distributed systems. After completing this session, attendees will be able to create tables and insert, read, and delete data in an SQLite database using SQLiteStudio. Attendees will also learn to query a database using SQL statements executed in a Python script.

Introduction to databases
Building a database
Building tables
Inserting data into tables
Updating table fields
Foreign keys!
Challenge: Build more tables!
General database queries
Joins
Importing a csv file into a SQL table
More querying
Challenge: Use queries to summarize your data
Databases vs. Excel
SQL + Python = Awesome!

Requirements

SQLite (already present on OSX)
SQLiteStudio

Additional Resources

Fun Times with SQLite!
SQL designer
Importable NYPL items csv
SQL Cheatsheet

You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.