DIGA610 Relational Database Design and Administration (3 cr.)

This course follows a logical progression from basic data types into normalization and relational database design.  Stages of database design are addressed as well as techniques for documenting database workflows and schemas. The course explores implementing methods to promote spatial and tabular data integrity and facilitate analytical workflows. Structured query language (SQL) for querying, modifying, and managing data is also covered. The course includes enterprise database topics such as permissions, replication, and performance optimization.

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. Format, manage, and implement both spatial and tabular storage.
3. Design and develop databases that promote data integrity and usability.
4. Demonstrate a basic knowledge of relational database management systems.
5. Use basic structured query language to manage and query databases.
6. Plan and implement databases to meet specifications of various stakeholders.