Learn Prisma

This course teaches you to work with a real PostgreSQL database from TypeScript using Prisma 8. You'll query and write data behind a team task board, model the database in contract.prisma, and change it safely with migrations, running the real Prisma CLI in the terminal. It ends with a capstone that adds sprints to the board, from the first model to the transaction that closes a sprint.

What you'll learn

• Reading rows with Prisma's typed query API
• Filtering, sorting, and paging with where, orderBy, limit, and offset
• Writing data with create, update, and delete, and keeping writes together in a transaction
• Modeling a database in contract.prisma with types, defaults, unique fields, and enums
• Relations: one-to-many, many-to-many through a join model, and loading related rows with include
• Counting and summarizing with aggregate, groupBy, and counts inside an include
• Migrations: planning and applying a change, handling data loss and renames, and backfilling a new required field

Prerequisites

• Finished Learn SQL (opens in a new tab) or comfortable with SQL queries, joins, and writes
• Finished TypeScript Fundamentals (opens in a new tab) or comfortable writing TypeScript functions and types
• No Prisma experience needed