|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-spatial-databases-with-postgis-and-qgis/
课程评论：没有评论
课程名称：PostGIS和QGIS 3空间数据库入门 课程概述： 本课程旨在为GIS专业人士提供空间数据库（尤其是PostGIS）的基础知识，帮助他们扩展技能至多用户企业级空间数据库。课程使用最新版本的PostgreSQL (10.1)、PostGIS (2.4) 和 QGIS (3.0)。 您将学习： * 什么是空间数据库及其使用优势。 * SQL是什么，为何使用以及如何应用于地理空间概念。 * 如何在本地安装PostGIS并访问网络或互联网上的生产版本。 * 如何将空间数据加载到PostGIS，并通过多种客户端（特别是QGIS）进行访问。 * 用于空间和非空间查询的基础SQL知识。 * 如何使用PostGIS内置工具验证数据和控制用户访问。 * 查询优化以获得最佳性能。 * 如何在PostGIS中处理栅格数据。 * 使用PL/pgSQL编程自定义函数的基础知识。 * 数据库管理基础，确保数据库平稳运行。
This course is intended to provide an introduction to spatial databases in general and PostGIS in particular to GIS professionals who are interested in expanding their skillset to multi-user enterprise level spatial databases. This course uses the latest (as of 2/18) versions of PostgreSQL (10.1), PostGIS (2.4), and QGIS (3.0). I believe it is the most current and thorough course on spatial databases available today. You will learn What 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 PostGIS locally for development purposes and how to access a production version via a network or the internet.How to load your spatial data into PostGIS 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 PostGISOptimizing your queries for the best performanceHow to work with raster data in PostGISThe basics of programming custom functions with PL/pgSQLThe basics of database administration to keep your database operating smoothly
