Intermediate to senior

Backend Interview Prep

Fourteen chapters on HTTP and API design, SQL, indexing and transactions, NoSQL, authentication, caching, concurrency, messaging, resilience, deployment and observability, with tested SQL and Python.

14 chaptersUpdated 2026-10-02

Foundations

Chapter 1How Backend Interviews WorkThe rounds, what interviewers look for, a request's journey and a six-week plan.
Chapter 2HTTP, REST and API DesignMethods and status codes, resources, idempotency keys, pagination, errors, versioning and ETags.

Data

Chapter 3SQL Fundamentals for InterviewsJoins, NULL logic, window functions, top-N per group and the classic puzzles, all run on a real engine.
Chapter 4Indexes, Transactions and IsolationB-trees, composite and covering indexes, query plans, ACID, anomalies, lost updates and locking.
Chapter 5Schema Design, Normalisation and NoSQLNormal forms, denormalisation, modelling patterns, NoSQL families, CAP, quorums and sharding.

Security and performance

Chapter 6Authentication and AuthorisationPassword hashing, sessions versus JWTs, OAuth with PKCE, RBAC and ABAC, and IDOR.
Chapter 7Caching: Strategies and PitfallsCache-aside and friends, eviction, invalidation, stampedes, penetration and HTTP caching.

Concurrency and distributed systems

Chapter 8Concurrency: Threads, Locks and Async I/ORaces, locks, deadlocks, producer-consumer, event loops and fencing tokens.
Chapter 9Messaging, Queues and Event-Driven DesignQueues versus logs, delivery guarantees, idempotent consumers, outbox, sagas and event sourcing.
Chapter 10Resilience Patterns and Rate LimitingTimeouts, retries with jitter, circuit breakers, bulkheads, load shedding and rate limiter algorithms.
Chapter 11Microservices and Distributed Systems BasicsBoundaries, communication, partial failure, clocks, CRDTs, consensus and the strangler fig.

Operations and practice

Chapter 12Testing, Deployment and CI/CDTest levels, contract tests, deployment strategies, feature flags and zero-downtime migrations.
Chapter 13Observability and Performance DebuggingLogs, metrics, traces, percentiles, SLOs, and a method for the API is slow.
Chapter 14Backend Coding Patterns and Practical ProblemsTTL store, LRU, log parsing, rate limiter, scheduler, URL shortener and ledger.
Header Logo