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

Access to a Private 24/7 Community

Loading...

Access to a Private 24/7 Community

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

    Environment Setup

    As part of this course, you’ll gain access to our private community, available 24/7. This is your space to connect, collaborate, and learn with fellow developers.

    Why Join the Discord Community?

    • Ask Questions Anytime: Stuck on a concept? Post your questions in dedicated channels and get help from the community or me directly.
    • Learn and Collaborate: Share insights, solve problems together, and even find collaborators for future projects.
    • Network Effectively: Build connections early in your career that can open doors in the tech world.

    How to Make the Most of It

    1. Join Now: There’s a link below this lesson. Once in, introduce yourself in the #introductions channel.
    2. Engage Regularly: Participate in discussions, share your progress, and help others.
    3. Use Topic-Specific Channels: Keep discussions relevant and focused.

    Commenting System and Quizzes

    Each lesson also includes a comment section where you can ask questions or share insights directly related to the material. Use it to clarify doubts and engage with other learners.

    At the end of many lessons, quizzes are available to test your knowledge. Don’t skip them—they your learning and highlight areas for improvement.

    Why This Matters

    Learning is more effective when you’re engaged with a community and actively practicing. Use Discord, the comment section, and quizzes to make the most of this course. Together, we’ll help you master JavaScript and set you up for success!

    Join Discord
    faviconhttps://discord.gg/4KTgTmGAU7
    thumbnail