> For the complete documentation index, see [llms.txt](https://prof-rossetti.gitbook.io/intro-to-python/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://prof-rossetti.gitbook.io/intro-to-python/units/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. :smiley\_cat:

## Discussions and Notes

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

## Activities and Exercises

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