Difference between revisions of "Portal:Training/SQL"

From IMSMA Wiki
Jump to: navigation, search
(Created page with "In the training courses that GICHD is providing, basic database knowledge and SQL are not included. We have identify website with free online training. recommend ESRI's on-lin...")
 
 
Line 1: Line 1:
In the training courses that GICHD is providing, basic database knowledge and SQL are not included. We have identify website with free online training.
+
In the training courses that GICHD is providing, basic database knowledge and SQL are not included. We have identify websites with free online training.
recommend ESRI's on-line courses. There are courses that are for free and courses that has a cost.
 
 
* [http://www.graspsql.com/sql-tutorial/understand/database-tables-columns-and-rows/ Basic database ]
 
* [http://www.graspsql.com/sql-tutorial/understand/database-tables-columns-and-rows/ Basic database ]
 
* [http://www.graspsql.com/sql-tutorial/retrieve/ SQL].
 
* [http://www.graspsql.com/sql-tutorial/retrieve/ SQL].
  
 
Please note that it is '''not''' wise to add or delete from the IMSMA database with SQL due to the complex database structure. If you need to add data from other data sources e.g. Excel, shape-files and other databases, contact your [[Information Management Team | GICHD IM advisor]].
 
Please note that it is '''not''' wise to add or delete from the IMSMA database with SQL due to the complex database structure. If you need to add data from other data sources e.g. Excel, shape-files and other databases, contact your [[Information Management Team | GICHD IM advisor]].

Latest revision as of 10:41, 3 February 2016

In the training courses that GICHD is providing, basic database knowledge and SQL are not included. We have identify websites with free online training.

Please note that it is not wise to add or delete from the IMSMA database with SQL due to the complex database structure. If you need to add data from other data sources e.g. Excel, shape-files and other databases, contact your GICHD IM advisor.