PostGIS Training

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 points

Getting 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.


If you’re interested in PostGIS DBA Essentials training, please contact us

1 day 

4 CPD points

Accesing 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.