CE at UP: Spatial databases with PostGIS

This course provides a practical introduction to PostgreSQL with PostGIS, covering the following major themes of spatial databases: installing and configuring PostGIS, viewing PostGIS data in a desktop GIS, spatial SQL queries, spatial joins and spatial indexing. Although the theory is explained, most of the time during the course will be spent on practical examples, ensuring that delegates understand how to view spatial data, query spatial databases, etc. The course aims to equip the delegates with the necessary skills and knowledge to use spatial databases in the daily operations of their respective jobs.
  • CE at UP: Spatial databases with PostGIS
  • 2015-07-06T08:00:00+01:52
  • 2015-07-10T17:00:00+01:52
  • This course provides a practical introduction to PostgreSQL with PostGIS, covering the following major themes of spatial databases: installing and configuring PostGIS, viewing PostGIS data in a desktop GIS, spatial SQL queries, spatial joins and spatial indexing. Although the theory is explained, most of the time during the course will be spent on practical examples, ensuring that delegates understand how to view spatial data, query spatial databases, etc. The course aims to equip the delegates with the necessary skills and knowledge to use spatial databases in the daily operations of their respective jobs.
  • What course
  • When 06 Jul, 2015 08:00 AM to 10 Jul, 2015 05:00 PM (Africa/Johannesburg / UTC186)
  • Where University of Pretoria
  • Contact Name
  • Add event to calendar iCal
LEARNING OUTCOMES
After completion of the course delegates should be able to:
- create a spatial database in PostGIS;
- load spatial data into a PostGIS database;
- view spatial data in a PostGIS database from QGIS;
- manipulate and query spatial data with SQL; and
- tune PostgreSQL for efficient spatial data access.

OUTLINE OF COURSE CONTENT
The course covers the following topics:
- Object-relational databases with PostgreSQL
- Spatial databases with PostGIS
- Manipulate and query spatial databases with SQL
- Configuring PostgreSQL and PostGIS for spatial data

WHO SHOULD ATTEND
The course is aimed at people working in the GIS industry who want to use PostGIS spatial databases in their work. A basic knowledge of GIS is required.

ACCREDITATION
The University of Pretoria is an accredited higher education provider. PLATO CPD points can be obtained for course attendance.

2015 DATES
Full day attendance on campus for five days of eight hours each on 6-10 July 2015.

CERTIFICATE
A University of Pretoria certificate is awarded to delegates who successfully complete the theory and practical assessment.

2015 COURSE FEES
The course fee is R8,800.00 (VAT inclusive) and includes course material, lunch and refreshments. The course fee is payable by the start date of the course.

REGISTRATION ENQUIRIES
Samedah Davis: 012 420 5015, info.ce@up.ac.za

COURSE CONTENT ENQUIRIES
Serena Coetzee: 012 420 3823, serena.coetzee@up.ac.za
Gavin Fleming: 084 596 5680, gavin@afrispatial.co.za

© 2020 Geo-Information Society of South Africa
Privacy Policy | Terms & Conditions
Stock photos from Pexels