Introduction to PostGIS
Dates & Duration
The course can be booked as a stand-alone course or as an extension of any of our PostgreSQL courses.
This training can also be held at your location, or as online training specifically tailored for your company. In that case, the course agenda can also be adapted to best suit your needs.
Learn more about our customized training >>
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.
This course takes 1 day with 8 hours (on site) or 5 hours (online).
The only difference is that there will be less practical exercises in an online course. However, we will hand them over to you and you can still do them on your own and ask our consultants for feedback or help if needed.
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.
Available Languages
This course can be held in English or German.
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 Security Audit
In our security audit, our PostgreSQL consultants will review your system, document any vulnerabilities, and recommend ways to secure those weaknesses.
PostgreSQL Security
PostgreSQL makes achieving security goals easy: It has all tools to ensure maximum efficiency and superior security. We at CYBERTEC can help to protect your most valuable asset: Your data.
PostgreSQL Update & Upgrade
CYBERTEC can assist you in performing updates and upgrades, also during non-working hours, in order to avoid interruptions in your business operations.