Skip to main content
Database
Intermediate
45 days

PostgreSQL

Leverage advanced relational features, JSONB, indexes, and performance tuning.

Learn the world's most advanced open-source database: PostgreSQL schema design, indexing, transactions, and JSON data.

PostgreSQL illustrated course poster
Pacing & Duration

45 days

Experience Level

Intermediate

Delivery Mode

Live online · One-to-one available · Group batches when scheduled

Learning Format

1-on-1 & small cohorts

Course overview

PostgreSQL is the top database choice for modern application engineering. This course dives into PostgreSQL installation, administration with pgAdmin, advanced data types (UUID, JSONB, arrays), indexing strategies (B-Tree, GIN), views, transactions, and performance query analysis with EXPLAIN.

Free, self-guided practice

Try a PostgreSQL starter exercise

A practical first task you can try independently, without registration or payment. These instructions are for self-study; they are not a free live class or a downloadable project.

Your task

Define a PostgreSQL table with basic integrity constraints.

  1. Write CREATE TABLE customers with an identity primary key.
  2. Add a required email column and a uniqueness constraint.
  3. Explain what happens when two rows use the same email.

Check your result: The schema rejects duplicate emails and missing required values.

Ungated self-study

Free projects to practice this course

Open a hands-on starter kit with runnable example code, project milestones and a downloadable checklist. No signup or tuition is required for the guide.

Browse all free projects

What you'll achieve

Core competencies developed through practical implementation and project work.

  • Install, administer, and configure PostgreSQL databases
  • Work with advanced types including JSONB and arrays for semi-structured data
  • Optimize query speed using indexes and query execution plans (EXPLAIN)
  • Write views, transactions, and stored routines for application backends
30–60 Day Structured Course

Chapters, Core Topics & Guided Tasks

Every chapter closes with a guided implementation task. The complete course ends with one portfolio-ready capstone project.

45 days 3–4 classes/week

Curriculum Validation Basis

Core chapters are cross-checked against current official technology documentation and authoritative standards or academic references.

  1. Chapter 01

    PostgreSQL Setup & Schema Design

    Core topics

    • Server and client tools
    • Schemas and data types
    • Keys and constraints

    Guided chapter task

    Create a typed, constrained schema from an ER model.

  2. Chapter 02

    Querying & Relationships

    Core topics

    • Joins and aggregations
    • CTEs and windows
    • Views

    Guided chapter task

    Build reusable reporting views across related tables.

  3. Chapter 03

    Indexes & Query Plans

    Core topics

    • B-tree and composite indexes
    • EXPLAIN and EXPLAIN ANALYZE
    • Query tuning basics

    Guided chapter task

    Diagnose and improve a deliberately slow query.

  4. Chapter 04

    PostgreSQL Data Features

    Core topics

    • JSONB
    • Arrays and useful extensions
    • Full-text search awareness

    Guided chapter task

    Model and query a feature that combines relational and JSONB data.

  5. Chapter 05

    Transactions & Server Logic

    Core topics

    • Isolation and locking
    • Functions and triggers
    • Integrity under concurrent changes

    Guided chapter task

    Protect a multi-step business operation with a transaction and constraint.

  6. Chapter 06

    Roles, Backup & Operations

    Core topics

    • Users and privileges
    • Backup and restore
    • Monitoring and maintenance awareness

    Guided chapter task

    Create least-privilege roles and verify a backup/restore workflow.

Complete Course Capstone

Portfolio Project

Build and tune a production-style PostgreSQL database with roles, JSONB, reports, and recovery documentation.

Prerequisites & Prior Knowledge

Recommended background before starting this course. Mentors adapt pacing to your current level.

Fundamental knowledge of SQL.
Target Audience

Who is this course for?

Backend developers, full-stack engineers, and database administrators.

Delivery & Mentoring

Hands-on Learning Format

  • Live interactive screen-sharing
  • 1-on-1 personalized instruction
  • Practical, portfolio-ready code

Contact admissions for current fee and available learning formats

Enrol in PostgreSQL

Start with a 1-on-1 trial session to discuss your technical goals with an instructor.

  • Duration: 45 days
  • Level: Intermediate
  • Delivery: Live online · One-to-one available · Group batches when scheduled
  • Format: 1-on-1 & small cohorts
Apply for this course Request Free Demo Trial

* Free Demo is a 1-on-1 trial session, not the complete course.

Ready to start your learning journey?

Apply today and our admissions team will review your application and guide you through the next steps.