PostgreSQL
I. Foundations
1. Introduction to Databases
2. SQL vs NoSQL Databases
3. What is PostgreSQL
4. PostgreSQL Features & Advantages
5. Installing PostgreSQL
6. PostgreSQL Architecture
7. PostgreSQL Tools (psql & pgAdmin)
8. Creating Databases & Schemas
9. PostgreSQL Data Types
10. Creating Tables
11. Constraints & Keys
12. NOT NULL, DEFAULT & CHECK
II. Core SQL
13. Altering Tables
14. Drop & Truncate Tables
15. Identity Columns & Sequences
16. INSERT Data
17. SELECT Queries
18. WHERE & Filtering
19. ORDER BY, LIMIT & OFFSET
20. UPDATE Data
21. DELETE Data
22. RETURNING Clause
23. Aggregate Functions
24. GROUP BY
25. HAVING Clause
26. NULL Handling
III. Advanced SQL & Performance
27. Table Relationships
28. INNER JOIN
29. LEFT, RIGHT & FULL JOIN
30. Subqueries
31. Views
32. Materialized Views
33. String Functions
34. Date & Time Functions
35. CASE Expressions
36. Indexes
37. Transactions & ACID
38. Locks & Concurrency
IV. Enterprise & Cloud