Development

Back-End Development (Node.js, Express, PostgreSQL)

Design APIs and databases that power real applications.

Course roadmap
  1. 1

    Node.js

    Modules and npm · Async JavaScript · File system and environment variables

  2. 2

    Express

    Routing · Middleware · Validation and error handling · REST conventions

  3. 3

    PostgreSQL

    Tables, keys and relations · SQL queries and joins · Indexes · Using an ORM (Prisma)

  4. 4

    Production

    Authentication and password hashing · Logging · Deploying an API

Implementation steps
  1. Install Node.js, PostgreSQL and Postman.
  2. Design the tables for a small app (for example a library or task manager).
  3. Create the database and write the SQL to insert and query data.
  4. Build an Express API with CRUD endpoints on top of the database.
  5. Add sign-up and login with hashed passwords and JWT.
  6. Write a README documenting every endpoint and deploy the API.
Software to install