Geographical databases
GISN06
Please note that this is an internet based course that can only be taken as part of the GIS master program .
Course contents
This course allows you to explore theoretical and practical concepts of geographical databases. That includes design, implementation and usage of geographical databases. The course starts with general database terminologies such as DBMS, SQL, ACID, etc. Then it concentrates on steps for design and implementation of a database. This includes:
- requirement analysis
- conceptual modelling
- internal modelling and physical implementation
You will learn about database modelling using UML, how to create tables from UML, how to normalize tables, how to create tables in a DBMS, as well as indexing techniques. In addition, you learn Structured Query Language (SQL) for creating and managing databases, as well as retrieving data from databases. Finally the course focuses on geographical databases including techniques for managing spatial data in a database, Spatial SQL and indexing techniques in geographical databases.
Teaching methods
Teaching consists of lectures and practical exercises that you submit to your teachers. The course ends with a written exam.
This is and internet based course. You do not need to visit Lund physically in order to attend.
Literature
Course coordinator
Course facts: GISN06
Level: Advanced
Credits: 7.5 ECTS
Period: Spring
Language of instruction: English
Prerequisites: General admission requirements and 90 ECTS, including 30 ECTS in GIS, equivalent to GISA21 and GISA22
Technical prerequisites: PC with Windows 10 or better (ESRI recommentation for system requirements); Internet connection
Course syllabus (pdf, 221 kb, new window)
Reading list (pdf, 112 kb, new window)