Compiled Learning Objectives

At the end of the sprint, you should be able to do the following things. Make sure to check you can do them all, and if not, go back and keep practicing until you can.

Communicating with the database using SQL

• Check the database connection
• Get query results from the database with Postman

Being More Selective

• Create an API endpoint that can add data to a database
• Validate data before adding it to a database
• Identify a risk of SQL injection attacks, and define one defence
• Create an API endpoint that retrieves data from a database with multiple parameters

CRUD operations with NodeJS and PostgreSQL

• Create an API endpoint that can create data in a database
• Create an API endpoint that can delete data from a database
• Create tables with a variety of column types and primary and foreign keys
• Define CRUD operations