TechBuilt Open SchoolInternational Online Academy
Database course

PostgreSQL

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

Database
Intermediate

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.

Prerequisites

Fundamental knowledge of SQL.

What you'll achieve

  • 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

Curriculum

  1. 1PostgreSQL installation, architecture & pgAdmin setup
  2. 2Advanced data types: UUID, TIMESTAMP with time zone, Arrays & JSONB
  3. 3Querying and indexing JSONB documents within relational tables
  4. 4Indexes in PostgreSQL: B-Tree, GIN, unique & composite indexes
  5. 5Views, materialized views & triggers overview
  6. 6Transactions, isolation levels & concurrency control
  7. 7Query optimization and execution plan analysis with EXPLAIN ANALYZE
  8. 8Project: Production-ready PostgreSQL schema for a SaaS application

Who is this for?

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

Contact admissions for current fee and available learning formats

Enrol in PostgreSQL

  • 6 weeks
  • Intermediate
  • Live online · One-to-one available · Group batches when scheduled
  • 1-on-1 & small batches
Apply for this course Request Free Demo Have questions? Ask on WhatsApp

Related courses

Database

Database Fundamentals

Learn relational database concepts, entity-relationship diagrams (ERDs), normalization, primary/foreign keys, and data integrity.

4 weeks Beginner
View course
Database

SQL

Master structured querying: SELECT, WHERE, JOINs, GROUP BY, subqueries, window functions, and data manipulation.

6 weeks Beginner to Intermediate
View course
Database

MySQL

Learn MySQL database configuration, relational table creation, indexing, stored queries, and backup/restore workflows.

5 weeks Beginner to Intermediate
View course

Ready to start your learning journey?

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

Apply Now Talk to us on WhatsApp