SQL
Node.js, Prisma & PostgreSQL
Go from raw SQL to a real, type-safe backend: model your data with Prisma, migrate a PostgreSQL database, and query it from a Node.js application.
12 lessons
Start the first lessonCurriculum
- 1Why Prisma? Connecting Node.js to PostgreSQL📝 quiz
- 2Setting Up PostgreSQL and a Prisma Project📝 quiz
- 3Defining Your Prisma Schema📝 quiz
- 4Migrations with Prisma Migrate📝 quiz
- 5Prisma Client: Basic CRUD📝 quiz
- 6Filtering, Sorting, and Pagination📝 quiz
- 7Modeling Relations: One-to-Many and Many-to-Many📝 quiz
- 8Querying Relations with include and select📝 quiz
- 9Transactions and Data Integrity📝 quiz
- 10Building a REST API with Express and Prisma📝 quiz
- 11Seeding and Testing Your Database📝 quiz
- 12Final Project: Build a Blog API with Prisma & PostgreSQL
Every lesson is open, take them in order or jump straight to what you need.