Learn PostgreSQL

Learn PostgreSQL

PostgreSQL is a powerful, advanced, fast, and open source object-relational database system based on POSTGRES, Version 4.2.

PostgreSQL supports a large part of the SQL standard with many modern features such as complex queries, triggers, updatable views, transactional integrity, multiversion concurrency control, etc. Additionally, PostgreSQL can be extended by the user by adding new data types, functions operators, aggregate functions, index methods, and procedural languages.

Basics

  1. Install PostgreSQL
  2. Connect to PostgreSQL DB
  3. Create Database in PostgreSQL
  4. Create Table in PostgreSQL Database
  5. Drop Table in PostgreSQL Database
  6. Truncate Table in PostgreSQL
  7. SELECT Statement in PostgreSQL
  8. WHERE Clause
  9. GROUP BY Clause
  10. HAVING Clause
  11. GROUPING SETS
  12. GROUPING() Function
  13. GROUP BY CUBE
  14. GROUP BY ROLLUP
  15. UNION Operator
  16. INTERSECT Operator
  17. EXCEPT Operator
  18. Sequence in PostgreSQL
  19. Serial Type
  20. Create Identity Columns
  21. Create Computed Columns

Constraints

  1. Constraints in PostgreSQL
  2. NOT NULL Constraint
  3. Unique Constraint
  4. Check Constraint
  5. Primary Key
  6. Foreign Key

DML Statements

  1. ALTER Table in PostgreSQL
  2. Rename Table in PostgreSQL
  3. Rename Columns of a Table in PostgreSQL
  4. Add Columns in a Table in PostgreSQL
  5. Modify Column Type in PostgreSQL
  6. Set Default Value of Column
  7. Remove Columns from a Table in PostgreSQL
  8. Add Constraints to Table in PostgreSQL
  9. Insert Data into Table in PostgreSQL
  10. Upsert (Insert or Update) Data in PostgreSQL
  11. Update Data in PostgreSQL
  12. Delete Data in PostgreSQL

Functions

  1. NULLIF()
  2. COALESCE()
  3. GREATEST(), LEAST()