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
- Copy Table
- Drop Table in PostgreSQL Database
- Drop Database in PostgreSQL
- Truncate Table in PostgreSQL
- SELECT Statement in PostgreSQL
- WHERE Clause
- GROUP BY Clause
- HAVING Clause
- ORDER BY Clause
- DISTINCT Clause
- Inner Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Self Join
- Natural Join
- Cross Join
- LIMIT OFFSET Clause
- GROUPING SETS
- GROUPING() Function
- GROUP BY CUBE
- GROUP BY ROLLUP
- Sub Query
- CASE Expressions
- ALL Operator
- ANY Operator
- UNION Operator
- INTERSECT Operator
- EXCEPT Operator
- IS NULL, IS NOT NULL Operator
- BETWEEN Operator
- LIKE Operator
- CAST 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