PERN Stack Mega Course: Postgres Express React Node 6.5Hrs!
Github Repo:
https://github.com/Sanjeev-Thiyagaraj...
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:
/ @sanjeevthiyagarajan / sanjeev_tea / 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
Sur cette page du site, vous pouvez voir la vidéo en ligne PERN Stack Mega Course: Postgres Express React Node 6.5Hrs! durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Sanjeev Thiyagarajan 24 juin 2020, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 26,344 fois et il a aimé 783 téléspectateurs. Bon visionnage!
