# Learning Outcomes

## Databases

* [ ] We can design and document a database schema
* [ ] We can normalize our data to reduce duplication
* [ ] We can create a relational database
* [ ] We can create tables within the database
* [ ] We can link a record in one table to a record in another
* [ ] We can link a record in one table to multiple records in another
* [ ] We can link multiple records in one table to multiple records in another
* [ ] We can deploy a PSQL database locally on our own machine
* [ ] We can deploy a PSQL database to a live server
* [ ] We can set up separate environments for production and testing
* [ ] We can use PSQL to manage Postgres from the command line

## SQL

* [ ] We can create, read update and delete from our database using SQL queries
* [ ] We can sort and filter data using SQL queries
* [ ] We can use joins to access related data in different tables
* [ ] We can use query parameters to avoid SQL-injection vulnerabilities

## Node

* [ ] We can handle database errors on our server without crashing

## Software Architecture

* [ ] We can draw a diagram representing the flow of our application
* [ ] We can follow a consistent pattern for naming our folders, files and variables

## Testing

* [ ] We can create a separate database for testing
* [ ] We can test that our database access works correctly