Database Management System For Geographic Information Systems
Geodesy and Geoinformation Engineering
Institute of Natural and Applied Sciences
Second Cycle (Master's Degree)
| Course Unit Title | Course Unit Code | Type of Course Unit | Level of Course Unit | Year of Study | Semester | ECTS Credits |
|---|---|---|---|---|---|---|
| Database Management System For Geographic Information Systems | JJM524 | Elective | Master's degree | 1 | Spring | 8 |
Name of Lecturer(s)
Associate Prof. Dr. Taner ÜSTÜNTAŞ
Learning Outcomes of the Course Unit
1) Use the SQL programming language
2) Can perform operations in databases with Python
3) Work with script files, procedures, functions and packages
4) Can perform SQL and GeoPandas applications
Program Competencies-Learning Outcomes Relation
| Program Competencies | ||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||
| Learning Outcomes | ||||||||
| 1 | High | High | High | Middle | Middle | Middle | Middle | |
| 2 | Middle | Middle | High | High | Middle | Middle | Middle | |
| 3 | High | High | High | High | Middle | Middle | Middle | |
| 4 | High | High | High | No relation | No relation | No relation | No relation | |
Mode of Delivery
Face to Face
Prerequisites and Co-Requisites
None
Recommended Optional Programme Components
Programming in Geoinformatics
Course Contents
PostgreSQL open source databases using standard relational model and SQL query language support is a powerful database management system. The database components (tables, forms, data access pages, queries, and reports) make use of the database administrator by open-source programs. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC. PostgreSQL database system is used. The relationship between the topology and the Geographic Information System (GIS) is examined.
Weekly Schedule
1) Installing the open source software2) Adding databases and tables
3) Record selection, record filtering
4) 1
5) 1
6) 1
7) 1
8) 1
9) 1
10) 1
11) 1
12) 1
13) 1
14) 1
15) 1
Recommended or Required Reading
1- Python Data Persistence: With SQL and NOSQL Databases, ISBN-13: 978-9388511759, 2019
2- Essential SQLAlchemy: Mapping Python to Databases, ISBN: 149191646X
Planned Learning Activities and Teaching Methods
1) Lecture
2) Lecture
3) Lecture
4) Lecture
5) Lecture
6) Self Study
7) Self Study
8) Self Study
9) Self Study
10) Self Study
Assessment Methods and Criteria
Contribution of Quiz to Course Grade |
40% |
|---|---|
Contribution of Final Examination to Course Grade |
60% |
Total |
100% |
Language of Instruction
Turkish
Work Placement(s)
Not Required