---
title: PostgreSQL
description: PostgreSQL is an advanced, open-source object-relational database system known for reliability and feature robustness. Learners will understand relational concepts, complex querying, indexing, custom data types, and writing stored procedures.
category: programming-tech
subcategory: databases
difficulty: beginner, intermediate, advanced
url: /subject/postgresql
---

# PostgreSQL

PostgreSQL is an advanced, open-source object-relational database system known for reliability and feature robustness. Learners will understand relational concepts, complex querying, indexing, custom data types, and writing stored procedures.

## Available Resources

1 Videos • 4 Websites

## Websites

### 1. PostgreSQL Tutorial

A structured set of free PostgreSQL lessons covering SQL syntax, joins, subqueries, indexes, stored procedures, and administration, each with a sample database and runnable examples. After working through it you can write and tune everyday Postgres queries.

**Difficulty:** Beginner | **Language:** English | **Price:** Free

**Link:** https://neon.com/postgresql/tutorial

**Tags:** postgresql, sql, joins, stored-procedures, indexes

### 2. Crunchy Data PostgreSQL Tutorials

High-quality, free tutorials and guides by experts from Crunchy Data, covering practical aspects, development, and administration best practices for PostgreSQL.

**Difficulty:** Intermediate | **Language:** English | **Price:** Free

**Link:** https://www.crunchydata.com/developers/tutorials/

**Tags:** postgresql, sql, database-administration, query-optimization, tutorials

### 3. PostgreSQL Wiki

A community-driven resource with practical how-tos, guides, and in-depth articles on specific PostgreSQL features, complementing the official documentation.

**Difficulty:** Intermediate | **Language:** English | **Price:** Free

**Link:** https://wiki.postgresql.org/wiki/Main_Page

**Tags:** postgresql, sql, database-administration, performance-tuning, community-wiki

### 4. PostgreSQL Official Documentation

The definitive and comprehensive source for PostgreSQL, covering installation, basic usage, advanced features, administration, and includes tutorials and guides.

**Difficulty:** Beginner | **Language:** English | **Price:** Free

**Link:** https://www.postgresql.org/docs/

**Tags:** postgresql, sql, database-administration, reference-documentation, relational-databases

## Videos

### 1. Learn PostgreSQL Tutorial - Full Course for Beginners

Four-hour freeCodeCamp course walking through PostgreSQL from installation and psql basics to table design, constraints, joins, aggregate functions, exporting data and UUID keys. Viewers finish able to set up a database and run realistic queries against it.

**Difficulty:** Beginner | **Price:** Free

**Link:** https://www.youtube.com/watch?v=qw--VYLpxG4

**Tags:** postgresql, sql, psql, database-design, freecodecamp

## Podcasts

### 1. Postgres.FM Podcast

A highly respected podcast featuring interviews and discussions with PostgreSQL experts, providing valuable insights and community knowledge on various topics.

**Difficulty:** Intermediate | **Language:** English | **Price:** Free

**Link:** https://postgres.fm/

**Tags:** postgresql, database-performance, database-administration, query-optimization

---

*This content is part of Dantes.io - Your Treasure Map to Knowledge*

*Curated by humans at Dantes.io. Personal study use welcome; republishing this curation requires permission (team@dantes.io).*

View this page online: https://dantes.io/subject/postgresql