PERN Stack Mega Course: Postgres Express React Node 6.5Hrs!

Github Repo: https://github.com/Sanjeev-Thiyagarajan/PERN-STACK-YELP-CLONE FYI React hooks will be used Today we are going to embark on a magical journey of learning the godfather of stacks... the justin timberlake of web stacks... the PERN!!!! Stack!!!!! That's right Mongo... suck it!!! If you've been living under a rock and have no idea what the PERN stack is, well you should probably rethink your sad life. But don't worry, with this course we're going to build a really really crappy full stack yelp clone using PERN and we're going to start from the absolute basics. If you've never worked with postgres before don't worry, papa is here to walk you through all of the basics starting with installing on mac/pc, creating databases/tables, making queries, adding entries, establishing relationship between tables, sql joins. After we show postgres who's boss, we're gonna ride express like the dirty pony that it is. We'll build a fully functional API for our crummy Yelp clone. Idk what else express can do and who really cares. Once we're done spanking express we'll move on to the hideous fronted, which is all done in React. We'll be using React Router for routing and i will only cover hooks, cause classes are for squares.. We will dabble with the context api for state management as well as the usual local state. this is gonna be 6.5 hrs of mind numbingly boring coding and I know you guys can't wait to get started. All code will be posted on github, because i know you morons can't follow along to a simple video. Subscribe to my Channel: https://www.youtube.com/channel/UC2sYgV-NV6S5_-pqLGChoNQ?sub_confirmation=1 https://twitter.com/Sanjeev_Tea https://www.instagram.com/sanjeev_tea/ If any of the react concepts are confusing to you, please check out my completely free course on react/redux https://www.courses.sloppynetworks.com/ timestamps 00:00 Intro 04:11 PERN Stack Intro 07:58 Postgres Windows Install 16:35 Postgres Mac install 29:13 Postgres Documentation 30:29 PSQL Basics 37:04 SQL Tables 38:53 Create Table 45:55 Modify Tables 48:28 Delete Databases 50:58 Yelp Project Database 01:09:57 Node Setup 01:12:45 Express Setup 01:15:57 Environment Variables 01:19:40 First Express Route 01:29:27 Restful API Convention 01:32:33 Configure all routes 01:42:34 Express Middleware 01:54:13 Finishing Up Routes 02:03:10 Connect Express and Postgres 02:14:20 Get all Restaurants Route 2:18:25 Gone one Restaurant Route 02:28:23 Create a Restaurant Route 02:35:28 Update A Restaurant Route 02:43:07 Delete A Restaurant Route 02:46:28 React Setup 02:52:52 React Router Setup 03:02:03 HomePage Layout 03:14:24 React Context API 03:20:17 Fetching Data 03:36:12 Rendering Restaurants 03:41:48 Adding Restaurants 03:56:26 Deleting Restaurants 04:03:05 Updating Restaurants 04:26:18 Detail Page 04:38:06 Reviews Intro 04:39:46 Reviews Postgres Table 04:55:20 Star Rating Component 05:02:49 Reviews Component Layout 05:08:18 Add Review 05:29:06 Add Review Express Route 05:37:43 Add Review React Component 05:48:04 Postgres Aggregate Functions 05:57:26 SQL Joins and Wrapping up App