Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 8 Minute(s)
Language
English
Taught by
HA. E-Learning Academy
Rating
Course Overview
Spatial Databases Management , SQL Queries & GIS Analysis
PostGIS is a powerful spatial extension for PostgreSQL that allows you to store, analyze, and manipulate geographic and geometric data with precision and efficiency. This course offers a complete learning journey through PostGIS—updated with the latest features.
You'll start with foundational concepts, gradually building up to advanced spatial queries, performance optimization, and real-world applications. Whether you're managing vector or raster data, creating spatial indexes, or performing proximity analysis, each topic is presented in a clear and practical way.
QGIS and GeoServer are also introduced in the course as companion tools to visualize your spatial data and explore query results, helping you bridge the gap between spatial theory and practical implementation.
In addition to core PostGIS skills, the course includes a hands-on Web GIS web application built using web mapping library, where you'll learn to dynamically insert and retrieve spatial data from PostGIS. This real-world integration demonstrates how to connect your database to modern, interactive web maps—an essential skill for any aspiring Web GIS developer.
No previous experience with spatial databases is required. By the end of the course, you’ll be equipped with the skills and confidence to manage and analyze spatial data effectively using PostGIS in a wide range of geospatial projects.
Course Content
- 18 section(s)
- 39 lecture(s)
- Section 1 Course Introduction
- Section 2 Introduction to PostgreSQL and PostGIS
- Section 3 Understanding Spatial Data
- Section 4 Setting Up Your Environment
- Section 5 Importing Spatial Data
- Section 6 Creating and Managing Tables
- Section 7 Working with PostGIS and SQL
- Section 8 Indexing and Performance
- Section 9 Understanding SRID
- Section 10 Spatial Analysis Techniques
- Section 11 Routing and Network Analysis
- Section 12 QGIS and PostGIS Integration
- Section 13 GeoServer and PostGIS Integration
- Section 14 Building a Web GIS Application with PostGIS Integration
- Section 15 Troubleshooting and Reference
- Section 16 Miscellaneous
- Section 17 Assessment
- Section 18 Closure
What You’ll Learn
- Introduction to PostgreSQL, PostGIS, and pgAdmin, Step-by-step installation and configuration for a smooth start, Learn how to create and manage databases using both pgAdmin (GUI) and the command line interface (CLI)., Understand how to design and manage spatial and non-spatial tables effectively, Upload and manage Shapefiles,GeoJson data and CSV files in your PostGIS databaseConnect and manage your spatial database using QGIS and GeoServer, Learn key concepts like normalization, primary/foreign keys, and relational models for efficient data structuring, Explore vector geometry, raster, and other spatial data types, Upload Shapefiles using both CLI (psql) and pgAdmin’s Import/Export Wizard, Import GeoJSON data into your spatial database, Load KML/KMZ files using the ogr2ogr utility, Import raster data using raster2pgsql for spatial analysis., Work with Coordinate Reference Systems (CRS) and SRID functions, Write effective SQL queries for spatial and non-spatial data, Perform inserts, updates, and deletions on spatial records, Use spatial joins and spatial relationship queries to extract meaningful insights, Apply spatial indexing, VACUUM, and ANALYZE for optimized performance, Learn how to boost query performance using GiST (Generalized Search Tree) indexes in PostGIS., Connect and manage your spatial database using QGIS and GeoServer, Dynamically connect PostGIS with web mapping library to insert, query, and display spatial data on interactive maps
Skills covered in this course
Reviews
-
MMomoh K Musa
I am still evaluating the course.
-
NNoor
The provided resources include each query, which makes it easier to practice the exercises alongside the lecture
