<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>What is the cost? It is very important to include the costs. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><img width=197 height=104 id="Picture_x0020_1"
src="cid:image001.jpg@01CCF52D.DAEEAC70" alt=logo><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><b><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Thulani S Dhlamini<o:p></o:p></span></b></p>
<p class=MsoNormal><b><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Database Administrator<o:p></o:p></span></b></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Mpumalanga Tourism and Parks Agency<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Tel: (+27)
13 759 5597<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Fax: (+27) 86
624 1164<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>E-mail: <a href="mailto:???????@mtpa.co.za">Thulani.Dhlamini@mtpa.co.za</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Postal: P/Bag X11338, Nelspruit, 1200<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Website: <a href="http://www.mpumalanga.com">www.mpumalanga.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
africa-bounces@lists.osgeo.org [mailto:africa-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Serena Coetzee<br>
<b>Sent:</b> 27 February 2012 08:14 AM<br>
<b>To:</b> africa@lists.osgeo.org<br>
<b>Subject:</b> [OSGeo Africa] Five day course: Spatial databases with PostGIS<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Spatial databases with PostGIS presented by Continued
Education at the University of Pretoria, South Africa (<a
href="http://www.ceatup.com">www.ceatup.com</a>)<br>
------------------------------------------<br>
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.<br>
<br>
LEARNING OUTCOMES<br>
After completion of the course delegates should be able to:<br>
- create a spatial database in PostGIS;<br>
- load spatial data into a PostGIS database;<br>
- view spatial data in a PostGIS database from QGIS;<br>
- manipulate and query spatial data with SQL; and<br>
- tune PostgreSQL for efficient spatial data access.<br>
<br>
OUTLINE OF COURSE CONTENT<br>
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:<br>
- Object-relational databases with PostgreSQL<br>
- Spatial databases with PostGIS<br>
- Manipulate and query spatial databases with SQL<br>
- Configuring PostgreSQL and PostGIS for spatial data<br>
<br>
WHO SHOULD ATTEND<br>
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. <br>
<br>
ACCREDITATION<br>
The University of Pretoria is an accredited higher education provider. Three
CPD points will be obtained for successful completion of the course.<br>
<br>
ASSESSMENT<br>
A University of Pretoria certificate is awarded to delegates who successfully
complete the theory and practical assessment. <br>
<br>
DATES<br>
12, 19, 20, 26 March and 2 April<br>
<br>
REGISTRATION ENQUIRIES
<br>
Course Coordinator<br>
Mickaele Jenkins <br>
Tel: +27 12 420 6342
<br>
Fax: 086 631 7932 <br>
E-mail: <a href="mailto:mickaele.ce@up.ac.za">mickaele.ce@up.ac.za</a><br>
<br>
COURSE CONTENT ENQUIRIES <br>
Course Leader<br>
Dr Serena Coetzee<br>
Tel: +27 12 420 3823<br>
E-mail: <a href="mailto:serena.coetzee@up.ac.za">serena.coetzee@up.ac.za</a><o:p></o:p></p>
</div>
</body>
</html>