PostgreSQL with Python Training Course

This instructor-led, live training in Romania (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.

By the end of this training, participants will be able to:

• Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
• Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
• Perform post-migration steps to test, optimize, update, and maintain a migrated database.

This hands-on course focuses on the practical aspects of performance tuning in PostgreSQL. Participants will learn to analyse query execution, optimise indexing, adjust memory and system parameters, and monitor workloads effectively. Real-world scenarios and live exercises demonstrate how to identify and resolve bottlenecks at both the database and system levels.

This practical 3-day training covers the complete skill set required to develop robust applications using PostgreSQL.
Participants learn advanced SQL, procedural programming with PL/pgSQL, and database design techniques that improve performance and maintainability.
Real-world exercises focus on building stored functions, triggers, and automation logic directly inside PostgreSQL.

This course provides the essential knowledge required to install, configure, and manage PostgreSQL databases effectively. Participants will learn how to handle user security, perform backups and restores, manage logs, and tune basic parameters. Through practical exercises, learners will perform real-world administration tasks and prepare for advanced topics such as performance and replication.

This course provides in-depth coverage of replication, high availability, and cluster management in PostgreSQL. Participants will build and manage multi-node environments, configure failover automation, and explore load balancing and connection pooling solutions. The course includes live replication labs and recovery simulations.

This instructor-led, live training in Romania (online or onsite) is aimed at beginner-level professionals who wish to learn how to use PostgreSQL for creating databases, writing SQL queries, manipulating data, and managing tables using both SQL commands and PGAdmin. The course also provides a basic introduction to the Timescale extension for time-series data.

By the end of this training, participants will be able to:

• Understand relational database principles and PostgreSQL architecture.
• Install, configure, and navigate PostgreSQL and PGAdmin.
• Write and run SQL queries for data selection, filtering, grouping, and joining.
• Manipulate data with SQL statements and manage database objects.
• Create and manage views and explore PostgreSQL extensions like Timescale.

This intensive 1-day hands-on course focuses on distributed database design and implementation using the Citus extension for PostgreSQL.
Participants learn how to shard large datasets, manage distributed queries, and build scalable, fault-tolerant PostgreSQL clusters.
Real-world examples and practical labs demonstrate performance tuning, replication integration, and distributed workload management