Embark on a comprehensive 6-hour course to master the PERN stack by building a Yelp clone. Dive into PostgreSQL, Express, React, and Node.js, covering everything from installation and database creation to complex SQL joins. Learn to establish relationships between tables, make queries, and add entries. Explore the fundamentals of each technology, including React Router, Context API, and RESTful API conventions. Develop practical skills by implementing features such as adding, updating, and deleting restaurants, as well as creating a review system with star ratings. Gain hands-on experience with Express middleware, environment variables, and Postgres aggregate functions. By the end of this course, you'll have built a fully functional Yelp clone and acquired the skills to develop robust web applications using the PERN stack.
Overview
Syllabus
Intro .
PERN Stack Intro .
Postgres Windows Install .
Postgres Mac install .
Postgres Documentation .
PSQL Basics .
SQL Tables .
Create Table .
Modify Tables .
Delete Databases .
Yelp Project Database .
Node Setup .
Express Setup .
Environment Variables .
First Express Route .
Restful API Convention .
Configure all routes .
Express Middleware .
Finishing Up Routes .
Connect Express and Postgres .
Get all Restaurants Route .
Gone one Restaurant Route .
Create a Restaurant Route .
Update A Restaurant Route .
Delete A Restaurant Route .
React Setup .
React Router Setup .
HomePage Layout .
React Context API .
Fetching Data .
Rendering Restaurants .
Adding Restaurants .
Deleting Restaurants .
Updating Restaurants .
Detail Page .
Reviews Intro .
Reviews Postgres Table .
Star Rating Component .
Reviews Component Layout .
Add Review .
Add Review Express Route .
Add Review React Component .
Postgres Aggregate Functions .
SQL Joins and Wrapping up App.
Taught by
freeCodeCamp.org
Related Courses
-
PERN Stack Course - Postgres, Express, React, and Node
-
MERN Stack Tutorial - Book Store Project
-
Build a Full Stack Book Store App Using React, Node, MongoDB, and Express
-
Node.js and Express.js - Full Course
4.8 -
Create an Instagram Clone with React, Tailwind CSS, Firebase - Tutorial
-
Full Stack React & Firebase Tutorial - Build a social media app
Related articles
Reviews
5.0 rating, based on 1 Class Central review
-
Pradeep SaiWell structured course, Like how all the tools used in real time jobs are used. Content is very clear, this is by far the best Fullstack course without any BS.
