NoPublic, bureaucrat, administrator
6,632
edits
Changes
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..."
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-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/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]].
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/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]].