GEOG 868
Spatial Database Management
Image
database entity relationship diagram

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.

At a Glance

Details

Credits
3.00
Topics
Applications in GIS
Geospatial Programming and Software Development
Technologies
Amazon Web Services
ArcGIS Pro
ArcSDE/Multiuser Geodatabases
PostgreSQL/PostGIS
QGIS
SQL
SyllabusGEOG 868 Syllabus

Upcoming Offerings

Semester Instructor
Spring 1, 2023 Jim Detwiler, M.S.
Summer, 2023 Jim Detwiler, M.S.
Fall 1, 2023 Jim Detwiler, M.S.

Meet Our Faculty Instructors

What Our Students Say

Helped make me a more well-rounded and versatile employee.

“[This] course provided me with great hands-on experience in how to design and administer an ArcSDE database, including how to do so using a cloud-based web server. All of these skills are relevant in the workplace and helped make me a more well-rounded and versatile employee.”

— Adam Shinal

The addition of the GIS-centric commands helped me prepare for a new position.

“Being a long time developer, I wondered what this course might teach me that I already had not run into during my career. I was pleasantly surprised that the course went deeper into SQL than expected and the addition of the GIS-centric commands helped me prepare for a new position … that required these geospatial skills.”

— Ron Ingraham, Principal Software Engineer

We offer over 30 courses in five 10-week terms each year: two every fall, two every spring and one every summer.