SQL & PostgreSQL · Full Stack Web Development

Explanation

Relational databases model data in tables. Learn SELECT, JOIN, indexes, and PostgreSQL essentials.

Code example

sql

CREATE TABLE skills (
  id UUID PRIMARY KEY,
  name TEXT NOT NULL UNIQUE,
  level TEXT NOT NULL
);

INSERT INTO skills (id, name, level)
VALUES (gen_random_uuid(), 'React', 'intermediate');

SELECT name, level FROM skills ORDER BY name;

Helpful resources

PostgreSQL official docs
Official PostgreSQL documentation.
DocumentationFreeOfficial90 min
SQL & PostgreSQL — freeCodeCamp
Full SQL course on YouTube.
YoutubeFree240 min

Exercise

Design tables for users and skills, insert sample rows, and write JOIN queries.

Your notes