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.
⭐️ 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
💻 Code - https://github.com/Sanjeev-Thiyagarajan/PERN-STACK-YELP-CLONE
#node #react #express #postgresql #developer