Learn the PERN stack by building a Yelp clone. The PERN stack includes PostgreSQL, Express, React, and Node. You will learn all the basics including installation, creating databases/tables, making queries, adding entries, establishing relationship between tables, SQL joins, and more. 💻 Code – https://github.com/Sanjeev-Thiyagarajan/PERN-STACK-YELP-CLONE 🎥 Course developed by Sanjeev Thiyagarajan. Check out his YouTube channel: https://www.youtube.com/channel/UC2sYgV-NV6S5_-pqLGChoNQ?sub_confirmation=1 ⭐️ Course Contents ⭐️ ⌨️ (0:00:00) Intro ⌨️ (0:04:11) PERN Stack Intro ⌨️ (0:07:58) Postgres Windows Install ⌨️ (0:16:35) Postgres Mac install ⌨️ (0:29:13) Postgres Documentation ⌨️ (0:30:29) PSQL Basics ⌨️ (0:37:04) SQL Tables ⌨️ (0:38:53) Create Table ⌨️ (0:45:55) Modify Tables ⌨️ (0:48:28) Delete Databases ⌨️ (0:50:58) Yelp Project Database ⌨️ (1:09:57) Node Setup ⌨️ (1:12:45) Express Setup ⌨️ (1:15:57) Environment Variables ⌨️ (1:19:40) First Express Route ⌨️ (1:29:27) Restful API Convention ⌨️ (1:32:33) Configure all routes ⌨️ (1:42:34) Express Middleware ⌨️ (1:54:13) Finishing Up Routes ⌨️ (2:03:10) Connect Express and Postgres ⌨️ (2:14:20) Get all Restaurants Route ⌨️ (2:18:25) Gone one Restaurant Route ⌨️ (2:28:23) Create a Restaurant Route ⌨️ (2:35:28) Update A Restaurant Route ⌨️ (2:43:07) Delete A Restaurant Route ⌨️ (2:46:28) React Setup ⌨️ (2:52:52) React Router Setup ⌨️ (3:02:03) HomePage Layout ⌨️ (3:14:24) React Context API ⌨️ (3:20:17) Fetching Data ⌨️ (3:36:12) Rendering Restaurants ⌨️ (3:41:48) Adding Restaurants ⌨️ (3:56:26) Deleting Restaurants ⌨️ (4:03:05) Updating Restaurants ⌨️ (4:26:18) Detail Page ⌨️ (4:38:06) Reviews Intro ⌨️ (4:39:46) Reviews Postgres Table ⌨️ (4:55:20) Star Rating Component ⌨️ (5:02:49) Reviews Component Layout ⌨️ (5:08:18) Add Review ⌨️ (5:29:06) Add Review Express Route ⌨️ (5:37:43) Add Review React Component ⌨️ (5:48:04) Postgres Aggregate Functions ⌨️ (5:57:26) SQL Joins and Wrapping up App — Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp