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 new 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.
PostGIS DBA Essentials
This course is a basic introduction to the administration tasks required for a PostGIS database. It covers basic administration tasks as well as a step-by-step guide for PostgreSQL and PostGIS installation in the Windows environment. The course explores the different elements of user access including connecting from a remote server and provides guidance and practical examples on roles and role groups for managing security on the PostgreSQL server.
1 day
4 CPD pointsAccesing Server and User Management
Explores types of users and groups available within PostgreSQL and the architecture in which a user can gain access to the database and the various different methods for determining access.
Administration and Monitoring
Explores the database server, database objects and events including starting and stopping, server version and uptime. Database folder location, size along wtih logging and monitoring.
Configuration and Performance Tuning
Managing database parameters whether the default or for a session. Performance tuning for spatial data according to your server RAM resources and backing up the database.
Indexes
Understanding what an index is and how to create one. Using clusters to improve query performance. Locating indexes and using the Vacuum Analyse command.
Administration Tasks
Writing psql scripts allowing for the altering of tables by adding / removing columns, changing datatypes or moving between schemas and tablespaces.
Maintenance Tasks
One of the most important commands is the Vacuum command and when to use. Also covered is the loading of “bulky” data and the impacts this has.
Backup and Recovery
Use of commands such as pg_dump & pg_restore and other backup procedures. Changing database versions and password management.
Further Considerations
Issues and further considerations including “what ifs” such as running out of disc space or losing service account permissions.
All PostGIS training is now delivered online
Meet the author
Ian is a member of the GeoTools PSC & GeoServer PMC.
He is the founder and code committer for the GeoTools java library which provides the underpinning spatial tools for GeoServer.
He has extensive experience working with Open Source software (PostGIS, GeoServer, QGIS and others) spanning over 25 years.