PostgreSQL Tutorial for Beginners - freeCodeCamp
Free 3h beginner course: install Postgres, create tables & query
A free ~3-hour beginner course aggregated on Class Central that teaches PostgreSQL from scratch on the freeCodeCamp YouTube channel. Learn how to install and set up PostgreSQL, create databases and tables, and work with primary keys, foreign keys, constraints, joins, and aggregate functions through hands-on, project-style examples. Perfect starting point for anyone new to relational databases.
Back EndFreebeginner~3 hours
Submitted by @yahianaimRoadmap (4 steps)
1
Getting started
~40 min#What is PostgreSQL#Installing PostgreSQL#psql Shell Basics
2
Databases & tables
~45 min#CREATE DATABASE#CREATE TABLE#Columns & Data Types
3
Keys & relationships
~45 min#Primary Keys#Foreign Keys#Table Relations
4
Querying
~50 min#SELECT & Filtering#Joins#Aggregate Functions