Completed
Postgres Aggregate Functions
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
PERN Stack Course - Build a Yelp clone (Postgres, Express, React, Node.js)
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 PERN Stack Intro
- 3 Postgres Windows Install
- 4 Postgres Mac install
- 5 Postgres Documentation
- 6 PSQL Basics
- 7 SQL Tables
- 8 Create Table
- 9 Modify Tables
- 10 Delete Databases
- 11 Yelp Project Database
- 12 Node Setup
- 13 Express Setup
- 14 Environment Variables
- 15 First Express Route
- 16 Restful API Convention
- 17 Configure all routes
- 18 Express Middleware
- 19 Finishing Up Routes
- 20 Connect Express and Postgres
- 21 Get all Restaurants Route
- 22 Gone one Restaurant Route
- 23 Create a Restaurant Route
- 24 Update A Restaurant Route
- 25 Delete A Restaurant Route
- 26 React Setup
- 27 React Router Setup
- 28 HomePage Layout
- 29 React Context API
- 30 Fetching Data
- 31 Rendering Restaurants
- 32 Adding Restaurants
- 33 Deleting Restaurants
- 34 Updating Restaurants
- 35 Detail Page
- 36 Reviews Intro
- 37 Reviews Postgres Table
- 38 Star Rating Component
- 39 Reviews Component Layout
- 40 Add Review
- 41 Add Review Express Route
- 42 Add Review React Component
- 43 Postgres Aggregate Functions
- 44 SQL Joins and Wrapping up App
