Data and backend

REST APIs, SQL, ORMs with Drizzle and Prisma, Postgres in Next.js.

1. 1REST APIsResources and methods, correct status codes, consistent errors, offset vs cursor pagination.
2. 2SQL and relational databasesTables, keys, CRUD, JOIN, relationships and parameterized queries.
3. 3ORMs: Drizzle and PrismaSchemas in TypeScript, typed queries, migrations; raw SQL vs Drizzle vs Prisma.
4. 4Postgres in Next.jsThe database only on the server, Neon and pooling, caching by kind of data, seeding and migrations.