With in-depth tutorials and a practical, hands on workshop, you will learn about the basics and advanced features of PostgreSQL and how to develop applications with PostgreSQL as the back-end.

You will be led by our team of expert trainers who will hand hold you through the concepts of database installation and connection, writing queries to manage the database, and SQL statements to operate PostgreSQL. You will also get the PostgreSQL certification on successful completion of the course..

We can organize this training at your preferred date and location.

Prerequisites

Participants are required to have basic knowledge of DATABASE and RDBMS.

What You Will Learn

How relational databases work and how are they relevant in today’s times
What sort of a database management system is PostgreSQL
How to install and setup PostgreSQL and run queries on it
How to create applications with PostgreSQL as a back end database management system

Training Outline

Module 1: Introduction

History of PostgreSQL
Major Features
New Features of PostgreSQL
Multi Version Concurrency Control
Write-Ahead Logging
Architectural Overview
Limits

Module 2: PostgreSQL System Architecture

Architectural Summary
Shared Memory
Statement Processing
Utility Processes
Disk Read Buffering
Write Buffering
Background Writer Cleaning Scan
Commit & Checkpoint
Physical Database Architecture
Data Directory Layout
Installation Directory Layout
Page Layout

Module 3: Creating and Managing Databases

Object Hierarchy
Creating Databases
Creating Schemas
Schema Search Path
Roles, Users & Groups
Access Control

Module 4: Postgres Data Dictionary

The System Catalog Schema
System Information views/tables
System Information Functions

Module 5: Configuration

Setting PostgreSQL Parameters
Access Control
Connection Settings
Security and Authentication
Settings
Memory Settings
Query Planner Settings
WAL Settings
Log Management
Background Writer Settings
Statement Behavior

Module 6: Security

Authentication
Authorization
Levels of security
pg_hba.conf file
Users
Object ownership
Access control
Application access parameters

Module 7: Backup and Recovery & Point-in Time Recovery

Backup Types
SQL Dump
Cluster Dump
Offline Copy Backup
Continuous Archiving
pg_basebackup
Point-In Time Recovery
pg_upgrade

Module 8: Routine Maintenance

Explain and Explain Analyze
Table Statistics
Updating Planner Statistics
Vacuuming
Scheduling Auto Vacuum
Preventing Transaction ID Wraparound Failures
The Visibility Map
Routine Reindexing

Module 9: Table Partitioning

Partitioning
Partitioning Methods
When to Partition
Partitioning Setup
Partitioning Example
Partitioning and Constraint
Exclusion
Caveats

Module 10: Database Monitoring

Database Statistics
The Statistics Collector
Database Statistic Tables
Operating System Process Monitoring
Current Sessions and Locks
Log Slow Running Queries
Disk Usage

Why Choose Us

Experience PostgreSQL through Bilginç IT Academy's live and interactive virtual classroom environment. Join a Public course as an individual delegate or arrange a dedicated Private / In-house online training program exclusively for your organization.

Delivery Method: Online Instructor-Led
Participation Model: Public / Private (In-house)
Live and Interactive Training: Connect with your instructor in real time and actively participate through discussions, Q&A sessions, practical exercises, and group activities.
Flexible Participation: Join the training from your home, office, or any location with a suitable internet connection.
Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's professional training experience since 1995.
Worldwide Access: Join our live virtual classrooms from anywhere in the world or arrange a dedicated online training program for your organization.

Experience PostgreSQL in a professional face-to-face classroom environment. Classroom Based training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class exclusively for your organization.

Delivery Method: Classroom Based
Participation Model: Public / Private (In-house)
Face-to-Face Learning: Interact directly with your instructor and fellow delegates in an engaging classroom environment.
Experienced Trainers: Learn from specialists with extensive industry experience and practical real-world knowledge.
Professional Training Environment: Attend training in comfortable, well-equipped classrooms designed to support effective learning.
Practical Learning: Depending on the course, reinforce your knowledge through hands-on exercises, scenarios, case studies, and instructor-led activities.

Arrange PostgreSQL as a dedicated Onsite training program for your organization. Bilginç IT Academy trainers can deliver the training at your office or another location of your choice, with the program planned around your team's requirements and business objectives.

Delivery Method: Onsite
Participation Model: Private (In-house)
Training at Your Preferred Location: Organize the training at your company's office or another location selected by your organization.
Tailored Course Content: Adapt the training program to your projects, team structure, existing skill levels, and specific business requirements.
Team-Focused Learning: Develop your team around a shared knowledge base while strengthening internal collaboration and knowledge transfer.
Flexible Scheduling: Plan the training dates, location, and program according to your organization's operational requirements.
Worldwide Onsite Delivery: Bilginç IT Academy trainers can travel internationally to deliver dedicated training programs at your preferred location.

D. K. - Yazılım / KKTCell

I was satisfied with the training.

O. Ö. - Software Engineer - KKTCell

Rated the training 5 stars.

B. B. - Software Engineer - KKTCell

Rated the training 5 stars.

E. B. - Software Engineer - KKTCell

Rated the training 5 stars.

Ö. K. - Software Engineer - KKTCell

Rated the training 5 stars.

M. C. - Software Engineer -New Graduate - KKTCell

Rated the training 5 stars.

A. K. - Yazılım Mühendisi - KKTCell

Rated the training 5 stars.

G. G. - Software Engineer - KKTCELL

Rated the training 5 stars.

C. Ç. - Yazılım Mühendisi - KKTCell

Rated the training 5 stars.

Ü. A. - system administrator - KKTCell

Rated the training 5 stars.

G. T. - Veri tabanı Yöneticisi - Türkiye Emlak Katılım Bankası

Rated the training 5 stars.

E. B. - Veri tabanı uzmanı - Türkiye Emlak Katılım Bankası

Rated the training 5 stars.

B. B. Y. - Veri Tabanı Yönetimi - Türkiye Emlak Katılım Bankası

Rated the training 5 stars.

Ş. A. - DBA - Fuzul Ev

Rated the training 5 stars.

Ş. Y. - Veritabanı Yazılımı Uzman Yardımcısı - Fuzul Ev

Rated the training 5 stars.

Y. D. - Senior SQL Developer - Fuzul Ev

Rated the training 5 stars.

F. Ç. - VeriTabanıYönetimiUzm.Yrdm. - Fuzul Ev

Rated the training 5 stars.

D. Ç. - Intertech

The training was very productive; many thanks to our instructor for their hard work and effort.

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

PostgreSQL Training

Prerequisites

What You Will Learn

Training Outline

Module 1: Introduction

Module 2: PostgreSQL System Architecture

Module 3: Creating and Managing Databases

Module 4: Postgres Data Dictionary

Module 5: Configuration

Module 6: Security

Module 7: Backup and Recovery & Point-in Time Recovery

Module 8: Routine Maintenance

Module 9: Table Partitioning

Module 10: Database Monitoring

Why Choose Us