GS2210 - Database Design and Development

This course builds on GIS Database Principles to introduce advanced relational database topics that are increasingly important for GIS and mapping professionals. Through application of the basic principles of relational database design, students will learn how to design a model of the users' view of their data and express it as an entity-relationship model. Core concepts of database development will also be explored, including normalizing tables, establishing appropriate relationships between data, establishing metadata, determining domains, and capturing business rules. The course includes topics in data processing with SQL and procedural extensions in industry-standard client server environments. The course also provides a detailed exploration of GeoDatabase.

Prerequisite(s): GS1210

This course is offered in the following programs:
GIS Applications Specialist (Post Diploma)