Learn APIs development with Prisma, Nodejs, and Postgres
in Essential Supporting Skills
Created by
Haider Malik
About this course
Prisma is a next-generation object–relational mapper (ORM) that claims to help developers build faster and make fewer errors. Prisma takes a different approach to ORMs compared to traditional ORMs. It uses a custom Schema Definition Language (SDL) that automatically writes migrations and generates type-safe code. Why Prisma?
- ORMs facilitate implementing the domain model. The domain model is an object model that incorporates the behavior and data of your business logic. In other words, it allows you to focus on real business concepts rather than the database structure or SQL semantics.
- ORMs help reduce the amount of code. They save you from writing repetitive SQL statements for common CRUD (Create Read Update Delete) operations and escaping user input to prevent vulnerabilities such as SQL injections.
- ORMs require you to write little to no SQL (depending on your complexity you may still need to write the odd raw query). This is beneficial for developers who are not familiar with SQL but still want to work with a database.
- Many ORMs abstract database-specific details. In theory, this means that an ORM can make changing from one database to another easier. It should be noted that in practice applications rarely change the database they use.
In this course, we are going to build the REST API in Prisma, Node, Express, and Postgres
Requirements
knowledge of Javascript is required
Basic knowledge of nodejs and typescript is appreciated
Comments (0)
GETTING STARTED WITH NODE API
2 Parts
Introduction
50 MB
Create Express Server
50 MB
LEARN PRISMA BASICS
4 Parts
Install Prisma and Create Model
50 MB
Insert new Record
50 MB
Find many records and add one to many relation
50 MB
Module Summary
50 MB
CREATING CRUD API WITH EXPRESS AND PRISMA
7 Parts
Create Express Server and Endpoints
50 MB
Create Custom Middleware
50 MB
More Middlewares
50 MB
Validate Request parameters
50 MB
Refactor the App Structure
50 MB
Find Record by ID
50 MB
Update and Delete Record
50 MB
RELATIONS
2 Parts
Add One to many relational queries
50 MB
One to One relation
50 MB
AUTHENTICATION
6 Parts
Create User Model
50 MB
Implement Signup Feature
50 MB
Find user by email
50 MB
Create JSON web token
50 MB
Create Authentication Middleware
50 MB
Create one to one relation
50 MB
PAGINATION, FILTERING AND SORTING
1 Parts
Pagination, Filtering and Sorting
50 MB
CONNECT PRISMA WITH POSTGRES DATABASE
1 Parts
Connect Prisma with Postgres Database
50 MB
TRANSACTIONS
4 Parts
What is a Transaction
50 MB
Nested Queries
50 MB
Independent Sequential Queries
50 MB
Interactive Transactions
50 MB
TESTING
3 Parts
Getting Setup with Jest
50 MB
Object Assignment Matcher
50 MB
not to be matcher
50 MB
BONUS : NODEJS &JAVASCRIPT BASICS
9 Parts
Variables and Scoping
50 MB
Arrow Functions
50 MB
Template Strings
50 MB
Destructing For Loops and Arrays
50 MB
Speard, Rest and Object Literal
50 MB
Promises
50 MB
ES6 Modules
50 MB
Classes
50 MB
Async/Await
50 MB
0
0 Reviews
