Skip to main content
C C++ Java Python PHP C# HTML CSS JavaScript Bootstrap Node.js Express.js React.js Next.js Tailwind TypeScript Dart Angular Vue.js Spring Boot Django Flask ASP.NET Material UI Chakra UI Sass MongoDB MySQL Oracle C C++ Java Python PHP C# HTML CSS JavaScript Bootstrap Node.js Express.js React.js Next.js Tailwind TypeScript Dart Angular Vue.js Spring Boot Django Flask ASP.NET Material UI Chakra UI Sass MongoDB MySQL Oracle
SQL Server Firebase PostgreSQL MariaDB Swift Kotlin React Native R Julia Scala NLP ML DP NN Gen AI JUnit Jest Pytest Selenium Cypress AWS Azure Google Cloud Stack Queue Linked List Trees Graphs SQL Server Firebase PostgreSQL MariaDB Swift Kotlin React Native R Julia Scala NLP ML DP NN Gen AI JUnit Jest Pytest Selenium Cypress AWS Azure Google Cloud Stack Queue Linked List Trees Graphs
Intermediate 11 planned topics Databases

Introduction to PostgreSQL

Learn PostgreSQL SQL, types, and indexes. Free PostgreSQL introduction for backend developers.

Learning Outcomes

  • Create tables and run SQL
  • Use joins and aggregate functions
  • See JSON/JSONB as a bonus feature
  • Explain ACID at a beginner level

Overview

PostgreSQL is an advanced open-source relational database with rich types, JSON support, and strong standards compliance.

This page introduces schemas, queries, and why teams pick Postgres over lighter engines.

It is the default database in many Django, Node, and Java stacks.

What this course will cover

  1. 1. Install & psql
  2. 2. SQL
  3. 3. Joins
  4. 4. Indexes
  5. 5. JSON
  6. 6. Transactions

Start a complete tutorial now

Full 6-level lessons are live for C, C++, Java, Python, and JavaScript. Use them while the remaining PostgreSQL lessons are added.

← All technology tutorials