Course Outline
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
Requirements
- An understanding of relational database management systems (RDBMS)
- Experience with Structured Query Language (SQL)
Audience for Government
- System administrators
- Developers
Testimonials (5)
A factual and practical approach to the subject. A nice atmosphere, conducive to asking questions.
Marcin - Santander Bank Polska S.A.
Course - Implementing High Availability in PostgreSQL
It was docker and container plus postgres DB inheritance feature which is not available in Oracle Database.
Manish Kumar
Course - PostgreSQL Essentials
It was clearly tailored to be very appropriate to our purpose which made it extra helpful. I really liked the zoom format as it helped me focus with the material right in front of you all the time and the trainer able to add illustrations and markings on to it as he explained. The trainer answered all our questions in a very satisfying way and I felt surprised at how much I was able to learn in one day. Usually i get tired of training by the afternoon but this was very engaging right through to the end. Pace was perfect and detail went into the right areas.
Davina Sanders - Scottish Government
Course - PostgreSQL Performance Tuning
Michal was very knowledgable and engaging as a teacher.
Nate Clifton - NIIT (USA) Inc.
Course - PostgreSQL Advanced DBA
new knowledges that can be apply in our system
