Express Js Prisma Orm Query Fundamentals
Published 4/2025
Created by Very Academy
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Beginner | Genre: eLearning | Language: English | Duration: 67 Lectures ( 8h 55m ) | Size: 3.9 GB
Querying Your Database with Express js and Prisma ORM, a Fundamental Guide.
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.
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 Introductions1. Course Introduction## 2 Preparing For Development1. Module Primer2. New Developers Guide: VSCode for Windows & MacOS3. Project Setup: ESLint, Prettier, and Formatting4. New Developers Guide: Docker Desktop5. Setting up PostgreSQL with Docker6. Setting up Express and Prisma with Docker## 3. Fundamentals - Developing a Prisma Schema1. Module Primer2. ERD Introduction (Entity Relationship Diagram)3. Defining Database Tables with Prisma Schema4. Running Migrations with Prisma5. Common Data Types: Strings, Numbers, Booleans6. Date and Time Fields7. Required, Optional, and Default Values8. Unique Constraints9. Creating Primary Keys10. Creating Foreign Keys and Relations11. Cascade Delete & Referential Actions12. Many-to-Many Relationships13. One-to-One Relationships14. Opposite Relation Fields15. Finalizing Prisma Schema16. Using Prisma Studio17. Automating Prisma Migration with Docker## 4. Fundamentals - Data Operations1. Module Primer2. Setting Up Express Routes and Controllers3. Inserting / Creating New Records4. Express API Documentation with Swagger5. Auto Code Updates with Node Monitor6. Implementing Bulk Inserts7. Updating Records8. Upsert (Update or Insert)9. Bulk Updates10. Handling One-to-Many Inserts11. Handling One-to-One Inserts12. Handling Many-to-Many Inserts13. Deleting Records14. Bulk Delete## 5. Fundamentals: Querying the Database1. Module Primer2. Automating Seeding the Database with Docker3. Retrieving Data: findMany4. Filtering Records with where5. Handling Dynamic Parameters and Sending Data6. Sorting Results with orderBy7. Retrieving First and Last Record8. Implementing Pagination with Prisma9. Removing Duplicate Records with `distinct()`## 6 Fundamentals: Filtering1. Module Primer2. Using Logical Operators3. Comparison Operators4. Searching with Pattern Matching5. List Filtering6. Using between() for Value Ranges7. Limiting Queries with List Slicing## 7 Fundamentals: Querying Relationships and Join1. Module Primer2. SQL Inner Join3. Using Aliases4. Using Raw SQL Queries in Prisma5. Querying One-to-One Relationships6. Querying Many-to-Many Relationships7. SQL Left Join8. SQL Full Join## 8 Fundamentals: Aggregation and Grouping1. Module Primer2. Counting Records with Count3. Summing Values with Sum4. Calculating Averages with AVG5. 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.
Homepage
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
