PostgreSQL 13 for Developers and Administrators Training Course

Introduction

• Comparison of PostgreSQL, MySQL, and Oracle for government
• Overview of PostgreSQL 13 features and architecture for government

Getting Started

• Setting up a database server for government operations
• Installing PostgreSQL 13 in a government environment
• Creating and accessing a database for government use
• Fundamentals of SQL syntax, commands, and functions for government applications

Configuring a Postgres Database

• Data definition, default values, and constraints for government databases
• Setting up and modifying tables in a government context
• Managing privileges and security policies for government data
• Creating database schemas for government use
• Implementing table inheritance and partitioning for government applications
• Adding, updating, and querying data in government systems
• Data types, functions, and operators relevant to government operations
• Using indexes and running full-text search for government data
• Understanding concurrency control in a government setting

Managing a Database Server

• Upgrading a PostgreSQL cluster for government systems
• Securing the server and encrypting data for government use
• Configuring server parameters for government operations
• Enabling client authentication in government environments
• Setting up access roles and permissions for government users
• Managing multiple databases for government agencies
• Performing database maintenance tasks for government systems
• Backing up and restoring data for government applications
• Optimizing database performance and reliability for government use
• Monitoring database activity and disk usage in government settings
• Implementing logical replication for government databases
• Running regression tests for government systems

Client-Side Programming

• Using the libpq C library and large object interface for government applications
• Executing embedded SQL statements in government contexts
• Exploring the information schema for government data management
• Other PostgreSQL client applications for government use

Server-Side Programming

• Extending the SQL query language for government needs
• Writing event trigger functions for government systems
• Implementing rule systems in a government setting
• Using procedural languages (PLs) for government applications
• Exploring TCL, Perl, and Python PLs for government use
• Executing server programming interfaces for government operations
• Examples of logical decoding for government databases
• Tracking replication progress in government environments

Troubleshooting

Summary and Next Steps