PostgreSQL Developer Fundamentals and PostGIS Training - PFE 729
Specialized training for developers using GIS with PostgreSQL.
This is a specialized training course designed for developers and system administrators who use PostgreSQL’s Geographic Information System (GIS) extension.
Purpose
The aim is for participants to learn the installation and usage of PostGIS, the spatial data extension of PostgreSQL, and to develop their abilities to use basic queries, functions, and operators in a database working with the PostGIS extension.
Target Audience
It targets those who want to implement this using PostGIS, the spatial extension of the PostgreSQL database, or through a setup created from scratch.
Training Notes
Training materials will be distributed electronically in PDF format.
Certification
A certificate of participation will be issued by Profelis.
Prerequisites
Of the participants intermediate SQL having knowledge and preferably pgAdmin or a similar tool how much has set up an application with a user interface since Linux for PostgreSQL PFE111 Having received the training.
Training Duration
- Class: 5 days / 30 hours
- Remote: 5 days / 20 hours
Training Topics
- Basic Data Types
- Basic Functions and Operators
- Query Types: DDL / DML / DQL
- Indexes and Geospatial Data Indexes
- View / Materialized View
- Summarization and Segmentation Functions
- Recursive Queries
- Conditional Statements (CASE WHEN Structure Only)
- Database Programming
- Introduction to Geospatial Data and PostGIS
- PostGIS Management
- Using PostGIS
- PostGIS Data Types
- Basic Functions
- Basic Functions
- Calculation Functions
- Overlap Functions
- Geometric Processing Functions
- Other Functions
PostgreSQL Certificate
