Postgres Express React Node 6.5Hrs!

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