Skip to main content
  • 4.7
  • 5.0

Official Learning Partner

Course Highlights

PostgreSQL Developer Training equips learners with the skills needed to design, develop, and optimize applications using PostgreSQL databases. This comprehensive course covers database architecture, schema design, query writing, stored procedures, and advanced SQL techniques. Designed for both beginners and experienced developers, the training provides hands-on practice and real-world scenarios to master essential development tasks. Participants also gain knowledge of advanced topics such as indexing, query optimization, JSON data handling, and integration with modern frameworks and applications. By the end of the training, students are prepared to build efficient, scalable, and secure database-driven applications. PostgreSQL Developer Training is ideal for IT professionals and developers seeking to enhance their expertise in database programming and application development.

PostgreSQL DEVPlay Video

Trainer: Mr.Srinivas

14+ years of Experience

Training Highlights:

  • Partitioning
  •  Cascading Actions
  • Triggers
  • Stored Procedures and Functions
  • ACID Properties
  • Entity-Relationship Modeling
  • Denormalization
  • Normalization
  • SQL Fundamentals
  • Tables & Designing
  • Data Types 
  • Joins
  • Subqueries & Views
  • Tools & Catalog
  • CRUD Operations
  • Tablespaces
  • Multi-Version Concurrency Control
  • Constraints and Relationships
  • Indexing and Types
  • Data Loading
  • Extensions
  • Common Table Expressions
  • Introduction to PL/pgSQL
  • PL/pgSQL Basics

PostgreSQL Developer Training Plans

title

Plan A

1. PostgreSQL DEV

Plan B

1. PostgreSQL DEV 
2.Performance Tuning 
Course CurriculumCh 1 to Ch15Ch 1 to Ch 26
Duration4 Weeks6 Weeks
100% Practical✔✔
Step by Step, Realtime✔✔
PostgresSQL Development✔✔
Data Modelling✔✔
Database Design✔✔
Views & Functions✔✔
Stored Procedures✔✔
Triggers & Views✔✔
Transactions✔✔
Business Flow Concepts✔✔
Common Table Expressions✔✔
Cursors, SPs✔✔
Arguments, Variables✔✔
Realtime Project✔✔
Table Indexing ✖✔
Indexed Views✖✔
Query Tuning✖✔
Execution Plans✖✔
Query Costs✖✔
Maintenance Plans✖✔
Statitics & Tuning✖✔
Advanced Tuning✖✔
Total Course Fee ( Payable in Installments)*INR 70000INR 10000

PostgreSQL DBA Training

S NoTime (IST, Mon - Fri)Start DateRegister
18 PM - 9 PMJan 7thRegister
26 AM - 7 AMJan 21stRegister

Can’t find a batch you
were looking for?

CONTACT US

If you need self
paced videos

CONTACT US
PostgreSQL DEVPlay Video

CERTIFICATE OF COMPLETION

Certificate of completion for SQL school program.

PostgreSQL DBA Training
Course Contents:

Brochure DownloadRegister Now

Part 1: PostgreSQL DBA Training

Module 1

Ch 1: Introduction to PostgreSQL

  • Overview of PostgreSQL
  • History and Evolution of PostgreSQL
  • Features, Versions and Benefits of PostgreSQL
  • PostgreSQL Architecture

Ch 2: Installation

  • PostgreSQL on Windows
  • PostgreSQL on Linux using Yum repository and RPM
  • PostgreSQL on Linux using Source Code
  • PostgreSQL on Linux using Contrib Module

Ch 3: Configuration File & Directory Layout

  • Data Directory
  • Configuration Files
  • Other Physical Files
  • Database Directory Layout Base Directory

Ch 4: Database Cluster

  • PostgreSQL Cluster (Initdb, Start/Stop/Restart/Reload)
  • Start and stop using systemctl.
  • PostgreSQL Cluster Demo on Windows
  •  PostgreSQL Cluster Demo on Linux

Ch 5: Process & Memory Architecture

  • Postmaster Process
  • Utility Processes
  • Memory Segments & Memory Components

Ch 6: Create Objects and Privileges

  • Create/Drop Database
  • Create/Drop User
  • Create/Drop Schema and Search Schema Path
  • Grant/Revoke Privileges on Database Objects

Ch 7: Tools (psql & pgAdmin) and catalog

  • Using psql command line interface (CLI)
  •  pgAdmin(GUI) : Practical Use
  •  g_catalog : Realtime Usage
  • Information_Schema & Medata Audits

Ch 8: CRUD Operations

  • CRUD Introduction
  • Create Table, Data Types, Constraints, Functions and Operators
  • Retrieve Data in PostgreSQL
  •  Update Records in a Table
  •  Delete Records in a Table
  •  Truncate

