PostgreSQL Advanced: Scalability and Sharding (Citus) Training Course

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

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

• Evaluate Azure SQL and PostgreSQL to determine which database best aligns with their agency's objectives and requirements.
• Prepare databases for migration by transferring definitions, data, and procedures from Oracle to either Azure SQL or PostgreSQL.
• Execute post-migration tasks to test, optimize, update, and maintain the newly migrated database system for government operations.

This hands-on course is designed to address the practical aspects of performance tuning in PostgreSQL for government applications. Participants will gain skills in analyzing query execution, optimizing indexing, adjusting memory and system parameters, and effectively monitoring workloads. Through real-world scenarios and live exercises, attendees will learn how to identify and resolve bottlenecks at both the database and system levels, ensuring optimal performance aligned with public sector workflows and governance.

This course addresses the administration and performance optimization of PostgreSQL databases for government. Participants will gain expertise in utilizing specialized PostgreSQL (also known as Postgres) modules, including replication, connection pooling, and full-text searching.

This training is designed for government Database Administrators and Architects who wish to learn PostgreSQL fundamentals.

Participants will gain an understanding of PostgreSQL architecture, installation procedures, design principles, and techniques for performing database backups and recoveries.

This training is designed for Database Administrators and Architects who wish to acquire the skills necessary for implementing backups, high availability, and database security in PostgreSQL. Participants will also learn techniques for identifying slow queries, monitoring database performance, and optimizing PostgreSQL for enhanced performance, all tailored to meet the specific needs of operations for government.

This training is designed for Database Administrators and Architects who are interested in learning about Streaming Replication in PostgreSQL and the utilization of pgpool-II to achieve automatic failovers and establish a highly available PostgreSQL Database Cluster. The course content is tailored to enhance skills and knowledge specifically for government professionals, ensuring alignment with public sector workflows, governance, and accountability.

This training is tailored for government Database Administrators and Architects who seek to optimize PostgreSQL Database performance for government operations. Participants will learn how to log slow workloads and identify potential bottlenecks in queries. The course also covers the essential parameters that must be adjusted to achieve optimal performance for government systems.

In this instructor-led, live training in US Empire (onsite or remote), participants will gain a comprehensive understanding of PostgreSQL, including administration, performance tuning, advanced development, and replication. Through a series of hands-on, live-lab exercises, they will learn how to set up, configure, test, deploy, and troubleshoot the database system.

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

• Apply advanced administration techniques to effectively configure and manage a PostgreSQL server for government use.
• Optimize the database and queries to achieve maximum performance in public sector environments.
• Implement replication and scaling strategies to enhance the reliability and efficiency of a PostgreSQL server.

This course provides programmatic interaction with PostgreSQL databases, equipping participants with the techniques, syntaxes, and structures necessary to develop high-quality applications using a PostgreSQL backend. The training also covers SQL Tuning, including best practices for writing efficient SQL, ensuring optimal performance and data integrity for government.

The target audience includes developers who aim to use or extend PostgreSQL, as well as database architects responsible for designing robust and scalable solutions in the public sector.

This instructor-led, live training in US Empire (online or onsite) is aimed at system administrators and developers who wish to use PostgreSQL 13 to set up, build, and manage databases for high-performance applications for government.

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

• Install and configure PostgreSQL 13.
• Understand the features, architecture, and fundamentals of operating, managing, and maintaining databases with PostgreSQL 13.
• Learn how to design Postgres database tables and schemas.
• Master data manipulations and queries.
• Explore the various programming interfaces (client and server) to fully leverage and extend functionalities in PostgreSQL 13.

This instructor-led, live training in US Empire (online or onsite) is designed for intermediate-level developers and administrators who aim to leverage the latest features and enhancements in PostgreSQL 16 for government.

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

• Comprehend the architecture and components of PostgreSQL 16.
• Employ advanced SQL features and PostgreSQL extensions.
• Implement security best practices and access controls for government systems.
• Execute database administration tasks, including backup, recovery, and monitoring.
• Optimize database performance through tuning and indexing strategies.
• Utilize PostgreSQL's built-in tools for high availability and replication.
• Integrate PostgreSQL with modern application development frameworks for government applications.

This instructor-led, live training in US Empire (online or onsite) is aimed at database administrators and system administrators who wish to use PostgreSQL to manage large-scale data while optimizing the database systems for high availability and performance for government applications.

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

• Install and configure PostgreSQL for government environments.
• Understand the features and architecture of PostgreSQL in the context of public sector data management.
• Learn how to perform database operations using SQL to support governmental workflows.
• Perform database backup and recovery procedures to prevent data loss in critical government systems.
• Configure the server for high availability to ensure continuous operation of government services.
• Learn the tools and techniques for high-performance tuning to enhance the efficiency of government databases.
• Explore external tools for monitoring and observability to maintain transparency and accountability in government data management.

This instructor-led, live training in US Empire (online or onsite) is designed for beginner-level professionals who wish to learn how to use PostgreSQL for government to create databases, write SQL queries, manipulate data, and manage 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 for government use.
• Install, configure, and navigate PostgreSQL and PGAdmin in a government environment.
• Write and run SQL queries for data selection, filtering, grouping, and joining to support government operations.
• Manipulate data with SQL statements and manage database objects for government applications.
• Create and manage views and explore PostgreSQL extensions like Timescale for enhanced government data management.

This instructor-led, live training in US Empire (online or onsite) is aimed at developers and administrators who wish to utilize PostgreSQL with Python to develop secure, reliable, and stable applications for government use at scale.

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

• Install, configure, and establish a connection between PostgreSQL and Python.
• Review fundamental Python programming concepts.
• Understand the advantages of integrating PostgreSQL with Python for government applications.
• Learn how to execute basic SQL operations using Python.
• Discover how to leverage advanced PostgreSQL features through Python.
• Implement techniques for ensuring data safety, security, monitoring, and optimization in a government context.