|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mysql-for-geospatial-applications/
课程评论：没有评论
课程名称：MySQL地理空间应用 概述：本课程旨在为GIS专业人员提供有关空间数据库的介绍，特别是MySQL，以帮助他们扩展到多用户企业级空间数据库的技能。MySQL几乎可以在所有的网络托管平台上使用，自版本5.6以来，地理空间功能已成为MySQL核心分发包的一部分。这意味着与PostGIS等其他选项相比，使用MySQL建立和部署空间数据库更容易且成本更低。虽然MySQL目前没有PostGIS的所有附加功能，但它具备所有重要的核心功能。本课程使用最新版本的MySQL（8.0）和QGIS（3.28），被认为是当今关于空间数据库最当前和全面的课程。 您将学习到： - 什么是空间数据库以及使用它的原因。 - SQL是什么，为什么要使用它，以及如何将其应用于地理空间概念。 - 如何在本地安装MySQL以进行开发，并通过网络或互联网访问生产版本。 - 如何将空间数据加载到MySQL中，并通过多种客户端访问，特别是QGIS。 - 关于空间和非空间查询的SQL基础知识。 - 如何利用MySQL内置工具验证数据和控制用户访问。 - 优化查询以获得最佳性能的方法。 - 使用MySQL存储过程语言编写自定义函数的基础知识。 - 数据库管理的基础知识，以确保数据库的平稳运行。 - 如何将您的数据库部署在网络托管服务上，使其可供任何拥有互联网连接的用户访问（前提是他们获得了访问权限）。
This course is intended to provide an introduction to spatial databases in general and MySQL in particular to GIS professionals who are interested in expanding their skillset to multi-user enterprise level spatial databases. MySQL is available on almost all web-hosting platforms and geospatial capabilities have been part of the core MySQL distribution since version 5.6. This means that is far easier and less expensive to setup and deploy a spatial database with MySQL than other options such as PostGIS. At this point it does not have all the bells and whistles that PostGIS has but all of the important core functionality is there. This course uses the latest (as of 11/22) versions of MySQL (8.0, and QGIS (3.28). I believe it is the most current and thorough course on spatial databases available today. You will learnWhat a spatial database is and why you would want to use one.What SQL is, why you would want to use it, and how it can be applied to geospatial concepts.How to install MySQL locally for development purposes and how to access a production version via a network or the internet.How to load your spatial data into MySQL and access it from a variety of clients, especially QGISThe basics of SQL for both spatial and non-spatial queriesHow to validate data and control user access with the tools built-in to MySQLOptimizing your queries for the best performanceThe basics of programming custom functions with the MySQL stored procedure languageThe basics of database administration to keep your database operating smoothlyDeploy your database on a web'hosting service so that it is available to anyone with an internet connection (assuming they have been granted access priveleges)