Ch 9: Tablespaces

  • Tablespace Introduction
  •  Default Tablespace (pg_default & pg_global)
  •  Local & Global Tablespaces
  •  Create/Drop Tablespaces
  •  Temporary Tablespace

Ch 10: Backup and Restore

  • Introduction to PostgreSQL Backups
  • Backup using pg_dump and psql utilities
  •  Restore using pg_restore and psql utilities
  •  Offline Backups
  •  Online Backups
  •  pg_basebackup utility

Ch 11: Advanced Backup & Restore

  • pgBackRest
  • Point-In-Time-Recovery (PITR)

Ch 12: MVCC (Multi-Version Concurrency Control) in PostgreSQL

  • What is MVCC in PostgreSQL?
  •  How does MVCC work in PostgreSQL?
  •  Key Data Structures in MVCC
  •  Benefits of MVCC in PostgreSQL
  •  Transaction ID Wraparound

Ch 13: Database Maintenance, Vacuum and Analyze

  • Introduction to Maintenance
  •  Vacuum
  •  Analyze
  •  Statistics
  •  Clustering
  •  Auto-Vacuum

Ch 14: Joins and Constraints 

  • Introduction on Joins and Constraints
  •  Join Types (Inner, Equi and Outer)
  •  Constraints (Primary Key, Unique, Foreign Key and NOT NULL etc…)
  •  SERIAL Column
  •  ER Diagram

Ch 15: Indexing and Types

  • Introduction to Indexes
  •  Basic Index Types (B-Tree, Hash and Function/Expression)
  •  Advanced Index Types (GiST, SP-GiST, GIN and BRIN).

Ch 16: Performance Tuning – Part 1

  • Database Tuning 
  •  Query Tuning 

Ch 17: Performance Tuning – Part 2

  • Configuration Tuning
  •  Monitoring and Maintenance
  •  Hardware Tuning

Ch 18: Data Loading

  • Moving, Copying, Export, Import, copy etc…
  •  pgloader
  •  Foreign Data Wrappers (FDW)

Ch 19: Extensions

  • What are Extensions in PostgreSQL?
  •  Types of Extensions in PostgreSQL.
  •  Examples of Extensions in PostgreSQL.
  •  How to Install/Uninstall Extensions in PostgreSQL.

Ch 20: High Availability and Replication 2

  • High Availability Architecture
  •  Master/Primary and Slave/Standby
  •  HA step-by-step configuration using Streaming Replication
  •  Manual Failover and Switchover
  •  promote command

Ch 21-22: Advanced -1 High Availability Concepts

  • HA step-by-step setup using Streaming Replication
  • HA step-by-step using Logical Replication
  • Automatic Failover & Switchover

Ch 23-24: Advanced -2 High Availability Tools and Software

  • pgpool: A PostgreSQL-specific connection pooling and replication tool
  •  repmgr: A tool for managing PostgreSQL replication clusters
  •  Patroni: A PostgreSQL-specific high availability tool that provides automated failover and
    switchover

Ch 25-26: PostgreSQL HA and disaster recovery (DR) strategies

  • Introduction to disaster recovery (DR)
  •  High Availability Strategies (Master-Slave, Master-Master, Multi-Master)
  •  Disaster Recovery Strategies (PITR, Backup and Restore and Replication)
  •  Tools and Software required for DR

Ch 27: Performance Tuning Using Server Parameters and Partitioning.

  • Introduction to Server Parameters
  • Tune Server Parameters
  • Partitioning

Ch 28: Migration to PostgreSQL.

  • Manual Migration
  • Using pg_dump and pg_restore
  • Using Database Migration Tools
  • Using Third-Party Tools

Ch 29: Upgrade PostgreSQL

  • Upgrade Methods
  • Minor version upgrades
  • Major version upgrades

Ch 30: Monitoring and Reports

  • Monitoring using Grafana
  • Monitoring using pg_stat_statments
  • pgBadger

Part 2: Azure Database For PostgreSQL

Module 2

Chapter 31: Azure Cloud Introduction and Fundamentals

  • Cloud Fundamentals
  • Cloud Concepts, Benefits
  • IaaS, PaaS, SaaS Cloud Types
  • Azure Cloud Concepts
  • Azure Resources & Usage
  • Azure Services & Purpose
  • Azure Account & Subscription

Chapter 32: Benefits of Running PostgreSQL in Azure

  • Scalability
  • High Availability
  • Security
  • Cost-Effective

