Learn PostgreSQL

Intro to PostgreSQL

Installing PostgreSQL on Windows

Using PostgreSQL on Windows

Executing SQL queries on Windows

Installing PostgreSQL on Mac

Using PostgreSQL on Mac

Executing SQL commands on Mac

SQL: SELECT command

SQL: filtering with WHERE

SQL: LIMIT (limit results)

SQL: UPDATE

SQL: DELETE

SQL Wildcards for filtering

JOINS

SQL: JOINs

SQL: GROUP BY

SQL: ORDER BY

SQL: CREATE TABLE

SQL: INSERT INTO

Dates in SQL

Nested SELECT statements

Other data types in SQL (including JSON in PostgreSQL)

JSON in PostgreSQL

SQL: VIEWs and what they are used for

Check Constraints

SQL PostgreSQL Functions