# 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. :smiley\_cat:

## Discussions and Notes

* Google Sheets:
  * [The `gspread` Package](https://prof-rossetti.gitbook.io/intro-to-python/notes/python/packages/gspread)
* Relational Databases (SQL):
  * [The `sqlite` Module](https://prof-rossetti.gitbook.io/intro-to-python/notes/python/modules/sqlite) (for SQLite databases)
  * [The `psycopg` Package](https://prof-rossetti.gitbook.io/intro-to-python/notes/python/packages/psycopg) (for PostgreSQL databases)
  * [The `pymysql` Package](https://prof-rossetti.gitbook.io/intro-to-python/notes/python/packages/pymysql) (for MySQL databases)
  * [The `sqlalchemy` Package](https://prof-rossetti.gitbook.io/intro-to-python/notes/python/packages/sqlalchemy) (an ORM for various relational databases)
  * [The `bigquery` Package](https://prof-rossetti.gitbook.io/intro-to-python/notes/python/packages/bigquery) (for Google BigQuery)
* Document-object Storage ("No SQL"):
  * [The `pymongo` Package](https://prof-rossetti.gitbook.io/intro-to-python/notes/python/packages/pymongo) (for MongoDB databases)

## Activities and Exercises

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