PostgreSQL Learnings

A structured, hands-on PostgreSQL learning repository.
All files are self-contained .sql scripts with inline comments — designed to be readable after a long gap.

Topics Covered

• Database & Table Management (DDL)
• Data Insertion, Update, Delete (DML)
• Filtering, Sorting, Aggregations
• Joins (INNER, LEFT, RIGHT, FULL)
• Subqueries & CTEs
• Recursive CTEs
• Indexes & Query Optimization
• Transactions & Constraints

File Structure

PostgreSQL-copy/
└── Learnings/
    ├── Step1--Database_and_Table_Management
    ├── Step2--DML_Insert_Update_Delete
    ├── Step3--Filtering_Sorting_Aggregations
    ├── Step4--Joins
    ├── Step5--Subqueries_and_CTEs
    ├── Step6--Recursive_CTEs
    └── Step7--Indexes_Optimization_Transactions

Tools Used

• PostgreSQL 18+
• pgAdmin 4 (PSQL Tool)
• VS Code

Documentation

For deep reference:
PostgreSQL 18 Official Docs (PDF)