Spatial Database Management

Course Description

A spatial database is the backbone of a successful organization or website that depends upon maintaining and using data pertinent to locations on Earth. In GEOG 868, Spatial Database Management, capabilities specific to Relational Database Management Systems (RDBMS) and Geographic Information Systems (GIS) are combined to teach students to create, maintain, and query spatial databases in both desktop and enterprise environments. Learn the basics of Standard Query Language (SQL) and database design/normalization, the specifics of managing spatial data in an open-source technologies context (Postgres/PostGIS) and in the context of the Esri geodatabase. Along the way, you will become familiar with spatial functions and versioning, the latter in a server environment hosted by Amazon Web Services.

This course is part of the following programs: Master of Professional Studies in Homeland Security and Masters of Geographic Information Systems.

Online Course

You can view the entire course here: Spatial Database Management (GEOG 868)

Download Course Files

Click this link and fill out a short form to begin your download: Download Spatial Database Management (GEOG 868) Course Files
Jim Detwiler

Hi, I'm Jim Detwiler. I've been an instructor in the Geography Department's online GIS program since 2000. Back then, we had just a one-year, non-credit certificate program with few electives. Today, we offer a Master of GIS degree with numerous electives that enable students to focus on application areas of interest to them. I'm very proud to be associated with this program, both in terms of the faculty involved and the adult professionals who enroll in it. Since joining the online geospatial program, I have authored and taught GEOG 485: GIS Programming and Customization (a VBA/ArcObjects course that's now retired), GEOG 489: GIS Application Development, GEOG 863: GIS Mashups and GEOG 897D: Spatial Database Management, first offered in 2002, 2005, 2008, and 2012, respectively.

Hello, my name is Jim Sloan. I teach three of our courses in this online Certificate and Master's programs: this course (Geography 897D), Geography 482: The Nature of Geographic Information, and Geography 484: GIS Database Development. I've been a member of the faculty in this program since January of 2003.

Course Departments