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.
45 days
Intermediate
Live online · One-to-one available · Group batches when scheduled
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.
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.
- Write CREATE TABLE customers with an identity primary key.
- Add a required email column and a uniqueness constraint.
- Explain what happens when two rows use the same email.
Check your result: The schema rejects duplicate emails and missing required values.
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.
- PostgreSQL Orders: Reporting & Query Plans
Intermediate · Databases & SQL
- Django REST API: Validated Task Endpoint
Intermediate · Backend Engineering
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
Chapters, Core Topics & Guided Tasks
Every chapter closes with a guided implementation task. The complete course ends with one portfolio-ready capstone project.
Curriculum Validation Basis
Core chapters are cross-checked against current official technology documentation and authoritative standards or academic references.
- 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.
- Chapter 02
Querying & Relationships
Core topics
- Joins and aggregations
- CTEs and windows
- Views
Guided chapter task
Build reusable reporting views across related tables.
- 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.
- 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.
- 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.
- 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.
Who is this course for?
Backend developers, full-stack engineers, and database administrators.
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
* Free Demo is a 1-on-1 trial session, not the complete course.
Related Technical Courses
Database Fundamentals
Normalization, ACID properties & relational design
Learn relational database concepts, entity-relationship diagrams (ERDs), normalization, primary/foreign keys, and data integrity.
- database fundamentals course
- learn database design
- erd normalization
SQL
Complex queries, window functions & indexing strategies
Master structured querying: SELECT, WHERE, JOINs, GROUP BY, subqueries, window functions, and data manipulation.
- sql course online
- learn sql
- sql queries and joins tutorial
MySQL
Engine architecture, transactions & replication
Learn MySQL database configuration, relational table creation, indexing, stored queries, and backup/restore workflows.
- mysql course
- learn mysql database
- mysql workbench tutorial
Ready to start your learning journey?
Apply today and our admissions team will review your application and guide you through the next steps.