This course provides a detailed guide to installing a PostgreSQL database and adding the spatial plugin PostGIS, in a Windows environment.
You will look at how to configure Network Connectivity and create spatial databases.
You will use SQL (Structured Query Language) within the PGAdmin interface, to add/drop tables; add data and manage the security such as setting roles and permissions.
The performance of the database is key and you will look at monitoring and setting maintenance tasks including the setup of backups and recovery options.
This course is suited to those who will administer, maintain and use spatial data. This course covers some end-user activity such as importing and exporting data from within Cadcorp SIS Desktop, so sufficient knowledge in GIS is required.
- Database Server Specification
- PostgreSQL Database and PostGIS Extensions Installation
- Configuring Network Connectivity
- Database Creation and Database Security
- Import and Exporting data from the desktop GIS
For pricing and to request a place on this training course, please visit: https://www.cadcorp.com/services/training/
AGI CPD Points: 4