PostGIS training - Getting started with PostGreSQL as a spatial database

Description

The training on PostGIS - Getting Started with PostGreSQL as a Spatial Database is designed for professionals in geomatics and computer science who want to acquire the necessary skills to use PostGIS as a spatial database management system with PostGreSQL. PostGIS is an open-source extension of PostgreSQL that enables the storage, manipulation, and analysis of spatial data, providing advanced functionalities for geospatial applications. 

During this 3-day training, participants will explore the basic features of PostGIS and learn how to apply them in practical scenarios. Experienced trainers will guide learners through hands-on exercises, demonstrations, and case studies to develop their understanding and proficiency in using PostGIS.

Day 1:

  • Introduction to geomatics and spatial databases
  • Overview of PostGIS and its key features
  • Installation and configuration of PostGIS with PostGreSQL
  • Creating spatial tables and inserting data

Day 2:

  • Spatial indexing and spatial queries
  • Manipulating and updating spatial data
  • Using PostGIS spatial analysis functions
  • Hands-on exercises and case studies

Day 3:

  • Performance optimization with PostGIS
  • Managing geospatial data with PostGIS
  • Best practices for development and deployment
  • Review of key concepts and Q&A session

The training on PostGIS - Getting Started with PostGreSQL as a Spatial Database is aimed at professionals in geomatics, geospatial application developers, database administrators, and anyone interested in using PostGIS as a spatial database management system.

To participate in this training, participants should have a basic understanding of relational databases and geomatics. Previous experience with PostgreSQL would be beneficial but not mandatory. Participants should be comfortable with using the command line and have basic knowledge of SQL language.

  1. Understand the fundamental principles of spatial databases and geomatics. 
  2. Learn to install and configure PostGIS with PostGreSQL. 
  3. Master the basic features of PostGIS, including storing and retrieving spatial data. 
  4. Gain skills in creating and managing spatial tables, spatial indexes, and spatial queries. 
  5. Learn to use PostGIS spatial analysis functions to perform advanced geospatial operations. 
  6. Understand best practices for performance optimization and management of geospatial data with PostGIS.

Training Details

  • Reference : COT-POSTGIS03
    Training location : Cotonou
    Date :
    Duration : 3 Days (21 Hrs)
    Price : FCFA900,000

Currency

Training location

We design, build and support digital products for clients who want to make a positive impact in their industry. Creative with technology, we develop great solutions to help our clients grow and especially by strengthening our relationships based on continuous improvement, maintenance, support and hosting services.

Follow us