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: Stephen Zweibel
Based on previous work by Stephen Zweibel and Ian Phillips
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.