UNIT 1.....................................................................1
RDBMS + POSTGRESQL BASICS
1.1 RDBMS concepts, ACID, relational model
1.2 Schema, relationships, normalization purpose
1.3 PostgreSQL intro, ORDBMS features, MVCC
1.4 Installation on Windows (setup flow)
1.5 Installation (service start basics)
1.6 Core data types (numeric, text, date, bool, JSON)
1.7 Integrity overview: data vs entity integrity
UNIT 2........................................................................21
SQL ESSENTIALS
2.1 SELECT with WHERE, LIKE, BETWEEN, ORDER BY, LIMIT
2.2 INSERT, DEFAULT, NULL concept
2.3 UPDATE, DELETE with conditions
2.4 Operators: Arithmetic, Comparison, Logical
2.5 Aggregate: COUNT, AVG, MAX, MIN, SUM
2.6 String: LOWER, UPPER, LENGTH, SUBSTRING
2.7 Date/Time: CURRENT_DATE, AGE(), EXTRACT()
2.8 Set Ops: UNION, INTERSECT, EXCEPT
UNIT 3........................................................................54
KEYS, CONSTRAINTS, VIEWS, JOINS
3.1 Constraints: PK, FK, UNIQUE, NOT NULL, CHECK
3.2 Entity integrity vs referential integrity
3.3 Key’s role in spam/review datasets (example context)
3.4 Views: CREATE VIEW
UNIT 4........................................................................73
ADVANCED SQL + PL/PGSQL
4.1 Subqueries: constants, lists, multiple columns
4.2 Correlated subqueries (row-wise dependency)
4.3 EXISTS / ANY / ALL clauses
4.4 MERGE (UPSERT logic), MERGE syntax concept
4.5 Transactions: COMMIT, ROLLBACK
4.6 Index: CREATE INDEX, UNIQUE INDEX
4.7 Sequence: CREATE SEQUENCE, nextval(), currval(), setval()
4.8 Stored Procedures
4.9 Cursor- Implicit Cursor, Explicit Cursor
4.10 Functions
4.11 Triggers: DML triggers + RAISE error handling basics.
