Skip to content
Session on databases, including concepts such as structured data, SQL, and exploring data.
Branch: master
Clone or download
Pull request Compare This branch is 5 commits ahead of DHRI-Curriculum: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.
scripts
sections
.gitignore
LICENSE
README.md
dbcheatsheet.md
nypl_items.csv
nypldb.db
resources.md
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 database tables in an SQLite database using Python and SQL statements
  • Insert, read, and delete data
  • Understand the beginning of cleaning/tidying data

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


Session Leader: Ericka Christie
Based on previous work by Stephen Zweibel and Ian Phillips

Creative Commons License

Digital Research Institute (DRI) Curriculum by Graduate Center Digital Initiatives is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at https://github.com/DHRI-Curriculum. When sharing this material or derivative works, preserve this paragraph, changing only the title of the derivative work, or provide comparable attribution.

You can’t perform that action at this time.