PostgreSQL is one of the most advanced general-purpose Relational database management systems (RDMS). It is open-source software, which means the source code is available under the PostgreSQL license. Anyone with the right skills is free to use, modify, and distribute PostgreSQL in any form. It supports both relational as well as Non-Relational JSON Queries.

PostgreSQL Tutorial What is PostgreSQL - Introduction Install PostgreSQL on Windows Install PostgreSQL on Mac

PostgreSQL - Create Database PostgreSQL - Loading a Database PostgreSQL - ALTER DATABASE PostgreSQL - Rename Database PostgreSQL - Show Databases

PostgreSQL - Data Types PostgreSQL - Boolean Data Type PostgreSQL - CHAR Data Type PostgreSQL - VARCHAR Data Type PostgreSQL - NUMERIC Data Type PostgreSQL - Date Data Type PostgreSQL - TIME Data Type PostgreSQL - JSON Data Type PostgreSQL - CREATE DOMAIN

PostgreSQL - SELECT PostgreSQL - ORDER BY clause PostgreSQL - WHERE clause PostgreSQL - FETCH clause PostgreSQL - IN operator PostgreSQL - HAVING clause PostgreSQL - GROUP BY clause PostgreSQL - LIKE operator PostgreSQL - BETWEEN operator

PostgreSQL - CREATE TABLE PostgreSQL - SELECT INTO PostgreSQL - CREATE SEQUENCE PostgreSQL - ALTER TABLE PostgreSQL - ADD COLUMN PostgreSQL - DROP COLUMN PostgreSQL - Rename Table PostgreSQL - DROP TABLE PostgreSQL - TRUNCATE TABLE PostgreSQL - Copy a Table PostgreSQL - Comparing Tables PostgreSQL - Show Tables

PostgreSQL - INSERT PostgreSQL - Insert Multiple Values in Various Rows PostgreSQL - UPDATE PostgreSQL - DELETE PostgreSQL - Upsert

PostgreSQL - CASE PostgreSQL - COALESCE PostgreSQL - NULLIF() Function PostgreSQL - CAST

PostgreSQL - IF Statement PostgreSQL - CASE Statement PostgreSQL - Loop Statement PostgreSQL - While Loops PostgreSQL - Exit PostgreSQL - Continue

PostgreSQL - Transactions PostgreSQL - COMMIT PostgreSQL - Primary Key PostgreSQL - Foreign Key PostgreSQL - CHECK Constraint PostgreSQL - UNIQUE Constraint PostgreSQL - NOT NULL Constraint

PostgreSQL - Joins PostgreSQL - LEFT JOIN PostgreSQL - INNER JOIN PostgreSQL - FULL OUTER JOIN PostgreSQL - SELF JOIN PostgreSQL - Schema PostgreSQL - CREATE SCHEMA PostgreSQL - DROP SCHEMA PostgreSQL - ALTER SCHEMA

PostgreSQL - CREATE ROLE PostgreSQL - ALTER ROLE PostgreSQL - DROP ROLE PostgreSQL - GRANT PostgreSQL - REVOKE PostgreSQL - Role Membership

PostgreSQL - UNION operator PostgreSQL - INTERSECT Operator PostgreSQL - EXCEPT Operator PostgreSQL - ANY Operator PostgreSQL - ALL Operator PostgreSQL - EXISTS Operator

PostgreSQL - CREATE FUNCTION Statement PostgreSQL - Function Overloading PostgreSQL - Drop Function PostgreSQL - MAX() Function PostgreSQL - MIN() Function PostgreSQL - SUM() Function PostgreSQL - COUNT() Function PostgreSQL - EXTRACT Function PostgreSQL - REPLACE Function

PostgreSQL - Errors and Messages Exception Handling in PL/SQL PostgreSQL - Assert

PostgreSQL - Dollar-Quoted String Constants PostgreSQL - Block Structure PostgreSQL - Variables PostgreSQL - Introduction to Stored Procedures PostgreSQL - Trigger PostgreSQL - CREATE TRIGGER PostgreSQL - DROP TRIGGER PostgreSQL - Disabling a Trigger PostgreSQL - Enabling a Trigger PostgreSQL - CREATE INDEX PostgreSQL - List Indexes PostgreSQL - UNIQUE Index