Developer Fundamentals And Advanced



Postgres Training

Designed for DBAs, Architects, Application Developers, and IT Professionals, our training courses are created and delivered by experienced Postgres experts who will show you how to quickly manage your database responsibilities with ease.

We offer training in 2 convenient formats:

  • Classroom – scheduled, open-enrolment public training batch at a specified city or location
  • On-Site – delivered on-premise at your company location for your team


Relevant and up-to date material and labs enable you to quickly put your new skills into practice in your own environment. All training includes modularized lessons, lecture, presentation copy, and real hands-on lab exercises.

Postgres Training Courses:

Postgres Developer Fundamentals is a 2-day instructor-led training that gives you the essential skills for database development in Postgres. Learn about Postgres data types, database objects, indexes, transactions, and working with connectors and drivers, with basic installation.

Developer Advanced Training covers advanced skills needed by Postgres database developers in another 2-day instructor-led training. You will learn about using data adapters to interact with additional data sources, a multi-step plan for SQL tuning, and approaches for data security and localization. This is the second part in the Postgres Developers Track and follows Postgres Developer Fundamentals.

The above courses are to be attended together.

Target Audience: For experienced Database Developers who are new to Postgres and want to gain the essential skills required to effectively design and implement Postgres databases for applications while incorporating Postgres features.

Training Course Structure:


  • PostgreSQL Introduction:
  • Introduction to PostgreSQL
  • Describe the sample tables used in the course
  • Installation:
  • Installation Options
  • Postgres Installation
  • PostgreSQL Source Code
  • Database Clusters
  • Start and Stop Postgres
  • pgAdmin III:
  • PgAdmin3
  • PEM Client
  • Registering a server
  • Viewing and Editing Data
  • Query Tool
  • Databases
  • Languages
  • Schemas
  • Database Objects
  • Maintenance
  • Tablespaces
  • Roles
  • Command Line Tool: PSQL
  • Command Line Tool: EDB*Plus
  • Transactions and Concurrency:
  • Transaction Definition
  • Effects of Concurrency on Transactions
  • Transaction Isolation Levels
  • Sharing Data Snapshots
  • Locking Modes
  • Multi-Version Concurrency Control Overview (MVCC)
  • Internal Identifiers
  • PostgreSQL Connectors and Extensions:
  • JDBC
  • Installing JDBC Connectors
  • Connecting Java Applications to PostgreSQL
  • .NET Connectors
  • Extensions
  • Database Design:
  • Object Hierarchy
  • Creating Databases
  • Users
  • Access Control
  • Creating Schemas
  • Schema Search Path
  • Data Types:
  • Numeric Types
  • Character Types
  • Date and Time
  • Arrays
  • JSON and JSONB
  • Other Data Types
  • SQL Primer:
  • Tables
  • Constraints
  • Table Inheritance
  • Viewing Data Using SELECT
  • SQL Queries: DML
  • Quoting in PostgreSQL
  • Other Database Objects:
  • Views
  • Materialized Views
  • Sequences
  • Domains
  • Indexes:
  • Types of Indexes
  • Creating an Index
  • Index on Expression
  • Unique Indexes
  • Partial Indexes
  • Removing Indexes
  • Viewing Index Usage
  • Re-indexing
  • SQL Functions:
  • Operators
  • String Functions
  • Date Functions
  • Numeric Function
  • JSON Functions
  • XML Functions
  • Aggregate Functions
  • Data Type Conversion
  • Large Objects:
  • Data Types for large data
  • Adding lo extenstion
  • Using Java File Stream for inserting
  • image in postgres
  • Large Objects:
  • Introduction to PLPGSQL
  • Creating Functions using PL/PGSQL


  • Procedural Languages:
  • What is a Procedural Langauge
  • Introduction to PL/pgSQL
  • Working of PL/pgSQL
  • How to Create PL/pgSQL Functions
  • How to use Control Statements
  • How to Handle Exceptions in PL/pgSQL
  • Declaring and Using Cursors
  • Rules and Triggers:
  • How to define Rules
  • Write Database Trigger Procedures
  • Create Triggers in PostgreSQL
  • Add Triggers on Views
  • SQL Tuning:
  • Statement Processing
  • Common Query Performance Issues
  • SQL Tuning Goals
  • SQL Tuning Steps
    • ‒ Identify slow queries
    • ‒ Review the query execution plan
    • ‒ Optimizer statistics and behaviour
    • ‒ Restructure SQL statements
    • ‒ Indexes
  • Background Worker Processes:
  • What is Background Worker
  • How to Setup Background Worker
  • Examples of Pre-built Background Worker Processes
  • Localization:
  • PostgreSQL Locale Support
  • Working with different Locales
  • PostgreSQL Character Sets
  • Changing Server and Client Encoding
  • Foreign Data Wrappers:
  • What are Postgres
  • Foreign Data Wrappers
  • How to Setup FDWs
  • Example – postgres_fdw
  • Example – file_fdw
  • Full Text Searching:
  • What is Full-Text Search
  • How to store and query Full Text Search data in Postgres
  • Data Encryption:
  • What is Database Security
  • PostgreSQL options for Eata Encryption and Security
  • What is Host Based Access Control
  • How to implement Row level Security
  • Introduction to pg_crypto Extension
  • Working with Geo Data: Postgis
  • What is PostGIS
  • Installation of PostGIS
  • Creation of spatial database
  • Load and retrieve data in a spatial database

Training Details:

  • Training fees: Inquire here
  • Location: Singapore
  • Batch strength: 12-13 students

Training Pre-requisites:

  • Basic experience in database administration and understanding of Relational Database concepts will be helpful. Understanding of Linux environment and basic commands will help in better understanding of the hands-on lab sessions.

Delivery Approach:

  • Training includes lessons, hands-on labs and follow-up exercises to teach you how to use Postgres.
  • All attendees must attend this class in person. There is no remote access to the training.

Interested? Fill the Inquire Now form or drop us an email.

Inquire Now
Just fill in your specifics and we will get in touch with you, with the course fees and other details.

Email Id*




Course Type*

Where did you find us?*

Enter Security Code*