Belajar PostgreSQLKursus Percuma PostgreSQLTutorial 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