Technologies / Data & Analytics

PostgreSQL 17 for developers and administrators

The training offers a comprehensive approach to PostgreSQL 17, combining developer and administrator perspectives. Participants will learn advanced features and innovations introduced in version 17, along with practical applications in a production environment. The program is delivered through intensive hands-on workshops, where theory is immediately verified in practice. The training uses real-life scenarios and use cases.

Issues

PostgreSQL 17 architecture
Advanced SQL Features
Server-side programming
Query optimization
Transaction management
Indexing mechanisms
Partitioning and sharding
Data replication
Performance monitoring
Security and auditing
Integration with applications
PostgreSQL extensions

Benefits

The participant will gain a working knowledge of new features and enhancements in PostgreSQL 17
He/she will learn how to effectively use advanced PostgreSQL programming features
Will learn database optimization and tuning techniques in a production environment
Will be able to design and implement efficient database solutions
Will gain the ability to diagnose and solve complex problems
Will learn how to manage large databases in a production environment

Who is this training for?

Database application developers

Database administrators

Database solution architects

Full-stack developers

DevOps specialists

System engineers

System analysts

Database designers

Prerequisites

Basic knowledge of SQL
Programming experience
Knowledge of the basics of database administration
General knowledge of relational databases

Training program

Changes in indexing mechanisms
Performance optimization
New data types and operators
Programming in PostgreSQL

Stored procedures and functions

Server-side programming
Database administration
Management of users and permissions

Monitoring and diagnostics
Performance optimization

Partitioning of tables
Replication and high availability
Integration with external systems
Extensions and plug-ins

Delivery Methods

Online

Convenience of participating from anywhere
Interactive live sessions with trainer
Materials available for 30 days
No travel costs

On-site

Direct contact with trainer and group
Intensive hands-on workshops
Networking with other participants
Full focus on learning

Frequently asked questions

What are the prerequisites for this training?

For PostgreSQL 17 for developers and administrators we recommend: Basic knowledge of SQL; Programming experience; Knowledge of the basics of database administration.

What is the format and duration of this training?

The training lasts 3 days and is available in online and on-site format. Sessions run from 9:00 AM to 4:00 PM. We can also customize the schedule to fit your team's needs.

Who is this training designed for?

This training is designed for: Database application developers; Database administrators; Database solution architects.