Compiled Learning Objectives

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