Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

freeCodeCamp

PERN Stack Course - Build a Yelp clone (Postgres, Express, React, Node.js)

via freeCodeCamp

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
Projektbasierter Videokurs zum PERN-Stack (Postgres, Express, React, Node.js), in dem ein Yelp-Klon von Grund auf entsteht: Postgres-Installation und PSQL-Grundlagen, Tabellen anlegen und ändern, Node- und Express-Setup mit Umgebungsvariablen, RESTful-Routen und Middleware, Anbindung von Express an Postgres, CRUD-Routen für Restaurants sowie React mit Router, Context API, Datenabruf, Detailseite, Bewertungssystem mit Sternekomponente, Aggregatfunktionen und SQL-Joins. Geeignet für Lernende mit JavaScript-Grundkenntnissen, die erstmals eine vollständige Webanwendung bauen wollen.

Syllabus

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.

Taught by

freeCodeCamp.org

Reviews

5.0 rating, based on 1 Class Central review

Start your review of PERN Stack Course - Build a Yelp clone (Postgres, Express, React, Node.js)

  • Profile image for Pradeep Sai
    Pradeep Sai
    1
    Well structured course, Like how all the tools used in real time jobs are used. Content is very clear, this is by far the best Fullstack course without any BS.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.