Chapter 33: Azure PostgreSQL Options

  • PostgreSQL database on Azure Virtual Machines
  • Fully Managed Azure Database for PostgreSQL
  • Azure Kubernetes Service (AKS

Chapter 34: Create Objects and CRUD operations in AZURE

  • Create/Drop Databases
  • Create/Drop Users
  • Create/Drop Tables
  • SELECT, INSERT, UPDATE, DELETE and TRUNCATE

Chapter 35-36: PostgreSQL DB Migrations in AZURE

  • Azure Database Migration Service (DMS)
  • Azure Data Factory (ADF)
  • pg_dump and pg_restore
  • Azure Database for PostgreSQL Migration Tool
  • Third-party tools

Chapter 37: Backup and Automated Backup in AZURE

  • Backup Options in Azure for PostgreSQL
  • Automated Backup Options in Azure for PostgreSQL
  • Configuring Automated Backups in Azure for PostgreSQL
  • Best Practices for Backing up PostgreSQL Databases in Azur

Chapter 38: Restore a Backup in AZURE

  • Restore Options in Azure for PostgreSQL
  • Restoring a Database using Backup Restore
  • Restoring a Database using pg_restore
  • Restoring a Database using Point-in-Time Restore (PITR)
  • Best Practices for Restoring PostgreSQL Databases in Azure

Chapter 39: Performance Tuning of PostgreSQL database in AZURE

  • Azure-Specific Performance Tuning
  • PostgreSQL Configuration Tuning
  • Query Optimization
  • Monitoring and Maintenance

Chapter 40: PostgreSQL HA in AZURE

  • HA Architectures
  • Azure Native HA Options
  • Third-Party HA Options
  • Best Practices

Chapter 41: PostgreSQL disaster recovery (DR) in Azure

  • Disaster Recovery Options
  • Disaster Recovery Strategies
  • Azure Services for Disaster Recovery
  • Best Practices

SQL SCHOOL

24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.

Technical FAQs

Who is SQL School? How far you have been in the training services ?

SQL School is a registered training institute, established in February 2008 at Hyderabad, India. We offer Real-time trainings and projects including Job Support exclusively on Microsoft SQL Server, T-SQL, SQL Server DBA and MSBI (SSIS, SSAS, SSRS) Courses. All our training services are completely practical and real-time.CREDITS of SQL School Training Center

  • We are Microsoft Partner. ID# 4338151
  • ISO Certified Training Center
  • Completely dedicated to Microsoft SQL Server
  • All trainings delivered by our Certified Trainers only
  • One of the few institutes consistently delivering the trainings for more than 19+ Years online as inhouse
  • Real-time projects in
    • Healthcare
    • Banking
    • Insurance
    • Retail Sales
    • Telecom
    • ECommerce

I registered for the Demo but did not get any response?

Make sure you provide all the required information. Upon Approval, you should be receiving an email containing the information on how to join for the demo session. Approval process usually takes minutes to few hours. Please do monitor your spam emails also.

Why you need our Contact Number and Full Name for Demo/Training Registration?

This is to make sure we are connected to the authenticated / trusted attendees as we need to share our Bank Details / Other Payment Information once you are happy with our Training Procedure and demo session. Your contact information is maintained completely confidential as per our Privacy Policy. Payment Receipt(s) and Course Completion Certificate(s) would be furnished with the same details.

What is the Training Registration & Confirmation Process?

Upon submitting demo registration form and attending LIVE demo session, we need to receive your email confirmation on joining for the training. Only then, payment details would be sent and slot would be allocated subject to availability of seats. We have the required tools for ensuring interactivity and quality of our services.

Please Note: Slot Confirmation Subject to Availability Of Seats.

Will you provide the Software required for the Training and Practice?

Yes, during the free demo session itself.

How am I assured quality of the services?

We have been providing the Trainings – Online, Video and Classroom for the last 19+ years – effectively and efficiently for more than 100000 (1 lakh) students and professionals across USA, India, UK, Australia and other countries. We are dedicated to offer realtime and practical project oriented trainings exclusively on SQL Server and related technologies. We do provide 24×7 Lab and Assistance with Job Support – even after the course! To make sure you are gaining confidence on our trainings, participans are requested to attend for a free LIVE demo based on the schedules posted @ Register. Alternatively, participants may request for video demo by mailing us to contact@sqlschool.com Registration process to take place once you are happy with the demo session. Further, payments accepted in installments (via Paypal / Online Banking) to ensure trusted services from SQL School™

YES, We use Enterprise Edition Evaluation Editions (Full Version with complete feature support valid for SIX months) for our trainings. Software and Installation Guidance would be provided for T-SQL, SQL DBA and MSBI / DW courses.

Why Choose SQL School

Azure DevOps and azure fundamentals video bannerPlay Video
  • 100% Real-Time and Practical
  • ISO 9001:2008 Certified
  • Concept wise FAQs
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews
  • 24/7 LIVE Server Access
  • Realtime Project FAQs
  • Course Completion Certificate
  • Placement Assistance
  • Job Support
  • Realtime Project Solution
  • MS Certification Guidance
×
Verified by MonsterInsights