POSTGRESQL¶

WHAT IS POSTGRESQL?¶

PostgreSQL is an open-source object-relational database system with over 15 years of active development. It has a proven architecture and a strong reputation for reliability, data integrity, and correctness.

OFFICIAL WEBSITE¶

INSTALLATION & SETUP¶

WINDOWS¶

LINUX¶

Ubuntu as an example.

RUNOOB¶

LEARNING PROGRESS¶

BASICS¶

• Install PostgreSQL on Linux
• Install PostgreSQL on Windows
• Install PostgreSQL on Mac
• PostgreSQL Syntax
• PostgreSQL Data Types
• PostgreSQL Create Database
• PostgreSQL Select Database
• PostgreSQL Delete Database
• PostgreSQL Create Table
• PostgreSQL Delete Table
• PostgreSQL Schema
• PostgreSQL INSERT INTO
• PostgreSQL SELECT
• PostgreSQL Operators
• PostgreSQL Expressions
• PostgreSQL WHERE
• PostgreSQL AND & OR
• PostgreSQL UPDATE
• PostgreSQL DELETE
• PostgreSQL LIKE
• PostgreSQL LIMIT
• PostgreSQL ORDER BY
• PostgreSQL GROUP BY
• PostgreSQL WITH
• PostgreSQL HAVING
• PostgreSQL DISTINCT

ADVANCED¶

• PostgreSQL CONSTRAINT
• PostgreSQL JOIN
• PostgreSQL UNION
• PostgreSQL NULL
• PostgreSQL ALIAS
• PostgreSQL TRIGGER
• PostgreSQL INDEX
• PostgreSQL ALTER TABLE Command
• PostgreSQL TRUNCATE TABLE
• PostgreSQL VIEW
• PostgreSQL MATTER
• PostgreSQL LOCK
• PostgreSQL SUBQUERY
• PostgreSQL AUTO INCREMENT
• PostgreSQL ACCESS
• PostgreSQL TIME/DATE
• PostgreSQL COMMON FUNCTIONS