Your roadmap to real skills.

Relational basics, SELECT/JOIN/aggregations, subqueries + CTEs, window functions, indexes + EXPLAIN, transactions + ACID, schema design, PostgreSQL features, SQL from Node/Python/Prisma. Ends with a schema + query gallery passion project.

Document vs relational, fundamentals, CRUD, query operators, aggregation pipeline, indexing, schema design (embed vs reference), Mongoose, Atlas. Ends with a Mongo-backed web app passion project.

REST basics, HTTP in depth, API design, auth (JWT/OAuth), validation + error envelopes, OpenAPI docs, versioning, rate limiting, testing, GraphQL alternative. Ends with a production-grade REST API passion project.