Introduction to Spatial Databases with PostGIS and QGIS 3

Unlock the power of spatial databases with this comprehensive course, designed for GIS professionals looking to elevate their skills to enterprise-level geospatial data management. We'll dive deep into PostGIS, the leading open-source spatial extension for PostgreSQL, using the latest versions (as of 2/18): PostgreSQL 10.1, PostGIS 2.4, and QGIS 3.0. This course offers the most up-to-date and thorough training available.

You'll gain a solid understanding of:

• Spatial Database Fundamentals: Discover what a spatial database is and explore the compelling reasons for leveraging one in your GIS workflows.
• SQL for Geospatial Data: Learn the essentials of SQL and its application to geospatial concepts, enabling powerful data retrieval and manipulation.
• PostGIS Installation & Access: Master the process of installing PostGIS locally for development and connecting to production instances via network or internet.
• Data Loading & Client Access: Efficiently load your spatial data into PostGIS and access it seamlessly from various clients, with a focus on QGIS.
• SQL for Spatial & Non-Spatial Queries: Develop proficiency in SQL for both spatial queries (e.g., finding features within a polygon) and standard data retrieval.
• Data Validation & User Access Control: Implement robust data validation techniques and manage user access effectively using PostGIS's built-in tools.
• Query Optimization: Learn strategies for optimizing SQL queries to achieve peak performance with your spatial data.
• Raster Data Handling: Explore the capabilities of PostGIS for working with raster data, including analysis and visualization.
• PL/pgSQL Custom Functions: Get introduced to PL/pgSQL and learn the basics of creating custom functions to extend PostGIS functionality.
• Database Administration Basics: Understand fundamental database administration tasks to ensure your PostgreSQL and PostGIS database runs smoothly and reliably.

This course empowers you to build and manage powerful, scalable geospatial solutions.