Course Description
This intermediate program teaches you to design, build, and ship full-stack web applications using the React and Next.js ecosystem. You will master React hooks, the Next.js App Router, and Server Components, then connect your applications to a MySQL database through the Prisma ORM. The course covers the essentials of production software: authentication with Auth.js, form validation with React Hook Form and Zod, global state management, RESTful APIs, serverless functions, and secure handling of environment variables. You will also adopt a professional workflow with automated testing, component documentation, and Agile project management. The course concludes with a capstone project in which you build and deploy a full-stack e-commerce platform or blog engine.
What You Will Learn
-
Build modern user interfaces with React hooks and reusable components
-
Develop server-rendered applications with the Next.js App Router, Server Components, and Server Actions
-
Design normalized relational databases and write efficient SQL queries in MySQL
-
Integrate databases into applications using the Prisma ORM
-
Implement secure user authentication and protected routes with Auth.js
-
Manage application state with Zustand or Redux Toolkit
-
Build and secure RESTful APIs and serverless functions
-
Write unit tests with Jest and Vitest and document components with Storybook
-
Work in an Agile team workflow using Jira or Trello
Prerequisites
-
Completion of the Beginner Level Frontend Development course, or equivalent experience
-
Solid working knowledge of HTML and CSS
-
Good understanding of JavaScript fundamentals, including ES6+ syntax, functions, arrays, objects, and asynchronous code (Promises, async/await)
-
Basic experience with Git and GitHub
Technical Requirements
- Laptop running Windows 10/11, macOS, or Linux
- Minimum 8GB RAM (16GB recommended), SSD storage preferred, and at least 20GB free storage
- Stable internet connection for live classes, package installation, and deployment
- Node.js 20 LTS or later, Git, and Visual Studio Code
- MySQL 8 (Community Server) with MySQL Workbench or a similar database client
- Postman or Insomnia for API testing
- Free GitHub and Vercel accounts
Course Syllabus
- React Hooks: useState, useEffect, and Custom Hooks
- Next.js App Router and File-based Routing
- Server Components vs. Client Components
- Data Fetching: Server Actions and Suspense
- Middleware and Route Protection
- Relational Database Design & Normalization
- SQL CRUD Operations (Create, Read, Update, Delete)
- Complex Queries: Joins, Unions, and Aggregations
- Database Indexing and Performance Tuning
- Using Prisma ORM with Next.js
- Global State Management (Zustand or Redux Toolkit)
- Form Handling with React Hook Form and Zod
- Authentication with NextAuth.js (Auth.js)
- Dynamic Routing and Dynamic Metadata
- Building Interactive Dashboards
- Building RESTful APIs within Next.js
- Serverless Functions and Edge Runtime
- Error Handling and Global Catch Blocks
- Environment Variables and Security
- Connecting Next.js to a Managed MySQL Instance
- Unit Testing with Jest and Vitest
- Component Documentation with Storybook
- Agile Methodology & Jira/Trello for Developers
- Intermediate Project: A Full-Stack E-commerce or Blog Engine