GIS 314 Databases II

This course is a continuation of Database Systems I, and will cover relational database geodatabase skills using mainly Microsoft Access and ESRI Geodatabases with ArcSDE and a PostgreSQL backend. The purpose of this course is to introduce both conceptual and practical aspects of designing and developing both a database and a geodatabase. The course will provide an overview of some design methodologies and models. Following this overview, the course will cover database and geodatabase design and implementation using Access/Geodatabases and optionally ArcSDE on top of PostgreSQL.

Prerequisites: GIS 313 � Database Systems

Accessibility Services Notice

standard statement
Course Details
Total number of weeks15
Total Credits
Total Hours45
Typical hours per week breakdown
Lecture3

Outcomes

Upon successful completion of this course, the learner will be able to:

  1. Design Database
  2. Creating E-R diagrams
  3. Access proficiency
  4. Designing databases and geodatabases
  5. Loading and manipulating data through ArcSDE via PostgreSQL
  6. Building projects in ArcSDE
  7. Loading a database and querying
  8. Database project management
  9. Use standard SQL and PostGIS for geoprocessing
  10. Loading
  11. Manipulating
  12. Geodatabase creation/manipultion
  13. ArcSDE
  14. PostGIS
  15. Entity Relationships
  16. Data desing/dictationaries
  17. Attribute subtypes and domains

Grading Table

Academic and Career

See the Academic Calendar for General Information including how to withdraw from course(s) and other regulations.

Disclaimer

standard statement