Learn PostgreSQL.
Follow a practical PostgreSQL learning path covering fundamentals, SQL, advanced features and real database concepts.
PostgreSQL Tutorials
Explore practical topics and learn at your own pace.
PostgreSQL Basics
Understand PostgreSQL, its architecture and core concepts.
Explore →Installation & Setup
Get PostgreSQL running and connect to your database.
Explore →CREATE DATABASE
Create, alter and manage PostgreSQL databases.
Explore →CREATE TABLE
Build tables with suitable columns and constraints.
Explore →Data Types
Learn numeric, text, date/time, UUID, JSONB and more.
Explore →SELECT Queries
Retrieve and explore data using SELECT.
Explore →WHERE
Filter records using conditions and logical operators.
Explore →ORDER BY & LIMIT
Sort results and control the number of rows returned.
Explore →Joins
Combine data from multiple PostgreSQL tables.
Explore →Indexes
Understand indexing and query performance.
Explore →JSONB
Work with semi-structured JSON data.
Explore →Advanced PostgreSQL
Explore CTEs, window functions and other advanced features.
Explore →Learning Paths
Follow a structured route instead of learning randomly.
PostgreSQL in 30 Days
A practical day-by-day route from installation to advanced PostgreSQL concepts.
Advanced PostgreSQL
Continue with powerful features used in real-world PostgreSQL systems.
Keep learning with LOVE COMPUTER
Explore more tutorials, practical guides and technology articles.
Visit the Blog