Database Mastery: SQL to Prisma

0% completed

100%

Chapter 01

Getting Started

Meet Adrian, Your Instructor
Get the Most Out of This Course
Access to a Private 24/7 Community
Environment Setup

Chapter 02

Databases Introduction and Setup

What's a Database?
Terminology

Chapter 03

Introduction to SQL

What is SQL?
Basic Setup
Creating a Table in SQL
Creating a Table - Constraints
Creating a Table - Clauses
Inserting Data
Multiple Inserts
Select - SQL
Where - SQL
And - SQL
Like - SQL
Updating Rows With SQL
Multiple Tables - Exercise
Multiple Tables - Solution
Connecting Tables - Exercise
Connecting Tables - Solution
Querying Multiple Tables - Exercise
Querying Multiple Tables - Solution

Chapter 04

Introduction To Prisma

What is an ORM?
Setting Up Prisma
Setting Up Supabase
Connecting Our Database to Prisma
Introduction To Prisma Models
Creating Multiple Tables and Relations in Prisma
Exploring Prisma Studio
Updating Our Schema

Chapter 05

Integrating Prisma with a Real Application

Introduction To The Project
Prisma Project Setup
Defining our Schema
Prisma Client
Building A Server Action: Create a Product
Building A Server Action: Read a Product
Building A Server Action: Update a Product
Building A Server Action: Delete a Product
Caching our Server Actions
Create a Review - Exercise
Create a Review - Solution
Pagination: Part One
Pagination: Part Two
Filtering
Final Thoughts

Chapter 06

Advanced Prisma

Aggregates
Aggregates - Count
Aggregates - Average
Aggregates - Sum
Grouping Aggregations
Transactions

Course

Building A Server Action: Create a Product

The rest of this lesson is waiting.
Join JS Mastery Pro to unlock it.

It looks like you’re located in 🇺🇸 United States of America To help make JS Mastery more affordable, you can enable a regional discount of 14% off

Enable discount

Quarterly Plan

$98 / mon $128

$294 billed every 3 month

Quarterly PlanYearly Plan

Save $90 with the quarterly plan!

Subscribe to JS Mastery

Access to All Courses

You get access to all courses on our platform, like:

Ultimate Next.js Course (worth $599)
Ultimate GSAP Course (worth $599)
Ultimate Testing Course (worth $300)
Ultimate Three.js Course (worth $300)
Ultimate React Native Course (worth $599)
and all upcoming courses

Career advancement through the Dev accelerator course and practice for your interviews through our AI interviewer

A system that makes you committed to your learning goals

Quizzes, challenges, AI summaries, inline sandboxes

Join our private Discord community

Build real production-grade apps

Mock interviews & project reviews

Get Feedback from expert developers

Structured full stack learning path

7-day money-back guarantee

Features

Self-paced courses

Progress tracking

English, Hindi and Spanish subtitles

The rest of this lesson is waiting.Join JS Mastery Pro to unlock it.

Quarterly Plan

The rest of this lesson is waiting.
Join JS Mastery Pro to unlock it.