|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgis-from-scratch/
课程评论：没有评论
## Coursera 课程总结：《PostGIS 入门：用 QGIS 精通 PostGIS》 本课程旨在教授您 PostGIS（PostgreSQL 的强大空间数据库扩展）的核心概念和高级用法，帮助您高效地存储、分析和处理空间数据。即使您没有空间数据库的经验，本课程也将从零开始，循序渐进地引导您掌握各项技能。 **课程亮点：** * **全面覆盖：** 深入讲解 PostGIS 的最新功能（更新至 2024 年），涵盖从基础知识到高级空间查询、数据优化和实际应用。 * **QGIS 辅助：** 结合 QGIS 工具，可视化和探索 PostGIS 查询结果，提升学习理解力，并掌握将 QGIS 连接到 PostGIS 数据库的方法。 * **实用技能：** 教授如何安装 PostgreSQL 和 PostGIS、使用 pgAdmin、在 PostGIS 中上传和管理 shapefile 及 CSV 文件、处理大型数据集，以及数据库表的管理和关系（一对一、一对多、多对多）。 * **空间分析：** 学习空间和非空间查询、向量几何和栅格数据类型、坐标参考系统函数、数据过滤、限制和排序，以及空间索引、 Vacuum 和 Analyze 操作。 * **高级主题：** 探索空间连接和空间关系查询，并介绍 PL/pgSQL 基础知识，包括控制结构、函数和过程。 **学习目标：** 完成本课程后，您将具备独立处理空间数据、利用 PostGIS 实现各种应用场景的技能和信心。 **特别提示：** 优惠码为当前月份大写字母加年份，例如：MAY2025、JUNE2025、JULY2025。
**DISCOUNT CODE**: Use the current month in uppercase followed by the year.Examples: MAY2025, JUNE2025, JULY2025PostGIS is a powerful spatial database extension for PostgreSQL, enabling advanced spatial data storage, analysis, and manipulation.This course focuses on the latest capabilities of PostGIS (updated for 2024) and is one of the most comprehensive PostGIS courses available on UDEMY. Starting from the very basics, you'll progress through advanced spatial queries, data optimization techniques, and practical use cases. Along the way, QGIS is introduced as a tool to visualize and explore spatial query results, enhancing your understanding of the database concepts.No prior experience with spatial databases is required, as we start from scratch and cover all the essential concepts.By the end of this course, you'll have the skills and confidence to handle spatial data efficiently and leverage PostGIS for diverse applications.More details about what the course coversIntroduction to PostGISPostgreSQL and PostGIS installationIntroduction to pgAdminQGIS installation including connecting QGIS into the PostGIS databaseUploading shapefiles and CSV into the PostGIS databaseHandling large datasets in QGISIntroduction to Spatial and non-spatial queries and geometry typeCoordinate Reference System FunctionsFiltering, limiting and sorting dataData Types including Vector Geometry and RasterManaging Database Tables and Primary and Foreign KeysDatabase Relationships including one-to-one, one-to-many and many-to-manySpatial Insert, Update and Delete recordsSpatial Indexing and Vacuum and AnalyzeSpatial Joins and Spatial Relationship QueriesPL/pgSQL basicsPl/pgSQL control structures, functions and proceduresAnd much more!
