# Preparation

## Tools Setup

If you haven't already, install the following tools:

* [DBeaver](https://dbeaver.io/download/), [SQlite Viewer - VSCode Extension](https://marketplace.visualstudio.com/items?itemName=qwtel.sqlite-viewer) or any other SQL client of your choice.
* (Optional) [SQLite](https://www.sqlite.org/download.html) if you want to practice using the command line.

## Reading List

Read/watch through this list of content before you come to the session:

* [Database Design - Phase 1 - Analysis](https://mariadb.com/docs/general-resources/database-theory/database-design/database-design-example-phase-1-analysis)
* [Database Design - Phase 2 - Design](https://mariadb.com/docs/general-resources/database-theory/database-design/database-design-example-phase-2-design)
* [Database Design - Phase 3 - Implementation](https://mariadb.com/docs/general-resources/database-theory/database-design/database-design-example-phase-3-implementation) - Don't implement the database, just read through the example.
* [What is a foreign key?](https://mariadb.com/docs/general-resources/database-theory/relational-databases-foreign-keys)
* [Databases resources from Foundation](https://program.hackyourfuture.dk/~/revisions/n2RGk5og1pvUUWu5OSlj/course-content/foundation/databases/week1/preparation)