GIS642 Database Design and Administration (3 cr.)

Prerequisite(s): GIS605  or equivalent
This course follows a logical progression from basic data types into normalization and relational geodatabase design. The course explores implementing methods to promote spatial and tabular data integrity and facilitate analytical workflows. Standard query language (SQL) for querying, modifying, and managing data is also covered. The course includes enterprise geodatabase topics such as permissions, versioning, replication, and archiving.

Upon completion of this course, students are expected to be able to do the following:

1. Demonstrate knowledge of database terminology, design techniques, and data issues.
2. Collect, format, manage, and implement both spatial and tabular data within a GIS.
3. Design and develop geodatabases that promote data integrity and usability.
4. Demonstrate a basic knowledge of relational database management systems.
5. Use basic standard query language to manage and query databases.
6. Plan and implement databases to meet specifications of various stakeholders.