PostGIS Essentials training
A one day introduction to PostGIS.
This course is for GIS users who need to work with Postgres/PostGIS databases to load, query and manage data, using open source end user tools including pgAdmin and QGIS, and making use of the PostGIS extension, which brings spatial capability to Postgres.
The course can be combined with our SQL for Postgres/PostGIS course to give delegates a solid grounding in managing and querying spatial data in a Postgres database.
1 day
8 CPD pointsGetting Started
Meet your trainer and fellow delegates.
Learn about the client/server architecture, common database components and start becoming familiar with key terminology.
End User Tools
Understand how you can interact with databases via database management tools (e.g. pgAdmin) and desktop GIS (e.g. QGIS).
Loading Data to Postgres
Learn how to load data to Postgres using QGIS, SQL and the GDAL ogr2ogr tool.
Postgres Nuts & Bolts
Explore the building blocks of a Postgres database, including schemas, tables and columns. Understand how login and group roles control access to database objects.
Getting Started with SQL
Practice constructing and running simple queries in SQL, such as SELECT, WHERE, COUNT and UPDATE.
Close
A final chance to ask questions before completing your feedback form. We’ll send you your training certificate via email.