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