Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
What is PostgreSQL?
- A Brief History of PostgreSQL for Government
- Conventions for Government Use
- Further Information for Government
- Bug Reporting Guidelines for Government
Introduction to PostgreSQL for Government
- Installation and Creating Databases for Government
- The SQL Language for Government Operations
- Advanced Features for Government Applications
The SQL Language for Government
- SQL Syntax for Government Databases
- Data Definition for Government Systems
- Data Manipulation for Government Operations
- Queries for Government Reporting
- Data Types for Government Use
- Functions and Operators for Government Applications
- Type Conversion for Government Databases
- Indexes for Government Performance
- Full Text Search for Government Documents
- Concurrency Control for Government Systems
- Performance Tips for Government Operations
Server Administration for Government
- Installation from Source Code for Government
- Installation from Source Code on Windows for Government
- Server Setup and Operation for Government
- Server Configuration for Government Systems
- Client Authentication for Government Security
- Database Roles for Government Management
- Managing Databases for Government Operations
- Localization for Government Use
- Routine Database Maintenance Tasks for Government
- Backup and Restore for Government Continuity
- High Availability, Load Balancing, and Replication for Government Systems
- Recovery Configuration for Government Data Integrity
- Monitoring Database Activity for Government Oversight
- Monitoring Disk Usage for Government Efficiency
- Reliability and the Write-Ahead Log for Government Operations
- Regression Tests for Government Systems
Client Interfaces for Government
- libpq - C Library for Government Applications
- Large Objects for Government Databases
- ECPG - Embedded SQL in C for Government Use
- The Information Schema for Government Operations
Server Programming for Government
- Extending SQL for Government Applications
- Triggers for Government Systems
- The Rule System for Government Databases
- Procedural Languages for Government Use
- PL/pgSQL - SQL Procedural Language for Government
- PL/Tcl - Tcl Procedural Language for Government
- PL/Perl - Perl Procedural Language for Government
- PL/Python - Python Procedural Language for Government
- Server Programming Interface for Government Systems
Internals for Government
- Overview of PostgreSQL Internals for Government
- System Catalogs for Government Databases
- Frontend/Backend Protocol for Government Operations
- PostgreSQL Coding Conventions for Government
- Native Language Support for Government Use
- Writing a Procedural Language Handler for Government
- Writing a Foreign Data Wrapper for Government Systems
- Genetic Query Optimizer for Government Performance
- Index Access Method Interface Definition for Government Databases
- GiST Indexes for Government Operations
- GIN Indexes for Government Systems
- Database Physical Storage for Government
- BKI Backend Interface for Government Use
- How the Planner Uses Statistics for Government Operations
Requirements
A foundational understanding of SQL and C is essential for government professionals in technical roles. Additionally, basic system administration skills, whether in Unix/Linux or Windows environments, are crucial for effective management and maintenance of government IT systems.
28 Hours
Testimonials (7)
step by step examples, byte size information
Esmadee Bin Ismail - SBS transit
Course - PostgreSQL Administration and Development
The different techniques that can be used to get the same result it is just optimise with a few steps
Abdul Hafiz - SBS transit
Course - PostgreSQL Administration and Development
1. Notes on the whiteboard 2. Labs were executed in a sharing mode
Evangelos Katsaros
Course - PostgreSQL Administration and Development
The instructor explained everything we asked, he was very accurate, and he kept my interested.
Katerina Andreopoulou
Course - PostgreSQL Administration and Development
The fact that we had a chance to hear about the difference between many databases types.
Marta Melloch - Amazon Development Center Poland Sp. z o.o.
Course - PostgreSQL Administration and Development
useful knowledge
Ewa Napieralska - Amazon Development Center Poland Sp. z o.o.
Course - PostgreSQL Administration and Development
The exercises and that the trainers was very responsive and was listening to us actively. He was also very patient with us. THANK YOU SO MUCH :)
