---
title: 'Geodatabase with QGIS and PostGIS'
url: 'https://www.faunalia.eu/en/training/geodatabase'
markdown: 'https://www.faunalia.eu/en/training/geodatabase.md'
lang: en
date: '2025-03-27'
description: 'Geodatabase training with QGIS and PostGIS'
taxonomy:
  archives_month:
    - mar_2025
  archives_year:
    - '2025'
---

# Geodatabase with QGIS and PostGIS

The Geodatabase course is aimed at those who need to learn how to manage a geodatabase containing complex geographic data. The course also covers the use of PostGIS, a set of functions that enable complex geoprocessing within the database, displayed in real-time.

Basic knowledge of the SQL language is advised.

 ![Geodatabase with QGIS](https://www.faunalia.eu/images/a/4/e/7/f/a4e7f922cb210b03af19da8d148cc2ee95cffe93-postgis1.png)![Geodatabase with QGIS](https://www.faunalia.eu/images/1/c/6/1/3/1c6139411dff37ccb0156a4519d3648fd23641f1-postgis2.png)![Geodatabase with QGIS](https://www.faunalia.eu/images/5/1/4/1/7/514177699907fe31c0280a4a83d6da3c5d6da715-postgis3.png)

## Course outline

- Short introduction to Free and Open Source GIS
- Advantages of using a database for GIS
- Introduction to [PostgreSQL](https://www.postgresql.org/)
- Initial database configuration: configuration files, server management
- Introduction to PostgreSQL optimization
- Introduction to [PostGIS](http://postgis.net/) ([Open Geospatial Consortium](http://www.opengeospatial.org/) standard)
- Geodatabases: structure and format of the data
- Command line administration: psql
- The graphical front-ends: QGIS, phpPgAdmin, pgAdmin 4, OpenOffice, etc.
- Administration of the database and access to the data: role, user, group, permissions
- Schemas, Tables, Views, and Functions
- Creation of a geodatabase and the use of the GIS template
- PostGIS and QGIS

    - Properties, import/export, conversion between formats
    - digitizing
    - queries, advanced *plugins*, versioning, etc.
- SQL spatial analyses: practical exercises, basic and advanced
- Spatial indexes
- Benchmarking
- Advanced geodatabase functions
- Spatial reference systems, conversions
- PostGIS rasters
- Backing up (dumping and restoring)

## Length

16 hours split in 4 half days

---

## Navigation

- Parent: [Training](https://www.faunalia.eu/en/training.md)
- Previous: [Analysis with QGIS](https://www.faunalia.eu/en/training/analysis-with-qgis.md)
- Next: [WebMapping with QGIS](https://www.faunalia.eu/en/training/webgis.md)