[email protected] +91 9541 551 557 +91 9035 406 484
Synergific Store LMS Login Training Calendar

PostgreSQL

Live Online (VILT) & Classroom Corporate Training Course

PostgreSQL is a powerful, open source, object-relational database system known for being reliable and precise. It runs on all major operating systems, including Linux, macOS, and Windows.

Expert-Led VILT & Classroom Hands-On CloudLabs Certification Voucher Available
CloudLabs
Projects
Assessments
24/7 Support
Lifetime Access

Overview

PostgreSQL training teaches attendees how to build, query, program stored procedures in PL/pgSQL, and administer the popular, open source PostgreSQL database platform.

Objectives

At the end of PostgreSQL training course, participants will be able to

  • Find PostgreSQL documentation and resources
  • Work with PostgreSQL functions and create own functions
  • Program with PL/pgSQL
  • Install and setup PostgreSQL securely
  • Work with basic administration tasks such as user creation, cataloging, and backing up
  • Use SLONY and PGPOOL
  • Work with inheritance in PostgreSQL
  • Use Tablespaces, EXPLAIN Statement, PITR and monitor the database
  • Tune the PostgreSQL Server

Prerequisites

Participants must have a solid understanding of basic relational database principles and SQL SELECT statements prior to this training.

Course Outline

  • History and Overview
  • PostgreSQL Major Features
  • PostgreSQL Limits
  • PostgreSQL Architecture
  • MVCC
  • Write Ahead Logs
  • The Background Writer
  • PostgreSQL Data Types

  • Overview
  • Binary Installation
  • Source Installation
  • Initializing a PostgreSQL cluster
  • Starting and stopping a PostgreSQL cluster
  • Automatic startup/shutdown

  • Access Control
  • Connection settings
  • Security and Authentication settings
  • Memory settings
  • Kernel resource settings
  • Log management
  • Background writer settings
  • Vacuum cost settings
  • Autovacuum settings

  • Command line parameters
  • Meta commands
  • Security

  • PostgreSQL Clusters
  • PostgreSQL Databases
  • Tables, Joins and Aggregates
  • PostgreSQL Indexes and Foreign Keys

  • Schemas
  • Tables, Views and Rules
  • Users, Groups and Roles
  • Tables and Sequences
  • Object Security

  • Vacuum
  • Tablespaces
  • Inheritance
  • Table Partitioning
  • Windowing Functions
  • Transactions
  • Concurrency Control
  • Functions and Operators
  • Type conversion
  • Full text search

  • Basic DML
  • COPY
  • Other Tools

  • Log Management
  • Query analysis
  • Routine Vacuuming
  • Recovering disk space
  • Managing Planner statistics
  • REINDEX

  • Database Logs
  • OS Process monitoring
  • The PostgreSQL Statistics Collector
  • Statistics Views
  • Statistics Functions

  • OS Tuning
  • Hardware configuration
  • Transaction logs
  • Tablespaces and Partitioning
  • Checkpoint tuning
  • Query tuning

  • The pg_dump utility
  • The pg_dumpall utility
  • Recovery options
  • Point In Time Recovery

  • The pg_upgrade utility
  • RPM based upgrades
  • Source based upgrades
  • Replication based upgrades
  • Rolling back

  • Streaming Replication
  • Synchronous Replication
  • Replication Slots
  • Failover management
  • Connection Poolers
  • HA configurations

  • Overview
  • Triggers

  • Overview
  • Event Triggers

  • Overview
  • SELECT Views
  • Updating a View
  • Materialized Views
  • Rules and privileges

  • Structure
  • Declarations
  • Expressions
  • Statements
  • Control Structures
  • Cursors
  • Errors and Messages
  • Trigger Procedures

  • PL/Perl
  • PL/Python
  • More…

  • Overview of additionally supplied modules

Available Training Modes

Pick the format that fits your team.

Same authorised curriculum, same trainers, same hands-on cloud labs — delivered the way that works for you.

Live Online (VILT)

Real-time instructor-led sessions over Zoom or Teams. Same classroom, different time zones.

Most popular

Classroom

Face-to-face training delivered at your office, our Bengaluru centre, or any partner venue worldwide.

Onsite

Self-Paced

Recorded sessions plus 24/7 access to cloud labs and assessments. Learn at the pace that works for each engineer.

On-demand

Blended

Live workshops with self-paced reinforcement and project-based labs. Best for hybrid teams across regions.

Hybrid teams
All modes include: hands-on cloud labs, recordings, assessments, certificate of completion. Talk to a solutions advisor →

Our Training Process

How a course becomes measurable skill.

One contract, five steps, zero handoffs. From discovery to deployment, the same Synergific team owns the outcome — not a chain of vendors.

5 Steps from your scoping call to certified, productive engineers.
01

Discover & set goals

We start with a scoping call to understand your team's current skill level, target outcomes, deadlines, and certification needs — then translate that into a measurable success plan with named owners on both sides.

02

Curate the right path

We map the optimal learning path — instructor-led, self-paced, or blended — with hands-on cloud labs, prerequisite refreshers, and certification vouchers built in. No filler modules, no padded curriculum.

03

Deliver hands-on training

Authorised trainers run live sessions backed by 24/7 cloud labs and real-world projects. Theory and practice on the same day — learners stop forgetting concepts before they get to apply them.

04

Assess & mentor

Continuous skill checks, mock exams, and 1:1 mentoring keep the program honest. If anyone falls behind, we course-correct in-flight — you'll never find out at the end that two engineers couldn't keep up.

05

Certify & apply on the job

Voucher-backed certification, post-training office hours, and 30-day reinforcement so skills land on real work — not just on the exam scorecard. Success measured after the course ends, not before.

Client Stories

What our clients say

Voices from L&D leaders, architects, and program managers who’ve trusted us with their upskilling.