<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style id="owaParaStyle" type="text/css">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body>
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Hi Cameron,<br>
<br>
Here is a manual you can look at, it is partly created by <span class="highlight selected">
Tim</span> Sutton and his wife Marcell<br>
<a href="http://docs.qgis.org/2.6/pdf/en/QGIS-2.6-QGISTrainingManual-en.pdf" target="_blank">http://docs.qgis.org/2.6/pdf/en/QGIS-2.6-QGISTrainingManual-en.pdf</a><br>
Chapter 15 - Module: Database Concepts with PostgreSQL<br>
Chapter 16 - Module: Spatial Database Concepts with PostGIS<br>
Should give you the basics of PostgreSQL and PostGIS<br>
<br>
Tim is part of Kartoza : <a href="http://kartoza.com/" target="_blank">http://kartoza.com/</a><br>
About Kartoza : <a href="http://kartoza.com/kartoza-home/" target="_blank">http://kartoza.com/kartoza-home/</a><br>
<br>
William<br>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div style="direction: ltr;" id="divRpF401622"><font face="Tahoma" size="2" color="#000000"><b>From:</b> africa-bounces@lists.osgeo.org [africa-bounces@lists.osgeo.org] on behalf of Cameron Muller [mullerc24@gmail.com]<br>
<b>Sent:</b> 12 May 2015 14:07<br>
<b>To:</b> Africa local chapter discussions<br>
<b>Subject:</b> Re: [OSGeo Africa] SQL Courses<br>
</font><br>
</div>
<div></div>
<div>
<div dir="ltr">
<div>Thanks very much for the help Charles, I have had a look at PostgreSQL and it definitely seems the better option for application within GIS.
</div>
<div><br>
</div>
<div>I understand this is free package, but is there any means of gaining recognised certification such as exams or workshops as with the MCSA SQL Server exams?</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div><font style="background-color:rgb(255,255,255)" face="arial narrow, sans-serif" size="4" color="#666666">Cameron Muller<br>
</font>
<div><font style="background-color:rgb(255,255,255)" face="arial narrow, sans-serif" color="#666666">Honours in Science: Geography and Environmental Sciences</font></div>
<font style="background-color:rgb(255,255,255)"></font>
<div><font style="background-color:rgb(255,255,255)" face="arial narrow, sans-serif" color="#666666">University of KwaZulu-Natal - Pietermaritzburg<br>
</font></div>
<div><font style="background-color:rgb(255,255,255)" face="arial narrow, sans-serif" color="#666666">GISc Technician (GT 1770)<br>
</font></div>
<div><span style="background-color:rgb(255,255,255)"><font face="arial narrow, sans-serif" color="#666666"><font style="background-color:rgb(255,255,255)">072 686 9200<br>
</font><br>
</font></span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">On Tue, May 12, 2015 at 12:14 PM, Charles Rethman <span dir="ltr">
<<a href="mailto:rethman@me.com" target="_blank">rethman@me.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div style="">Dear Cameron,
<div><br>
</div>
<div>I think you’d really be best off learning your SQL and DB admin with an open source product such as PostgreSQL/PostGIS, for which courses are regularly offered by some of the members of this forum. PostgreSQL/PostGIS is incredibly powerful and you can
write complex functions to manipulate spatial data any way you want.</div>
<div><br>
</div>
<div>Also check out Postgres’s documentation: <a href="http://www.postgresql.org/docs/" target="_blank">http://www.postgresql.org/docs/</a> and some tutorials: <a href="http://www.postgresqltutorial.com" target="_blank">http://www.postgresqltutorial.com</a>,
as well as PostGIS manual: <a href="http://suite.opengeo.org/opengeo-docs/postgis/index.html" target="_blank">
http://suite.opengeo.org/opengeo-docs/postgis/index.html</a>. Also look on Kartoza’s website for some excellent training material. They are all very helpful and are free. I will admit a course is handy to get your head around the initial setting up and getting
to know the product. After that, the both the PostGIS and Postgres manuals are brilliant.</div>
<div><br>
</div>
<div>all the best,</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div>
<div style="">
<div style="color:rgb(0,0,0); text-transform:none; line-height:normal; text-indent:0px; letter-spacing:normal; font-variant:normal; word-spacing:0px; white-space:normal">
<div style="text-indent:0px">
<div style="text-indent:0px"><span style="color:rgb(0,0,0); text-transform:none; line-height:normal; letter-spacing:normal; font-variant:normal; word-spacing:0px; white-space:normal"><font face="Noteworthy" size="5">Charles Rethman</font></span><br>
</div>
</div>
</div>
</div>
<br style="color:rgb(0,0,0); text-transform:none; line-height:normal; text-indent:0px; letter-spacing:normal; font-family:Helvetica; font-style:normal; font-variant:normal; font-weight:normal; word-spacing:0px; white-space:normal">
<br>
</div>
<br>
<div>
<blockquote type="cite">
<div>
<div class="h5">
<div>On 12 May 2015, at 11:57 AM, Cameron Muller <<a href="mailto:mullerc24@gmail.com" target="_blank">mullerc24@gmail.com</a>> wrote:</div>
<br>
</div>
</div>
<div>
<div>
<div class="h5">
<div dir="ltr">
<p>Hi all,<br>
</p>
<p>I am currently working within the GIS industry and looking to expand my knowledge and abilities. I am still fairly new to the industry yet have noticed an increase in the use of SQL.
<br>
</p>
<p>I currently hold a Masters degree in Environmental Sciences but want to add to it with the addition of SQL courses. I have looked at Microsoft accredited courses namely 70-461 (Querying Microsoft SQL Server 2012), 70-762 (Administering Microsoft SQL Server
2012 Databases) and 40-763 (Implementing a Data Warehouse with Microsoft SQL Server 2012).
<br>
</p>
<p>Can the professionals within the industry please advise me as to whether these courses will aid my GIS career and potential or are there specific courses which can be recommended to me?<br>
</p>
<p>Any advice in the right direction will be greatly appreciated.<br>
</p>
<p>Kind regards,<br clear="all">
</p>
<div>
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div><font style="background-color:rgb(255,255,255)" face="arial narrow, sans-serif" size="4" color="#666666">Cameron Muller<br>
</font>
<div><font style="background-color:rgb(255,255,255)" face="arial narrow, sans-serif" color="#666666">Honours in Science: Geography and Environmental Sciences</font></div>
<font style="background-color:rgb(255,255,255)"></font>
<div><font style="background-color:rgb(255,255,255)" face="arial narrow, sans-serif" color="#666666">University of KwaZulu-Natal - Pietermaritzburg<br>
</font></div>
<div><font style="background-color:rgb(255,255,255)" face="arial narrow, sans-serif" color="#666666">GISc Technician (GT 1770)<br>
</font></div>
<div><span style="background-color:rgb(255,255,255)"><font face="arial narrow, sans-serif" color="#666666"><font style="background-color:rgb(255,255,255)">072 686 9200<br>
</font><br>
</font></span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Africa mailing list<br>
<a href="mailto:Africa@lists.osgeo.org" target="_blank">Africa@lists.osgeo.org</a><br>
You can UNSUBSCRIBE at <a href="http://lists.osgeo.org/mailman/listinfo/africa" target="_blank">
http://lists.osgeo.org/mailman/listinfo/africa</a></div>
</blockquote>
</div>
<br>
</div>
</div>
<br>
_______________________________________________<br>
Africa mailing list<br>
<a href="mailto:Africa@lists.osgeo.org" target="_blank">Africa@lists.osgeo.org</a><br>
You can UNSUBSCRIBE at <a href="http://lists.osgeo.org/mailman/listinfo/africa" target="_blank">
http://lists.osgeo.org/mailman/listinfo/africa</a><br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="2"><br>
"This e-mail is subject to our Disclaimer, to view click http://www.dut.ac.za/disclaimer"<br>
</font>
<br /><br />
<p style="font-family: Verdana; font-size:10pt; color:#666666;">
<b>Disclaimer</b>
</p>
<p style="font-family: Verdana; font-size:8pt; color:#666666;">
The information contained in this communication from the sender is confidential. It is intended
solely for use by the recipient and others authorized to receive it. If you are not the recipient,
you are hereby notified that any disclosure, copying, distribution or taking action in relation of
the contents of this information is strictly prohibited and may be unlawful.
<br /><br />
This email has been scanned for viruses and malware, and automatically archived by <b>Mimecast SA
(Pty) Ltd</b>, an innovator in Software as a Service (SaaS) for business. <b>Mimecast Unified Email
Management <span class="style1">™</span> (UEM)</b> offers email continuity, security, archiving and
compliance with all current legislation. To find out more, <a href="http://www.mimecast.co.za/uem" target="_blank">contact Mimecast</a>.
</p>
</body>
</html>