PERN Stack Course - Build a Yelp clone (Postgres, Express, React, Node.js)
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
❤️ Try interactive React courses we love, right in your browser: https://scrimba.com/freeCodeCamp-React (Made possible by a grant from our friends at Scrimba)
⭐️ 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:1
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
Playlist
Uploads from freeCodeCamp.org · freeCodeCamp.org · 0 of 60
← Previous
Next →
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
React: Production Server Setup Part 2 - Live Coding with Jesse
freeCodeCamp.org
cookies vs localStorage vs sessionStorage - Beau teaches JavaScript
freeCodeCamp.org
Browser history tutorial - Beau teaches JavaScript
freeCodeCamp.org
Graph Data Structure Intro (inc. adjacency list, adjacency matrix, incidence matrix)
freeCodeCamp.org
React: Parameterized Routing with Next.js - Live Coding with Jesse
freeCodeCamp.org
React: Dealing with jQuery Issues - Live Coding with Jesse
freeCodeCamp.org
setInterval and setTimeout: timing events - Beau teaches JavaScript
freeCodeCamp.org
Browser and Device Testing - Live Coding with Jesse
freeCodeCamp.org
Last Minute Updates - Live Coding with Jesse
freeCodeCamp.org
Post Launch Updates - Live Coding with Jesse
freeCodeCamp.org
React: Setting Up Google Analytics - Live Coding with Jesse
freeCodeCamp.org
React: Masonry Layout - Live Coding with Jesse
freeCodeCamp.org
Load Balancing Digital Ocean Droplets - Live Coding with Jesse
freeCodeCamp.org
try, catch, finally, throw - error handling in JavaScript
freeCodeCamp.org
Load Balancing: SSL Passthrough Setup - Live Coding with Jesse
freeCodeCamp.org
Graphs: breadth-first search - Beau teaches JavaScript
freeCodeCamp.org
React: Masonry Layout Part 2 - Live Coding with Jesse
freeCodeCamp.org
React: WordPress API Live Search - Live Coding with Jesse
freeCodeCamp.org
Creating WordPress Custom Post Types - Live Coding With Jesse
freeCodeCamp.org
Dates - Beau teaches JavaScript
freeCodeCamp.org
Miscellaneous Front End Updates - Live Coding with Jesse
freeCodeCamp.org
Merging a Pull Request from GitHub - Live Coding with Jesse
freeCodeCamp.org
React + Prettier + Standard JS - Live Coding with Jesse
freeCodeCamp.org
React: Sortable Responsive Table - Live Coding with Jesse
freeCodeCamp.org
Geolocation Sorting by Distance - Live Coding with Jesse
freeCodeCamp.org
Tradeoff Matrix - Agile Software Development
freeCodeCamp.org
The Definition of Ready - Agile Software Development
freeCodeCamp.org
Getting first React job without experience - Ask Preethi
freeCodeCamp.org
React: Google Analytics Click Tracking - Live Coding with Jesse
freeCodeCamp.org
Submitting a PR to an Open Source Project - Live Coding with Jesse
freeCodeCamp.org
Should I go back to school to get CS degree? - Ask Preethi
freeCodeCamp.org
Hero Section CSS Changes - Live Coding with Jesse
freeCodeCamp.org
Working Agreement - Agile Software Development
freeCodeCamp.org
A day at Pennybox with Co-Founder Reji Eapen
freeCodeCamp.org
React: Sorting and Filtering Data - Live Coding with Jesse
freeCodeCamp.org
React: Sorting and Filtering Data Part 2 - Live Coding with Jesse
freeCodeCamp.org
React: Building a New UI - Live Coding with Jesse
freeCodeCamp.org
Definition of Done - Agile Software Development
freeCodeCamp.org
Getting started with jQuery (tutorial) - Beau teaches JavaScript
freeCodeCamp.org
Making a React Blog with WordPress Content - Live Coding with Jesse
freeCodeCamp.org
React, NextJS, CSS - Live Coding with Jesse
freeCodeCamp.org
jQuery events - Beau teaches JavaScript
freeCodeCamp.org
React/NextJS Routing and WordPress API Custom Types - Live Coding with Jesse
freeCodeCamp.org
React: Working with API Data - Live Coding with Jesse
freeCodeCamp.org
React: Refactoring Components - Live Streaming with Jesse
freeCodeCamp.org
jQuery effects - Beau teaches JavaScript
freeCodeCamp.org
More React Refactoring - Live Coding with Jesse
freeCodeCamp.org
animate in jQuery - Beau teaches JavaScript
freeCodeCamp.org
"Finishing" My React Site - Live Coding with Jesse
freeCodeCamp.org
Starting a New React Project (P2D1) - Live Coding with Jesse
freeCodeCamp.org
React Project 2 Day 2: Learning Material UI - Live Coding with Jesse
freeCodeCamp.org
The Agile Manifesto - Agile Software Development
freeCodeCamp.org
jQuery: get and set with http, text, val, and attr - Beau teaches JavaScript
freeCodeCamp.org
React Project 2 Day 3 - Live Coding with Jesse
freeCodeCamp.org
The INVEST approach to product backlog items
freeCodeCamp.org
React Project 2 Day 4 - Live Coding with Jesse
freeCodeCamp.org
Chickens and Pigs - Agile Software Development
freeCodeCamp.org
React Project 2 Day 5 - Live Coding with Jesse
freeCodeCamp.org
jQuery: add and remove DOM elements - Beau teaches JavaScript
freeCodeCamp.org
React Project 2 Day 6 - Live Coding with Jesse
freeCodeCamp.org
More on: Backend Performance
View skill →Related AI Lessons
⚡
⚡
⚡
⚡
Top 30 TypeScript Interview Questions & Answers for Freshers and Experienced
Medium · JavaScript
Cookies vs Local Storage vs Session Storage: What’s the Difference?
Medium · JavaScript
Two Projects That Taught Me More Than Any Tutorial - HNG14 Internship Reflections
Dev.to · PrimoCrypt
Why Most Coding Apps Teach You Lessons, Not Coding
Medium · Programming
🎓
Tutor Explanation
DeepCamp AI