Build a Recruitment API with Express & PostgreSQL

The tech stack for this mission

Node.jsExpressPostgreSQLZodBruno

What you learn, checkpoint by checkpoint

1. Checkpoint A

   Design tables, keys and relationships, and write SQL with JOINs

   • Design tables for candidates, jobs and applications with primary keys and relationships
   • Write SQL: SELECT, INSERT, UPDATE, DELETE and JOIN
   • Query PostgreSQL from Node.js with the pg client

2. Checkpoint B

   Build Express routes and middleware for full CRUD over PostgreSQL

   • Set up an Express server with routing and middleware
   • Design clean REST endpoints for full CRUD
   • Test every endpoint in Bruno and use basic Bash in the terminal

3. Checkpoint C

   Validate with Zod, handle errors, and split routes, services and data access

   • Validate request data with Zod schemas
   • Return proper status codes and handle errors consistently
   • Separate routes, services and data access - your first real architecture