Full-Stack school admin dashboard app with user roles, prisma, PostgreSQL.
Get Hostinger Discount: https://hostinger.com/lamadev Coupon Code: LAMADEV

Clerk Authentication: https://go.clerk.com/OcOGkE8

You are watching the second part (The Back-end)
Watch the first part here: https://youtu.be/myYlGLFxZas

If it is valuable to you, you can support Lama Dev.
Join: https://www.youtube.com/channel/UCOxWrX5MIdXIeRNaXC3sqIg/join
Buy me a coffee: https://www.buymeacoffee.com/lamadev

Source Code: https://github.com/safak/full-stack-school

Join Lama Dev groups
X / Twitter: https://x.com/lamawebdev
Facebook: https://www.facebook.com/groups/lamadev
Instagram: https://www.instagram.com/lamawebdev
Discord: https://discord.gg/yKremu4mPr

00:00 Introduction
05:00 Installation 
06:28 School Management App Database Structure & Relationships
13:00 Next.js Prisma Tutorial
15:20 Prisma School Management App Database Tables & Relationships
34:34 How to Install PostgreSQL on Docker
39:20 How to Create Prisma Seed
45:42 Next.js Prisma Data Fetching
49:17 Next.js School App Fetching Teachers
52:52 Next.js Prisma Pagination Tutorial
01:08:00 Next.js How to Fetch Data with Query Params on the URL
01:17:46 Next.js Search Filter (Fetch Data with Search Params on the URL)
01:21:12 Fetch Students
01:27:00 Fetch Parents
01:30:08 Fetch Subject
01:32:29 Fetch Class
01:36:00 Prisma Nested Query (Include, Select, Where)
01:42:16 Fetch Exams
01:48:28 Fetch Assignments
01:51:12 Fetch Exam Results
02:03:00 Fetch Events
02:06:14 Fetch Announcements
02:08:25 Next.js Role Based Authentication Tutorial
02:12:05 Next.js Clerk Role Based Auth Tutorial
02:31:08 Next.js Protect Routes with User Role
02:39:15 How to Fetch Data According to User Role in Nexj.js
03:09:17 School App Admin Homepage Data
03:11:25 Fetch Chart Data
03:16:55 Fetch Attendance Chart Data
03:27:37 React Next.js Even Calendar Component
03:35:35 Fetch School Announcement
03:42:05 School App Teacher Homepage Data
03:42:51 Next.js Big Calendar Tutorial (Add a recurring schedule)
04:01:45 Next.js Forms with react-hook-form and Z od Validation
04:09:25 Next.js Server Actions with Prisma and Zod
04:13:16 React Next.js useActionState (useFormState) Tutorial 
04:17:21 Next.js Notifications with React Toastify Library
04:24:42 Delete Table Items with Server Actions
04:28:28 Next.js Form Fetch Select Options from the Database
04:38:50 School Classes (Create/Update/Delete with Server Actions)
04:48:56 School Teachers (Create/Update/Delete with Server Actions)
04:58:42 Image Upload with Next.js Cloudinary Widget
05:03:16 Creating Teacher
05:11:44 School Dashboard Single Teacher Page
05:22:25 School Dashboard Single Student Page
05:31:51 School Students (Create/Update/Delete with Server Actions)
05:47:23 Next.js Role Based Data Mutation (Protect Database)
06:01:10 How to Deploy Next.js App with Prisma and Postgres using  Docker
06:12:45 Outro

YouTube

This guide walks through creating a full-stack school management application using Next.js, implementing role-based dashboards for different users (admin, teacher, student, parent) with specific functionalities such as protected routes, pagination, and search functionalities. The backend is built using PostgreSQL and Prisma ORM, and deployed with Docker and Hostinger. The guide covers setting up the database schema, handling various user roles, and deploying the application efficiently.

Next.js Full-Stack School Management App Full Tutorial | Role Based School Dashboard Project