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. Sequence in PostgreSQL
  16. Serial Type
  17. Create Identity Columns
  18. 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