databases

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:


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.