DropoutDeveloper
Tools/Roadmap Generator/Backend Developer
Free curated roadmap

Backend Developer Roadmap

Build and run the API: HTTP, a web framework, a database, auth, and a deployed service.

16 Week192 h8 projects

Three free learning paths, in sequence. GitHub first for three weeks so version control is a reflex before anything else. Then the Node path for eight weeks: the runtime and core modules, Express routing and middleware, MongoDB and Mongoose, a REST API you build yourself, a real-time app with Socket.IO, and a deployment. SQL closes it out over five weeks, from your first SELECT through joins, subqueries, window functions, and designing a schema. The result is a backend portfolio with a live API, authentication, and a database you actually modelled rather than copied.

At ten hours a week this is about eighteen to twenty two weeks including the debugging time that no video shows. At twenty hours a week, roughly eleven to thirteen. Backend interviews lean harder on fundamentals than frontend ones, so plan for an extra month of reading about HTTP, databases, and how requests actually travel before you feel ready to answer questions out loud. From zero, six to ten months to job ready is honest.

Do GitHub, then Node, then SQL, and resist reordering. The Node path teaches MongoDB because it is fast to get moving with, but do not skip the SQL weeks afterward. Most production systems are relational, most interview questions assume SQL, and the mental model of tables and joins makes the document model easier to use well rather than badly. Build the REST API project properly, with real error handling and input validation, because that project is what you will walk an interviewer through.

This suits people who prefer thinking about data and correctness over pixels, who are comfortable working without a visible result for a few days at a time, and who like the idea that one API can serve a web app, a mobile app, and a cron job at once. It is a poor fit if you want visual feedback while you learn, or if you are hoping to avoid databases, since backend work is mostly databases wearing a trench coat.

What this roadmap covers

GitHub

3 Week

Go from your first commit to a real open-source contribution: Git and GitHub fundamentals, branches and issues, then actually open a pull request on a real project.

Start the free learning paths →

Node

8 Week

Ship a real backend portfolio with Node.js: a REST API, JWT authentication, a real-time app with Socket.IO, a full-stack CRUD app with a database, and a live deployment.

Start the free learning paths →

SQL

5 Week

Go from your first SELECT to real analytics: joins, subqueries, window functions, designing your own schema, and a full analytics project on a real public dataset.

Start the free learning paths →

