Skip to main content
Database Management Intermediate

PostgreSQL

A COMPLETE beginner-to-advanced curriculum covering PostgreSQL. Learn relational database fundamentals, advanced SQL, JSONB, indexing, triggers, and full-stack integration.

30 chapters 3h 9m 4.6 (113)
Start Learning

What you'll learn

  • Introduction to PostgreSQL and Databases
  • Installing PostgreSQL and pgAdmin
  • Understanding Relational Databases
  • Creating Databases and Tables in PostgreSQL
  • PostgreSQL Data Types Explained
  • INSERT, UPDATE, and DELETE Queries
  • SELECT Queries and Filtering Data
  • Sorting, Searching, and Limiting Results

Course content

30 chapters Β· 3h 9m
  1. 1 Introduction to PostgreSQL and Databases 6 min
  2. 2 Installing PostgreSQL and pgAdmin 5 min
  3. 3 Understanding Relational Databases 7 min
  4. 4 Creating Databases and Tables in PostgreSQL 6 min
  5. 5 PostgreSQL Data Types Explained 6 min
  6. 6 INSERT, UPDATE, and DELETE Queries 6 min
  7. 7 SELECT Queries and Filtering Data 5 min
  8. 8 Sorting, Searching, and Limiting Results 6 min
  9. 9 SQL Operators and Conditional Statements 6 min
  10. 10 Aggregate Functions in PostgreSQL 6 min
  11. 11 GROUP BY and HAVING Clauses 6 min
  12. 12 Primary Keys, Unique Keys, and Sequences 6 min
  13. 13 Foreign Keys and Table Relationships 7 min
  14. 14 INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN 7 min
  15. 15 Advanced JOIN Queries and Set Operations 6 min
  16. 16 Subqueries and Common Table Expressions (CTEs) 6 min
  17. 17 Views and Materialized Views 7 min
  18. 18 Indexing and Query Optimization 7 min
  19. 19 Constraints and Data Integrity 7 min
  20. 20 Transactions and ACID Properties 7 min
  21. 21 Stored Procedures and Functions in PostgreSQL 6 min
  22. 22 Triggers and Event Automation 7 min
  23. 23 JSON and JSONB in PostgreSQL 6 min
  24. 24 Importing, Exporting, Backup, and Recovery 7 min
  25. 25 PostgreSQL Security Best Practices 7 min
  26. 26 Connecting PostgreSQL with PHP 6 min
  27. 27 Building CRUD Applications with PostgreSQL 5 min
  28. 28 PostgreSQL Performance Tuning 6 min
  29. 29 Real-World Database Design Projects 8 min
  30. 30 Final Project: Build a Complete PostgreSQL Database System 6 min