PERN Stack Course - Build a Yelp clone (Postgres, Express, React, Node.js)

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.

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.