[OSGeo Africa] Five day course: Spatial databases with PostGIS

[Serena Coetzee]

Spatial databases with PostGIS presented by Continued Education at the
University of Pretoria, South Africa (www.ceatup.com)
------------------------------------------
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.

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 is presented on Mondays over a period of five weeks. Full-day
attendance on campus for five days for eight hours each day is required.
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.
Three CPD points will be obtained for successful completion of the course.

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

DATES
12, 19, 20, 26 March and 2 April

REGISTRATION ENQUIRIES
Course Coordinator
Mickaele Jenkins
Tel: +27 12 420 6342
Fax: 086 631 7932
E-mail: mickaele.ce at up.ac.za

COURSE CONTENT ENQUIRIES
Course Leader
Dr Serena Coetzee
Tel: +27 12 420 3823
E-mail: serena.coetzee at up.ac.za
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/africa/attachments/20120227/26e88f82/attachment.html