Module 4 Status: PostGIS Database Orchestration
Status: 📝 DRAFT - Materials in Development
Expected Release: Sunday, November 10, 2025
Expected Due Date: Sunday, November 16, 2025 at 11:59 PM MST
📊 Completion Status
| Component Type |
Status |
Notes |
| Videos |
🚧 In Progress |
Video scripts under development |
| Activities |
🚧 In Progress |
Activity files being finalized |
| Assignments |
🚧 In Progress |
Assignment templates under construction |
| GitHub Discussions |
⏳ Pending |
Categories ready, content pending |
| Grading Rubrics |
🚧 In Progress |
Rubrics being developed |
📚 Planned Module Components
Videos (Planned: 6+)
- 📝 Video 1: Module 4 Introduction & Spatial Databases
- 📝 Video 2: SQL Fundamentals for GIS
- 📝 Video 3: PostGIS Introduction
- 📝 Video 4: Docker Compose & Database Orchestration
- 📝 Video 5: Spatial Queries & Analysis
- 📝 Video 6: Professional Database Workflows
Activities (Planned: 3+)
- 📝 Activity 1: PostGIS Experience Poll
- 📝 Activity 2: Spatial Database Career Discovery
- 📝 Activity 3: Progress Checkpoint
Assignments (Planned: 4-5)
- 📝 M4A1: SQL Fundamentals & Database Setup
- 📝 M4A2: PostGIS Spatial Queries
- 📝 M4A3: Spatial Analysis with PostGIS
- 📝 M4A4: Database Orchestration Project
- 📝 M4A5: (TBD - Advanced spatial SQL)
🎯 Learning Objectives (Planned)
Students completing Module 4 will be able to:
- Design and implement spatial databases using PostGIS
- Write SQL queries for spatial data analysis
- Perform spatial joins, intersections, and buffers in databases
- Use Docker Compose to orchestrate database services
- Connect Python/QGIS applications to PostGIS databases
- Implement professional database backup and migration workflows
🗄️ Module Theme
Spatial databases, SQL fundamentals, and professional database workflows
This module introduces enterprise-grade spatial data management using PostGIS, teaching students how to handle large datasets and multi-user scenarios common in professional GIS environments.
⚠️ For Students
Module 4 content is not yet available. Materials will be released on Sunday, November 10, 2025.
Check back after Module 3 completion for:
- Video lectures and slide decks
- Assignment instructions and GitHub Classroom links
- Discussion activities and polls
Questions about Module 4? Post in PostGIS Q&A Discussions (available now for general database questions)
Last Updated: October 31, 2025