syllabus

🗄️ Module 4: PostGIS Database Orchestration

Expected Release: Sunday, November 10, 2025
Expected Due Date: Sunday, November 16, 2025 at 11:59 PM MST
Status: 📝 DRAFT - Materials in Development

📊 View Detailed Status

💬 PostGIS Discussions

❓ Q&A

---

⚠️ Module Under Development

This module is currently being finalized and will be released on Sunday, November 10, 2025 after Module 3 completion.

---

🎯 Module Overview (Preview)

Module 4 introduces spatial databases with PostGIS, teaching you to manage, query, and analyze spatial data at enterprise scale. You’ll learn 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

Why This Matters: PostGIS powers spatial data infrastructure for governments, utilities, and major organizations worldwide. Database skills distinguish GIS professionals from technicians and open doors to backend development, data engineering, and enterprise GIS roles.

---

📚 Planned Content

Videos (6+)

Spatial databases intro, SQL fundamentals, PostGIS operations, Docker Compose orchestration.

Activities (3+)

Experience polls, career discovery, progress checkpoints.

Assignments (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)

See detailed module status for complete component list.

---

🗓️ Timeline

Date	Milestone
Nov 10	Module 4 materials released
Nov 10-16	Work on PostGIS assignments
Nov 16	All Module 4 work due (11:59 PM)

---

💡 Preparing for Module 4

While you wait for Module 4 to launch, you can:

1. Complete Modules 2-3 to build your foundation
2. Review SQL basics (optional) - many online tutorials available
3. Ask questions in PostGIS Q&A
4. Explore PostGIS documentation at postgis.net

No software installation required! All database work will be done in GitHub Codespaces with Docker.

---

📞 Questions?

• Module 4 Questions: Post in PostGIS Q&A
• Release Date Questions: See course schedule in D2L
• Module Status: Check MODULE_STATUS.md for development progress

---

← Back to Course Home

View Detailed Status →

This site is open source. Improve this page.