Learn PostgreSQL

About: 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