PostgreSQL: Basic to Advanced

A complete bilingual PostgreSQL course, from what a relational database is all the way to MVCC, window functions, JSONB, full-text search, partitioning, replication and security. Every page is written in both English and Bengali, with runnable SQL examples.

Introduction to PostgreSQL

What is PostgreSQL?Installing PostgreSQL & Connecting psql, Databases & Schemas

Data Types & Table Basics

PostgreSQL Data Types Creating Tables ALTER, DROP & TRUNCATE

CRUD: Insert, Select, Update, Delete

INSERT, RETURNING & UPSERT SELECT Basics WHERE Clause & Operators UPDATE & DELETE

Sorting, Paging & Conditional Logic

ORDER BY, LIMIT & Pagination NULL, CASE & Conditional Expressions

Built-in Functions

String Functions Numeric & Math Functions Date & Time Functions

Aggregation & Grouping

Aggregate Functions GROUP BY, HAVING & GROUPING SETS

Joins & Set Operations

INNER JOIN LEFT, RIGHT & FULL Joins SELF JOIN, CROSS JOIN & Set Operations

Subqueries & CTEs

Subqueries & EXISTS CTEs & Recursive Queries

Keys, Constraints & Database Design

Constraints Primary Keys, Foreign Keys & Relationships Normalization & Schema Design

Views, Functions & Triggers

Views & Materialized Views Functions & Procedures (PL/pgSQL)Triggers & Event Automation

Transactions, MVCC & Locking

Transactions & ACID MVCC, Isolation Levels & Locking

Indexing & Query Performance

Indexes in PostgreSQL EXPLAIN & Query Optimization

Advanced PostgreSQL Features

Window Functions JSONB, Arrays & Full-Text Search Partitioning, Extensions & Replication

Administration, Backup & Security

Roles & Privileges Backup, Restore & Security Practice Exercises & Next Steps

PostgreSQL Tutorial — Basic to Advanced (English & Bengali) | DevNotes