Express JS Prisma ORM Query Fundamentals
Querying Your Database with Express js and Prisma ORM, a Fundamental Guide.
Express JS Prisma ORM Query Fundamentals free download
Querying Your Database with Express js and Prisma ORM, a Fundamental Guide.
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
