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

Environment Setup

Loading...

Environment Setup

Loading...

Loading...

Loading...

Before diving into the exciting world of JavaScript, let’s set up your development environment for a seamless learning and development experience.

1. Choose a Browser

Since JavaScript runs in the browser, you’ll need one to test your code. If you already have a browser like Chrome, Firefox, or Edge, you’re good to go. However, if you’re looking for something fresh, I recommend trying Arc. Arc is an innovative browser with:

A collapsible sidebar for better focus.
Customizable spaces to organize work.
Full-screen views without the traditional top bar.

That said, any browser will work perfectly fine for this course, so use the one you’re most comfortable with.

All browsers offer amazing include developer tools allowing you to do range of things, from inspecting currently-loaded HTML, CSS and JavaScript to showing which assets the page has requested and how long they took to load.

You can open dev tools in any browser by right-clicking the site and clicking inspect. You can also use the shortcut: + + (on Mac) or on your keyboard.

You can download Arc browser here:

2. Install Node.js

Although this course doesn’t cover backend development, having Node.js installed is a great idea. It allows you to run JavaScript outside the browser, and it’s a must-have if you plan to explore tools like package managers or frameworks in the future.

Head to Node.js and download the latest LTS (Long-Term Support) version.
Installation is straightforward and varies slightly based on your operating system.

3. Install Git

While it's not mandatory to have Git installed for this course, it's absolutely essential for your growth as a developer. It's non-negotiable.

You can download Git from it's website.

And if you haven’t used it before, I’ll link our complete Git and GitHub Course so you can learn how to use them quickly and effectively.

4. Choose a Code Editor

Your is where you’ll spend most of your time writing JavaScript.

Here are two popular options:

Visual Studio Code (VS Code): Lightweight, highly customizable, andpacked with features. It’s the editor I’ll use throughout this course.

Feel free to explore themes to personalize your editor’s appearance. I personally use the Catppuccin Mocha theme for a dark and sleek look.

5. Keep It Simple

You don’t need to install every tool or extension right now. Start with the basics and add as you go. The goal is to have an environment that feels intuitive and supports your learning.

With your environment ready, you’re all set to dive into this course!