unit-5b.md

Unit 5b: Databases and Datastores

Learning Objectives

This unit provides optional reference material for students interested in exploring alternative, more advanced data storage solutions, including relational databases. 😺

Discussions and Notes

• Google Sheets:
  • The gspread Package
• Relational Databases (SQL):
  • The sqlite Module (for SQLite databases)
  • The psycopg Package (for PostgreSQL databases)
  • The pymysql Package (for MySQL databases)
  • The sqlalchemy Package (an ORM for various relational databases)
  • The bigquery Package (for Google BigQuery)
• Document-object Storage ("No SQL"):
  • The pymongo Package (for MongoDB databases)

Activities and Exercises

• Database Exercise - follow the sqlite module notes to connect to and query an example SQLite database!