This course aims to teach learners how to build a Yelp clone using the PERN stack (PostgreSQL, Express, React, Node.js). By the end of the course, students will be able to install and work with PostgreSQL, create databases and tables, make queries, establish relationships between tables, understand SQL joins, set up a RESTful API, and build a full-stack web application. The course employs a hands-on approach with practical coding examples and step-by-step guidance. It is suitable for individuals interested in learning full-stack web development 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
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.
