<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 color="#666666" face="arial narrow, sans-serif" size="4" style="background-color:rgb(255,255,255)">Cameron Muller<br></font><div><font color="#666666" face="arial narrow, sans-serif" style="background-color:rgb(255,255,255)">Honours in Science: Geography and Environmental Sciences</font></div><font style="background-color:rgb(255,255,255)">
</font><div><font color="#666666" face="arial narrow, sans-serif" style="background-color:rgb(255,255,255)">University of KwaZulu-Natal - Pietermaritzburg<br></font></div><div><font color="#666666" face="arial narrow, sans-serif" style="background-color:rgb(255,255,255)">GISc Technician (GT 1770)<br></font></div><div><span style="background-color:rgb(255,255,255)"><font color="#666666" face="arial narrow, sans-serif"><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 color="#666666" face="arial narrow, sans-serif" size="4" style="background-color:rgb(255,255,255)">Cameron Muller<br></font><div><font color="#666666" face="arial narrow, sans-serif" style="background-color:rgb(255,255,255)">Honours in Science: Geography and Environmental Sciences</font></div><font style="background-color:rgb(255,255,255)">
</font><div><font color="#666666" face="arial narrow, sans-serif" style="background-color:rgb(255,255,255)">University of KwaZulu-Natal - Pietermaritzburg<br></font></div><div><font color="#666666" face="arial narrow, sans-serif" style="background-color:rgb(255,255,255)">GISc Technician (GT 1770)<br></font></div><div><span style="background-color:rgb(255,255,255)"><font color="#666666" face="arial narrow, sans-serif"><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">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>