PostgreSQL Lesson 42 – JSON & JSONB | Dataplexa

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
39. Query Optimization 40. Stored Procedures & Functions 41. Triggers 42. JSON & JSONB 43. Users, Roles & Security 44. Backup & Restore 45. PostgreSQL on AWS (RDS)
← Previous Course Index Next →