Course Outline

Module 1

• Introduction to the Geodatabase: Geodatabase types; compressing geodatabase; upgrading geodatabase
• Relational Database Concepts and Theory
• Database Design concept, Implementing a database design,adding,updating and deleting records in a database

Module 2

• Getting started with PostGIS
• Building PostgreSQL/PostGIS and MS access databases
• Query writing (spatial select queries)
• PostGIS Geometry types
• Working with views
• Spatial relationship and measurements functions
• Types of databases(operational databases, end-user databases, distributed databases, analytical databases, relational databases, hierarchical databases and database models

Module 3

• Database models
• Database Management Systems (database management systems include PostgreSQL, MySQL, Microsoft SQL Server, Oracle, IBM DB2 and SAP.)
• Distributed databases(Homogeneous Distributed Databases Management System)

Module 4

• Entity Relation diagrams and normalization
• Design and populate a geodatabase: Design principles; creating schemas; spatial reference
• Create data / export data: Geodatabase elements; Create feature classes and feature datasets; assign spatial reference, import & export data, Load data
• Data adjustment: Georeferencing; Spatial adjustment

Module 5

• Spatial behavior: Geodatabase topology; Edit using geodatabase topology; Map topology(spatiaLite)
• Geometric Networks: Create a network; Utility network analysis
• Labels & annotation: Create labels; Convert labels to annotation; Edit annotation
• ArcGIS Online (optional) or leaflets/open layers: Create an online map; Open online map in Desktop; Publish a desktop map to the web