Intro .
PERN Stack Intro .
Postgres Windows Install .
Postgres Mac install .
Postgres Documentation .
PSQL Basics .
SQL Tables .
Create Table .
Modify Tables .
Delete Databases .
Yelp Project Database .
Node Setup .
Express Setup .
Environment Variables .
First Express Route .
Restful API Convention .
Configure all routes .
Express Middleware .
Finishing Up Routes .
Connect Express and Postgres .
Get all Restaurants Route .
Gone one Restaurant Route .
Create a Restaurant Route .
Update A Restaurant Route .
Delete A Restaurant Route .
React Setup .
React Router Setup .
HomePage Layout .
React Context API .
Fetching Data .
Rendering Restaurants .
Adding Restaurants .
Deleting Restaurants .
Updating Restaurants .
Detail Page .
Reviews Intro .
Reviews Postgres Table .
Star Rating Component .
Reviews Component Layout .
Add Review .
Add Review Express Route .
Add Review React Component .
Postgres Aggregate Functions .
SQL Joins and Wrapping up App.