Backend Journey

Progress · Todos · Start

phase0-foundations (0/11)

01-linux-and-shell

○ 01-processes-and-streams ○ 02-filesystem-and-permissions ○ 03-shell-pipelines-and-diagnostics

02-git-and-workflow

○ 01-git-object-model ○ 02-history-hygiene-and-rebasing

03-python-internals

○ 01-references-mutability-and-memory ○ 02-data-model-and-iterables ○ 03-strict-typing-and-protocols ○ 04-context-managers-and-exceptions

04-testing-and-verification

○ 01-unit-testing-and-fixtures ○ 02-fakes-mocks-and-boundaries

phase1-cs-and-architecture (0/10)

01-data-structures

○ 01-complexity-and-arrays ○ 02-hash-tables-and-sets ○ 03-stacks-queues-and-deques ○ 04-heaps-trees-and-tries

02-algorithmic-patterns

○ 01-two-pointers-and-sliding-window ○ 02-binary-search-and-intervals ○ 03-graphs-bfs-dfs-and-toposort

03-software-architecture

○ 01-solid-and-cohesion ○ 02-clean-and-hexagonal-architecture ○ 03-code-review-and-ai-auditing

phase2-networking-and-concurrency (0/0)

01-network-protocols

· 01-tcp-udp-and-sockets · 02-dns-tls-and-reverse-proxies · 03-http-evolution-and-semantics · 04-realtime-sse-and-websockets

02-concurrency-and-asyncio

· 01-threads-processes-and-gil · 02-synchronization-and-locks · 03-asyncio-event-loop-internals · 04-structured-concurrency-and-backpressure

phase3-databases-and-apis (0/0)

01-postgresql-and-sql

· 01-relational-design-and-normalization · 02-advanced-sql-and-window-functions · 03-indexing-and-explain-analyze · 04-transactions-acid-and-isolation

02-sqlalchemy-and-data-access

· 01-sqlalchemy-core-and-orm · 02-n-plus-one-and-pagination

03-fastapi-production

· 01-routing-validation-and-di · 02-middleware-errors-and-testing

04-django-for-backend

· 01-django-architecture-and-orm · 02-drf-signals-and-admin

05-auth-and-security

· 01-passwords-sessions-and-jwt · 02-oauth2-rbac-and-owasp

phase4-distributed-systems (0/0)

01-redis-and-caching

· 01-redis-data-structures-and-patterns · 02-stampede-locks-and-rate-limiting

02-queues-rabbitmq-celery

· 01-postgres-skip-locked-queues · 02-rabbitmq-exchanges-and-routing · 03-celery-in-production

03-durable-execution-temporal

· 01-idempotency-outbox-and-sagas · 02-temporal-workflows-and-activities

04-elasticsearch

· 01-inverted-index-and-mappings · 02-full-text-queries-and-aggregations

05-microservices-and-grpc

· 01-modular-monolith-vs-microservices · 02-grpc-and-protocol-buffers

phase5-devops-and-observability (0/0)

01-containers-and-k8s

· 01-docker-and-compose-in-production · 02-ci-cd-pipelines · 03-kubernetes-fundamentals

· 01-ansible-playbooks-and-roles

03-observability-and-apm

· 01-structured-logging-and-sentry · 02-prometheus-and-grafana · 03-distributed-tracing-and-apm

04-system-design-mastery

· 01-capacity-estimation-and-scaling · 02-system-design-case-studies

01-postgresql-and-sql

Lessons in this module:

01-relational-design-and-normalization — Relational Modeling, 3NF, JSONB & Constraints
02-advanced-sql-and-window-functions — CTEs, Window Functions & UPSERT
03-indexing-and-explain-analyze — B-Tree/GIN Indexing & EXPLAIN (ANALYZE, BUFFERS)
04-transactions-acid-and-isolation — ACID, MVCC, Isolation Levels & Row Locks