Your cart is empty.
Keep shoppingExpress JS Prisma ORM Query Fundamentals
69 students
Express JS Prisma ORM Query Fundamentals
Querying Your Database with Express js and Prisma ORM, a Fundamental Guide.
Created byVery Academy
Last updated 3/2025
English
What you'll learn
- Understand the core objectives of the course and how Prisma ORM integrates with Express.js to simplify database operations.
- Set up a fully functional development environment with VSCode, Docker, PostgreSQL, and Prisma ORM to ensure smooth backend development.
- Define and manage database schemas using Prisma, including relationships, constraints, and migrations.
- Perform CRUD operations (Create, Read, Update, Delete) using Prisma within an Express.js API.
- Efficiently retrieve, filter, and sort data using Prisma’s querying methods like findMany, where, and orderBy.
- Use logical and comparison operators to refine database queries for retrieving specific sets of data.
- Query related data using Prisma’s relationship handling and join-like functionalities for One-to-One and Many-to-Many relationships.
- Use aggregation functions (COUNT, SUM, AVG) and groupBy to analyze and summarize data effectively.
Explore related topics
Course content
8 sections • 67 lectures • 8h 55m total length
Requirements
- I will take you through the whole course step-by-step. You would benefit from having basic JavaScript knowledge, familiarity with Node.js and Express, an understanding of SQL or database concepts, comfort using a code editor like VSCode, and basic command-line experience, but no prior Prisma ORM knowledge is needed.
Description
Embark on a practical journey to building efficient and scalable backend APIs with our "Express API & Prisma ORM Query Fundamentals" course.
This hands-on program focuses on equipping you with the core skills needed to seamlessly integrate your Express.js applications with databases using Prisma ORM.
Who this course is for:
Beginner Developers learning Express.js and Prisma for the first time.
Backend Developers looking to enhance their database querying skills.
Full-Stack Developers who want to integrate Prisma ORM into their projects.
Software Engineers aiming to optimize and scale database operations.
Data Enthusiasts interested in learning efficient database management with PostgreSQL.
Anyone Transitioning to Node.js & Express from other backend frameworks.
Course Overview:
## 1 Introductions
1. Course Introduction
## 2 Preparing For Development
1. Module Primer
2. New Developers Guide: VSCode for Windows & MacOS
3. Project Setup: ESLint, Prettier, and Formatting
4. New Developers Guide: Docker Desktop
5. Setting up PostgreSQL with Docker
6. Setting up Express and Prisma with Docker
## 3. Fundamentals - Developing a Prisma Schema
1. Module Primer
2. ERD Introduction (Entity Relationship Diagram)
3. Defining Database Tables with Prisma Schema
4. Running Migrations with Prisma
5. Common Data Types: Strings, Numbers, Booleans
6. Date and Time Fields
7. Required, Optional, and Default Values
8. Unique Constraints
9. Creating Primary Keys
10. Creating Foreign Keys and Relations
11. Cascade Delete & Referential Actions
12. Many-to-Many Relationships
13. One-to-One Relationships
14. Opposite Relation Fields
15. Finalizing Prisma Schema
16. Using Prisma Studio
17. Automating Prisma Migration with Docker
## 4. Fundamentals - Data Operations
1. Module Primer
2. Setting Up Express Routes and Controllers
3. Inserting / Creating New Records
4. Express API Documentation with Swagger
5. Auto Code Updates with Node Monitor
6. Implementing Bulk Inserts
7. Updating Records
8. Upsert (Update or Insert)
9. Bulk Updates
10. Handling One-to-Many Inserts
11. Handling One-to-One Inserts
12. Handling Many-to-Many Inserts
13. Deleting Records
14. Bulk Delete
## 5. Fundamentals: Querying the Database
1. Module Primer
2. Automating Seeding the Database with Docker
3. Retrieving Data: findMany
4. Filtering Records with where
5. Handling Dynamic Parameters and Sending Data
6. Sorting Results with orderBy
7. Retrieving First and Last Record
8. Implementing Pagination with Prisma
9. Removing Duplicate Records with `distinct()`
## 6 Fundamentals: Filtering
1. Module Primer
2. Using Logical Operators
3. Comparison Operators
4. Searching with Pattern Matching
5. List Filtering
6. Using between() for Value Ranges
7. Limiting Queries with List Slicing
## 7 Fundamentals: Querying Relationships and Join
1. Module Primer
2. SQL Inner Join
3. Using Aliases
4. Using Raw SQL Queries in Prisma
5. Querying One-to-One Relationships
6. Querying Many-to-Many Relationships
7. SQL Left Join
8. SQL Full Join
## 8 Fundamentals: Aggregation and Grouping
1. Module Primer
2. Counting Records with Count
3. Summing Values with Sum
4. Calculating Averages with AVG
5. Using Group By to Aggregate Data
Who this course is for:
- Beginner Developers learning Express.js and Prisma for the first time.
- Backend Developers looking to enhance their database querying skills.
- Full-Stack Developers who want to integrate Prisma ORM into their projects.
- Data Enthusiasts interested in learning efficient database management with PostgreSQL.
- Anyone Transitioning to Node.js & Express from other backend frameworks.