The week-by-week plan

  1. Week 1: GitHub Basics

    GitHub

    Understand what GitHub is, how it fits with Git, and get comfortable with the core workflow.

    Watch

    Milestone What GitHub is and why developers use it

  2. Week 2: Branches, Issues & Collaboration

    GitHub

    Go beyond the basics: branch your work, track tasks with Issues, and understand how forking works.

    Watch

    Milestone What forking a repository means

  3. Week 3: Project: Contribute a Pull Request to a Real Open-Source Repo

    GitHub

    Put everything together: fork a real project, make a small improvement, and open your first pull request.

    Watch

    Milestone Finding a real repo and a beginner-friendly issue to work on

    Project checkpoint Put everything together: fork a real project, make a small improvement, and open your first pull request.

  4. Week 4: Node.js Fundamentals

    Node

    Get comfortable with the Node.js runtime, core modules, npm, and building a basic server without any framework.

    Watch

    Milestone What Node.js is and how the V8 runtime works outside the browser

  5. Week 5: Express.js Fundamentals

    Node

    Learn Express, the standard web framework for Node, and how to structure routes and middleware.

    Watch

    Milestone Setting up an Express server and defining routes

  6. Week 6: MongoDB & Mongoose Fundamentals

    Node

    Learn how to model and query data in MongoDB using Mongoose so you can persist real data from your Express apps.

    Watch

    Milestone Connecting a Node app to MongoDB with Mongoose

  7. Week 7: Project: Build a REST API

    Node

    Combine Express and MongoDB to build and test a real, documented REST API from scratch.

    Watch

    Milestone Designing RESTful routes and resource structure

    Project checkpoint Combine Express and MongoDB to build and test a real, documented REST API from scratch.

  8. Week 8: Project: Add JWT Authentication

    Node

    Add a real login system to your API using JSON Web Tokens so routes can be protected per-user.

    Watch

    Milestone Hashing and storing passwords securely with bcrypt

    Project checkpoint Add a real login system to your API using JSON Web Tokens so routes can be protected per-user.

  9. Week 9: Project: Real-Time Chat App with Socket.IO

    Node

    Build a real-time, multi-room chat application using WebSockets via Socket.IO on top of your Express server.

    Watch

    Milestone How WebSockets differ from regular HTTP requests

    Project checkpoint Build a real-time, multi-room chat application using WebSockets via Socket.IO on top of your Express server.

  10. Week 10: Project: Full-Stack CRUD App with a Database

    Node

    Ship a complete full-stack application: a React front end talking to your own Node/Express/MongoDB backend.

    Watch

    Milestone Structuring a full MERN (MongoDB, Express, React, Node) project

    Project checkpoint Ship a complete full-stack application: a React front end talking to your own Node/Express/MongoDB backend.

  11. Week 11: Project: Deploy Your Node.js App

    Node

    Take your backend live: configure environment variables and deploy your Node app to a real cloud host.

    Watch

    Milestone Preparing a Node/Express app for production

    Project checkpoint Take your backend live: configure environment variables and deploy your Node app to a real cloud host.

  12. Week 12: SQL Fundamentals: Queries & Databases

    SQL

    Learn to query a relational database: SELECT, WHERE, GROUP BY, and aggregate functions.

    Watch

    Milestone Write SELECT statements with filtering and sorting

  13. Week 13: Joins & Subqueries

    SQL

    Combine data across multiple tables with joins, and nest queries with subqueries.

    Watch

    Milestone Understand INNER, LEFT, RIGHT, and FULL joins

  14. Week 14: Window Functions for Analytics

    SQL

    Learn window functions to rank, partition, and run running totals over result sets.

    Watch

    Milestone Understand the OVER() clause and PARTITION BY

  15. Week 15: Project: Design a Relational Database Schema

    SQL

    Design a normalized schema from scratch: entities, relationships, and an ER diagram.

    Watch

    Milestone Model entities and relationships as an ER diagram

    Project checkpoint Design a normalized schema from scratch: entities, relationships, and an ER diagram.

  16. Week 16: Project: Analyze a Real Public Dataset

    SQL

    Ship a full SQL analytics project: joins, aggregation, and window functions, against a real-world public dataset.

    Watch

    Milestone Explore a real, messy public dataset with SQL

    Project checkpoint Ship a full SQL analytics project: joins, aggregation, and window functions, against a real-world public dataset.

Resources and structure are drawn from the free Dropout Developer learning paths.

Get this as a dated plan

Run the same roadmap through the generator with your weekly hours and a target date to get a dated schedule you can copy, download, or print.

Open the roadmap generator Start the free learning paths

FAQ

Do I need to know frontend to get a backend job?

A little helps. You should be able to build a plain HTML page that calls your API and shows the response, because that is how you demo backend work in an interview. You do not need a framework or design skills for a backend role.

MongoDB or SQL first?

This roadmap does MongoDB first because it removes friction while you are still learning Node, then SQL. In production and in interviews, relational databases dominate, so treat the SQL weeks as the more important half, not an optional extra.

How important is deployment for a junior backend role?

Very. A backend that only runs on your laptop is hard to believe. Deploy at least one project to a real host with a database, environment variables, and a URL you can send someone. It is often the difference between a callback and silence.

Is Node the right language to start with?

It is a reasonable start, especially if you already touched JavaScript. The patterns you learn, routing, middleware, an ORM, migrations, auth, and testing, transfer directly to Django, Rails, Spring, and Go. Language is the easy part to change later.

What should I learn after this?

Caching with Redis, message queues, one cloud provider in depth, and how to write integration tests against a real database. Then read about system design, since that is the interview that stands between junior and mid level.

Compare with the static roadmap on roadmap.sh →