GIS Databases – SQL and UML part5
Databases – SQL and UML
Almost all modern database systems (DBMS) can use SQL.
A big part of GIS is database entry, editing and maintenance. SQL queries, inputs and deletions can all fine-tune your data.
You should be familiar with SQL and be able to perform SELECT, INSERT, MODIFY and DELETE statements. Joins, relates and further SQL knowledge is greatly valued in the field.
- Intro to SQL: Querying and Managing Data (KhanAcademy) – Manage data in a relational database with SQL. This free course teaches you how to use SQL to store, query, and manipulate data. (Intro to SQL: Querying and managing data)
- ntro to Relational Databases (Udacity) – Write code using a database as a back-end to store application data reliably and safely in SQL and Python (Intro to Relational Databases)
When given a database, explore the data models within it. Understand the structure of the database. This database design structure are often represented in UML diagrams.
It’s often the case you can use design tools like Microsoft Visio. Most design work for data models use it.
Practice, practice, practice!
Come up with a project and practice using your new SQL skills. If an employer asks for a portfolio, you have some good examples to share.
000 00000000000
0 Response to "GIS Databases – SQL and UML part5"
Post a Comment