EthicsComputerCourses
Join training

Web Development Build websites and web apps, from your first HTML page to React and Next.js.

Backend Development Server-side apps and APIs with Node.js, PHP, Django, Spring Boot and ASP.NET Core.

Programming Languages Core languages for college, coding interviews and real projects.

Mobile Development Build Android and iOS apps with Flutter and Swift.

Computer Science Core Operating systems, networks, DBMS and system design for college, GATE and interviews.

Databases Store, query and design data with SQL, PostgreSQL and MongoDB.

Data Science & AI Statistics, data analysis, dashboards and machine learning.

Cloud, DevOps & Testing Containers, Kubernetes, the cloud and software testing.

Security & Systems Protect systems and work confidently on Linux servers.

IoT & Electronics Build smart devices with Arduino, sensors and Raspberry Pi.

Office, Accounts & Career Computer basics, Excel, Tally with GST and digital marketing for jobs and business.

New to coding? Start with Intro to Programming Browse all 68 tutorials
EthicsComputerCourses
Join training +91 90532 10052
  1. Tutorials
  2. PostgreSQL Tutorial

PostgreSQL Tutorial

Learn PostgreSQL 18 from psql basics to JSONB, window functions, indexes and PL/pgSQL, with examples that run in your browser.

32 free lessons Beginner to Advanced Covers PostgreSQL 18 (18.6; the browser examples run on PostgreSQL 18.6 too)

Start the first lesson

Getting Started Beginner

  1. 1PostgreSQL Introduction
  2. 2Install PostgreSQL
  3. 3psql & Meta-commands
  4. 4pgAdmin & the Practice Database
  5. 5Databases, Schemas & Tables

Data Types & Table Design Beginner

  1. 6Numbers, Text & Boolean Types
  2. 7Dates, Times & Time Zones
  3. 8UUID, Enum & Range Types
  4. 9Constraints & Keys
  5. 10Identity Columns vs SERIAL

Changing Data Beginner

  1. 11INSERT, UPDATE & DELETE with RETURNING
  2. 12Upsert: ON CONFLICT & MERGE

Powerful Queries Intermediate

  1. 13Joins, Aggregates & FILTER
  2. 14Window Functions
  3. 15CTEs & Recursive Queries
  4. 16LATERAL Joins & generate_series
  5. 17String Functions & Regular Expressions

Arrays, JSON & Search Intermediate

  1. 18Arrays
  2. 19JSON & JSONB
  3. 20Full-text Search

Performance & Concurrency Intermediate

  1. 21Index Types: B-tree, GIN, GiST & BRIN
  2. 22EXPLAIN & EXPLAIN ANALYZE
  3. 23Transactions, Isolation & MVCC

Server-side Programming Advanced

  1. 24Views & Materialized Views
  2. 25PL/pgSQL Functions & Procedures
  3. 26Triggers

Administration & Applications Advanced

  1. 27Roles, Privileges & Row-Level Security
  2. 28Table Partitioning
  3. 29Backup, Restore & Replication
  4. 30Extensions: PostGIS, pgvector & More
  5. 31Connect from Python, Node.js & PHP

Project Project

  1. 32Project: Shop Reporting Database

Learn PostgreSQL with a mentor

Free lessons get you started. Our Full Stack Web Development training adds real projects and code reviews from working developers.

  • Project-based learning
  • Mentor code reviews
  • Free counselling call
Get course details +91 90532 10052