Introduction to PostGIS
Dates & Duration
The course can be booked as a stand-alone course or as an extension to any of our PostgreSQL courses.
See the available dates for this course!
If there is no date and time available for a certain training session you are interested in, please contact us.
The training takes 3 days.
Summary
This course provides an introduction to PostGIS and its most important features and capabilities. From spatial data types to spatial joins, the training will cover all topics concerning quickstart spatial data management and analysis within PostgreSQL. Along with gaining theoretical knowledge, participants will work with real-world datasets to deepen and reinforce their practical skills.
Basic experience with PostgreSQL is required.
Theoretical part
Introduction
- Setup and maintenance of PostGIS
- Tooling (Import, Export, ETL)
- Storage and management of spatial data
Spatial data types and indices
- Spatial data types
- Geometry
- Geography
- Spatial index
- GIST
- SP-GIST
- BRIN
Spatial functions
- Core functions
- Output
- Construction
- Accessor and setter
- Measurement functions
- Composition functions
- Decomposition functions
- Simplification functions
- Topological functions
- Bounding boxes
- Equality
- Relations
- Spatial joins
- Special Functions for processing and analysis
- Spatial aggregation
- Clipping, splitting, tesselation
- Segmentation
- Translation, scaling and rotation
Practical part
Introducing the dataset & Exercises
- Import/Export spatial data
- Validating and fixing spatial data
- Analyzing spatial data
- Visualizing spatial data
Contact us to sign up for this course >>
Other courses that might interest you
We offer these services
PostgreSQL Optimization & Security
Is your database not running smoothly or are you struggling with security issues? Our experts will analyze problems & optimization potentials within a health check or security audit.
PostgreSQL Infrastructure
PostgreSQL Setup & Installation, automation with Kubernetes and database architecture: We’ll find the optimal setup and make sure that your PostgreSQL Infrastructure meets your needs and expectations.
PostgreSQL Setup & Installation
Get started with PostgreSQL by using our Setup & Installation service. We fully focus on your personal needs and infrastructure. In addition to the configuration itself, you also benefit from the knowledge of our experts in the field of database design.