📍 Module 1: Introduction to PostgreSQL

• What is PostgreSQL and Why Use It?

• PostgreSQL Features vs MySQL/SQL Server/Oracle

• Installing PostgreSQL (Windows/Linux/macOS)

• Using psql CLI and pgAdmin GUI

• PostgreSQL Architecture Overview

📍 Module 2: SQL Basics with PostgreSQL

• Creating Databases and Tables

• Data Types and Constraints

• SELECT, INSERT, UPDATE, DELETE Queries

• Filtering, Sorting, and Aliases

• Joins: INNER, LEFT, RIGHT, FULL

• Aggregate Functions (COUNT, SUM, AVG, etc.)

• GROUP BY, HAVING, ORDER BY

📍 Module 3: Advanced SQL & PostgreSQL Functions

• Subqueries and Common Table Expressions (CTEs)

• Window Functions

• Views and Materialized Views

• Functions: Built-in and User-defined

• String, Date, and Numeric Functions

• CASE, COALESCE, NULLIF

📍 Module 4: Data Modeling & Schema Design

• Normalization (1NF to 3NF)

• Primary & Foreign Keys

• Composite Keys and Unique Constraints

• ENUMs, JSON, and Arrays in PostgreSQL

• Schema Design Best Practices

📍 Module 5: Indexing & Performance Tuning

• Index Types: B-tree, Hash, GIN, GiST

• EXPLAIN and Query Plans

• VACUUM, ANALYZE, and Autovacuum

• Optimizing Joins and Queries

• Query Caching and Table Partitioning

📍 Module 6: PostgreSQL Programming with PL/pgSQL

• Introduction to PL/pgSQL

• Stored Procedures and Functions

• Triggers and Events

• Exception Handling

• Control Structures: IF, WHILE, LOOP

📍 Module 7: PostgreSQL Administration (DBA Basics)

• User Roles and Privileges

• Backup and Restore (pg_dump, pg_restore)

• Tablespace Management

• PostgreSQL Configuration Files

• Logging and Monitoring

• Security Best Practices

📍 Module 8: Working with PostgreSQL in Applications

• Connecting PostgreSQL with Python (psycopg2) / Node.js (pg)

• CRUD Operations via APIs

• ORM Integration (SQLAlchemy / Sequelize)

• Transactions and Locking Mechanisms

• Using PostgreSQL in Docker

📍 Module 9: PostgreSQL on Cloud (Optional)

• PostgreSQL on AWS RDS / Google Cloud SQL / Azure

• Introduction to Supabase and PostgreSQL as Backend

• Scaling and High Availability Basics

• Connecting to Cloud Databases from Local

📍 Module 10: Real-Time Projects

• Library / Inventory Management System

• Blogging System with PostgreSQL Backend

• Analytics Dashboard with Aggregates and Views

• Performance Testing & Query Tuning in a Live DB

• Project Documentation + GitHub Upload