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