- NodeJS Web API with KNEX and Express (15 min)
- https://fullstackopen.com/en/part3/node_js_and_express#rest up until the
The Visual Studio Code REST clientsection (15 min) - REST principles in API design https://stackoverflow.blog/2020/03/02/best-practices-for-rest-api-design/
- Familiarise yourself with the Knex Cheatsheet (especially Select, Scheme and Modifying sections)
- https://jsonplaceholder.typicode.com/ - Free API for testing and prototyping. (5 min)
- Read an overview of REST API design principles, focusing on resources, routes, and HTTP methods. For example: https://medium.com/extend/what-is-rest-a-simple-explanation-for-beginners-part-1-introduction-b4a072f8740f (10–15 min)
- Skim a short OpenAPI/Swagger introduction so you recognise the main parts of a spec. For example: https://swagger.io/docs/specification/basic-structure/ (10–15 min)
- Read about input validation patterns in Express (you do not need to use a specific library, just understand the concepts). For example: https://express-validator.github.io/docs/ (10–15 min)
- Read about SQL injection and why parameterised queries are important. For example: https://owasp.org/www-community/attacks/SQL_Injection (10–15 min)