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

Get the Most Out of This Course

Loading...

Get the Most Out of This Course

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

    Access to a Private 24/7 Community

    I’ve broken the course into manageable, bite-sized lessons. Each lesson is focused on a specific topic, so you can progress step by step. Here’s what you can expect in every lesson:

    1. Brief Introduction – Understand the core idea behind the topic and why it’s important.
    2. Follow-Along Demos – Practice coding as you watch. Replicate everything shown in the video to reinforce your understanding.
    3. Quizzes and Exercises – Test your knowledge and identify areas where you might need to improve.
    4. Additional Resources – Find links, references, and suggestions to deepen your understanding.

    There are a couple of things to know so you can get the most out of this course:

    1. Active Participation

    • Follow along with the videos. Don’t just watch—type out the code yourself. Repetition and hands-on practice are the fastest ways to learn.

    • Experiment with the code. Don’t stop at what’s shown in the lesson—try changing variables, tweaking functions, or applying concepts in new ways to see how things work.

    2. Engage with the Community

    • Join the private Discord Community. This is a space to ask questions, share knowledge, and collaborate with others who are learning alongside you. Helping others is also a fantastic way to solidify your own understanding.

    • Use the comments section below each lesson to clarify doubts or share insights. Don’t hesitate to ask questions—no question is too small.

    3. Stay Consistent

    • Block out dedicated time for this course in your weekly schedule. Even 30–60 minutes a day can create meaningful progress.

    • Avoid skipping lessons, even if you think you know the material. Each lesson builds on the previous one, and you might discover new perspectives or tips.

    4. Master the Basics

    • Take the time to fully grasp foundational topics, these are the building blocks for everything else.

    • If you find something confusing, revisit the lesson or use the provided resources to deepen your understanding.

    5. Embrace Mistakes

    • Mistakes are a natural part of learning. When you encounter an error, take a moment to debug and understand what went wrong. Every error you fix is a lesson learned.

    6. Quizzes Are Key

    • Complete every quiz. These are designed to reinforce your knowledge and highlight areas where you may need more practice.

    7. Stay Motivated

    • Remember, countless others have followed this path and achieved their dreams. This course is designed to help you do the same.

    Why This Course is Different

    This isn’t just another tutorial. By the end of this course, you won’t just know what you’ve been learning about—you’ll be able to use it to build impressive projects, and even ace job interviews.

    The tools within our platform and community are here to support you every step of the way.

    Let’s dive in and start building your developer career!