Node Rest API Project for the Chinook Database

This project is based on the Chinook database, which is used as a sample database for learning SQL.

Here are the starter files for the project

  1. Setting Up the Project
  2. The Database
  3. Genre Routes and Controllers
  4. Genre Model
  5. Genre Data Service
  6. Finishing the Genre Routes

Links to resources:

  1. Software design principles
  2. Overview of HTTP (you read this last semester, but you may want to review it)
  3. REST APIs for non-techies
  4. REST API Design - Great Article!
  5. REST API Introduction
  6. REST API Design
  7. API Design Mistakes and How to Fix Them
  8. Structuring a REST API project in Express
  9. Setting up a connection pool with the mysql2 package
  10. Running Queries with mysql2
  11. mysql2 Documentation
  12. Routes and Controllers
  13. Separating Routes and Controllers
  14. JSON Web Tokens
  15. JWT Authentication
  16. JWT and Refresh Tokens
  17. Drawbacks to JWT
  18. API Security
  19. Securing JavaScript Apps
  20. Preventing SQL Injection Attacks
  21. Dealing with CORS in Express Apps
  22. Securing your app with Helmet
  23. Security Packages for Node