← Back to the cataloguePostgreSQL
Intermediate to Advanced
Level
Classroom . Online . Hybrid
Mode
Course overview
A PostgreSQL course covering advanced SQL, data types, extensions and server operations. The course uses PostgreSQL as it is meant to be used: strong constraints, rich types, JSONB where appropriate, CTEs and window functions, plus operational reality autovacuum, bloat, index types and replication.
Learners build a schema with constraints, tune a query workload and configure streaming replication.
Who it is for
- Backend developers
- Data engineers
- Database administrators
- Analysts writing advanced SQL
Prerequisites
Basic SQL knowledge.
How it runs
Learn → Practise → Build → Experience → Demonstrate, ending in a capstone. Delivered by practitioners from the engineering bench, in Madurai, Coimbatore and online.
Final project
Tuned, Replicated PostgreSQL Setup
Programme sheet
The printed sheet carries the full module breakdown, labs, project work and certification path. Fees, dates and formats for the next intake are confirmed by the education team on enquiry.
Learning outcomes
01
Design schemas using constraints and domains.
02
Write advanced SQL with CTEs and window functions.
03
Read EXPLAIN ANALYZE output and fix plans.
04
Configure backups and streaming replication.
05
Choose between relational and JSONB modelling.
06
Select the right index type for a workload.
07
Understand MVCC, vacuum and bloat.
08
Use extensions such as PostGIS and pg_stat_statements.
Module structure
8 modulesModule 01
PostgreSQL Foundations
Installation . psql . Roles . Extensions
Module 02
Data Types and Constraints
Numeric and text types . Enums . Domains . UUIDs . Arrays . Ranges
Lab
Constrained Schema . Check and Exclusion Constraints
Joins and lateral joins . Window functions . Upserts . Grouping sets . Returning clauses
Lab
Analytical Queries . CTEs and Recursion
Module 04
JSON and Full Text
JSON vs JSONB . Search vectors . Trigram search . Operators and indexing . Ranking . When not to use JSONB
Module 05
Indexes and Planning
B-tree, GIN, GiST, BRIN . EXPLAIN ANALYZE . Planner settings . Partial and expression indexes . Statistics
Module 06
Transactions and MVCC
Isolation levels . Row versions . Autovacuum . Bloat detection . Locks . Advisory locks
Views and materialised views . PL/pgSQL functions . Triggers . Partitioning . Foreign data wrappers
pg_dump and pg_basebackup . WAL . Point-in-time recovery . Streaming replication . Monitoring
Assessment & certification
Module assignments and labs
25%
Final project and review
40%
Learners who complete all modules, submit the final project and clear the review receive a course completion certificate from Kaizen Infinities Private Limited. Project work is documented for the learner's portfolio, and interview preparation is included in the closing sessions.
Career outcomes . Roles this programme prepares for
PostgreSQL DeveloperDatabase AdministratorData EngineerBackend EngineerPlatform Engineer
