Course Outline
Introduction to PostgreSQL for Government
- A Brief History of PostgreSQL
- Key Features for Government Applications
- Summary of Internal Architecture
- Limits and Terminology for Government Use
Installation and Configuration for Government Systems
- Pre-requisites for Government Environments
- Installation from Packages and Database Creation for Government
- Installation from Source Code for Government Systems
- Client Installation for Government Users
- Starting and Stopping a Database Server for Government Operations
- Environment Setup for Government Use
The SQL Language for Government Applications
- SQL Syntax for Government Data Management
- Data Definition for Government Databases
- Data Manipulation for Government Records
- Queries for Government Reporting and Analysis
- Data Types for Government Use
- JSON Support for Government Applications
- Functions and Operators for Government Operations
- Type Conversion for Government Data Integrity
- Indexes for Government Query Performance
Transactions and Concurrency for Government Databases
- Transactions and Isolation Levels for Government Systems
- Multi-Version Concurrency Control for Government Applications
Client Interfaces for Government Use
- Command Line Interface - psql for Government Users
- Graphical Interface - pgadmin4 for Government Operations
Server Programming for Government Applications
- Extending SQL for Government Needs
- Triggers for Government Data Integrity
- The Rule System for Government Database Management
- Procedural Languages for Government Use
- PL/pgSQL - SQL Procedural Language for Government Applications
- Error Handling for Government Systems
- Cursors for Government Data Retrieval
Foreign Data Wrappers for Government Databases
- Extension in PostgreSQL for Government Use
- Adding FDW in a Government Database
- postgres_fdw for Government Interoperability
- file_fdw for Government Data Import/Export
- Other FDWs for Government Applications
SQL Tuning for Government Performance
- Logging in PostgreSQL for Government Operations
- Query Plans for Government Optimization
- Optimizing Queries for Government Systems
- Statistics for Government Data Analysis
- Planner Parameters for Government Query Efficiency
- Parallel Query Scans for Government Performance
- SQL Best Practices for Government Use
- Indexes for Government Query Speed
- Table Partitioning for Government Scalability
Requirements
A foundational understanding of SQL for government data management and analysis.
Testimonials (7)
He was amazing at adapting the training session to our needs.
Anatoliy - Samsung Cambridge Solution Centre Ltd
Course - PostgreSQL for Developers
the training material
Ashwin - Samsung Cambridge Solution Centre Ltd
Course - PostgreSQL for Developers
Trainer Michał. He is well prepared. His knowledge is very wide and his way of teaching is also great.
Ireneusz - Inter Cars S.A.
Course - PostgreSQL for Developers
I liked the exercises
Luis - Verizon Connect
Course - PostgreSQL for Developers
I thoroughly enjoyed the training. He remained patient with all of the questions, making hands on learning incredibly enjoyable. I'd be thrilled to take another class with him.
Birdesha - Verizon Connect
Course - PostgreSQL for Developers
Covered a large amount of content, in a clear and concise manner.
Dan Bowyer - Verizon Connect
Course - PostgreSQL for Developers
The training was absolutely fantastic, thanks to Michal's exceptional expertise and engaging teaching style. His in-depth knowledge on PostgreSQL was evident throughout the sessions and was able to share many complex concepts in a clear and simple manner. He was well prepared and there was good balance between theory and practical demonstrations. I look forward to applying the knowledge gained from these sessions and thanks again Michal for an exceptional training experience.
