✅ What is PostgreSQL? Why is it different from other RDBMS?
✅ PostgreSQL Data Types (Numeric, Character, Boolean, Date/Time, JSON, Arrays, hstore, ENUM, UUID, Geometric)
✅ PostgreSQL Schema, Tables, and Constraints (Primary Key, Foreign Key, Unique, Check, NOT NULL, DEFAULT)
✅ Normalization (1NF, 2NF, 3NF, BCNF, 4NF, 5NF) and Denormalization
✅ Views, Materialized Views, and Temporary Tables
✅ Stored Procedures, Functions, and Triggers
1️⃣ What are the key differences between PostgreSQL and MySQL?
2️⃣ How does PostgreSQL handle composite types and arrays?
3️⃣ What is the difference between a View and a Materialized View?
✔ Create a PostgreSQL schema with multiple tables using primary and foreign keys.
✔ Implement Materialized Views and compare their performance with normal views.