logo
Course

Database Mastery: SQL to Prisma

0% completed

100%

Chapter 01

Getting Started

  • Meet Adrian, Your Instructor

    Free
  • Get the Most Out of This Course

    Free
  • Access to a Private 24/7 Community

    Free
  • Environment Setup

    Free

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

Meet Adrian, Your Instructor

Loading...

Meet Adrian, Your Instructor

Loading...
Loading...
Loading...
    Video thumbnail
    Course icon

    Sign up to watch this lesson (and more).

    By logging in, you'll unlock full access to this and other free tutorials on JSM Pro.

    Why? Logging in lets us personalize your learning experience, track your progress, and keep you in the loop with new workshops, coding tips, and platform updates.

    You'll also be the first to know about upcoming launches, events, and exclusive discounts.

    No spam—just helpful content to level up your skills.

    If that sounds fair, go ahead and log in to continue →

    Enter your name and email to get instant access

    or

    Already have an account? Log in

    0 Comments

    glass-bbok

    No Comments Yet

    Be the first to share your thoughts and start the conversation.

    tick-guideNext Lesson

    Get the Most Out of This Course

    You and I are about to dive into an exciting journey as you work your way through this course. So, let me introduce myself.

    I’m Adrian, and you might recognize my voice from my YouTube channel, where I’ve spent years creating tutorials that have reached millions of learners worldwide.

    I’m a GitHub star, conference speaker and an educator, and I’ve been doing this for almost a decade. Over time, I’ve been honored to teach a growing community of over 1 million developers, with videos that have accumulated nearly 100 million views and been watched for over 10 million hours. That’s like someone watching non-stop for over 1,140 years!

    But beyond the numbers, the most fulfilling part of this journey has been hearing from developers like you—people who’ve turned their dreams into reality. Many of them have landed their first developer jobs, transitioned into tech careers, or even launched successful startups after completing one of my courses.

    Take Gary from the US, for example. He said, "Adrian is a great teacher, very informative material and makes learning a subject like Next.js much more enjoyable than if I tried to learn it on my own."

    Or Nana from Ghana, who shared: "This course has been a game-changer for me. If you're on the fence about purchasing, let me assure you: this course has everything you need to become an industry-standard developer."

    And there’s Vamshi from India, who said: "Thank you, bro! Your course is helping me a lot both from YouTube and here."

    These are just a few of the thousands of success stories I’ve heard over the years. And now, it’s your turn to put in the time, trust the process, and make these skills your own.

    I’m here to guide you every step of the way, so let’s dive right in!