/databases

Session on databases, including concepts such as structured data, SQL, and exploring data.

Primary LanguagePythonCreative Commons Attribution Share Alike 4.0 InternationalCC-BY-SA-4.0

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.