PostgreSQL Course Index – Dataplexa

PostgreSQL Course Index

Complete PostgreSQL learning roadmap — 45 structured lessons from database fundamentals to advanced, enterprise, and cloud-level PostgreSQL usage.

Open PostgreSQL Course Back to Learning Hub

I. Foundations Level (12 Lessons)

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 Level (14 Lessons)

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 (12 Lessons)

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 Level (7 Lessons)

39. Query Optimization 40. Stored Procedures & Functions 41. Triggers 42. JSON & JSONB 43. Users, Roles & Security 44. Backup & Restore 45. PostgreSQL on AWS (RDS)