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
- Install PostgreSQL
- Connect to PostgreSQL DB
- Create Database in PostgreSQL
- Create Table in PostgreSQL Database
- Drop Table in PostgreSQL Database
- Truncate Table in PostgreSQL
- SELECT Statement in PostgreSQL
- WHERE Clause
- GROUP BY Clause
- HAVING Clause
- GROUPING SETS
- GROUPING() Function
- GROUP BY CUBE
- GROUP BY ROLLUP
- UNION Operator
- INTERSECT Operator
- EXCEPT Operator
- Sequence in PostgreSQL
- Serial Type
- Create Identity Columns
- Create Computed Columns
Constraints
DML Statements
- ALTER Table in PostgreSQL
- Rename Table in PostgreSQL
- Rename Columns of a Table in PostgreSQL
- Add Columns in a Table in PostgreSQL
- Modify Column Type in PostgreSQL
- Set Default Value of Column
- Remove Columns from a Table in PostgreSQL
- Add Constraints to Table in PostgreSQL
- Insert Data into Table in PostgreSQL
- Upsert (Insert or Update) Data in PostgreSQL
- Update Data in PostgreSQL
- Delete Data in PostgreSQL