PřF:Z3104 Geoinformation technologies 1 - Course Information
Z3104 Geoinformation technologies 1
Faculty of ScienceAutumn 2010 - only for the accreditation
- Extent and Intensity
- 1/2. 3 credit(s). Type of Completion: graded credit.
- Teacher(s)
- Mgr. Karel Staněk, Ph.D. (lecturer)
Mgr. Bc. Pavel Janeček (seminar tutor)
Mgr. Helena Řezníková (seminar tutor) - Guaranteed by
- prof. RNDr. Rudolf Brázdil, DrSc.
Department of Geography – Earth Sciences Section – Faculty of Science
Contact Person: Mgr. Karel Staněk, Ph.D. - Prerequisites (in Czech)
- Z0062 Cartography and topography && ! Z8104 Geoinformation technologies 1
- Course Enrolment Limitations
- The course is only offered to the students of the study fields the course is directly associated with.
The capacity limit for the course is 50 student(s).
Current registration and enrolment status: enrolled: 0/50, only registered: 0/50 - fields of study / plans the course is directly associated with
- Geography for Multi-Branches Study (programme PřF, B-GK)
- Geography for Multi-Branches Study (programme PřF, B-MA)
- Geography (programme PřF, B-GK, specialization Physical Geography)
- Geography (programme PřF, B-GK, specialization Human Geography)
- Course objectives
- The main objectives of the course are the following: acquainting students with the database basic with respect to their role in GIS. students acquire query and definition language SQL in relational and post-relational databases making students aware of manipulation with spatial data in above mentioned databases making students aware of document oriented databases
- Syllabus
- 1. Base database models 2. Principles of realtional and postrelational DBMS 3. Relational database design (Chen diagram, data types, keys, normální formy) 4. Definition part of SQL 5. Query part of SQL - introduction 6. Query part of SQL - functions and aggregates 7. Query part of SQL - theta join 8. Object databases 9. Document oriented databases 10. Document oriented databases query languages 11. Spatial data in databases 12. DBMS engines 13. Standards and metadata Exercises 1. Database creation and management 2. Database definition 3. INSERT command 4. UPDATE, Constrains a ALTER TABLE 5. Base of querrying SQL 6. GROUP BY and Aggregating functions 7. Selections from multiple tables I. 8. elections from multiple tables II. 9. Nested queries 10. Database design
- Literature
- Teaching methods
- lectures and practical exercises
- Assessment methods
- final written exam
- Language of instruction
- Czech
- Further comments (probably available only in Czech)
- Study Materials
The course is taught annually.
The course is taught: every week.
- Enrolment Statistics (Autumn 2010 - only for the accreditation, recent)
- Permalink: https://is.muni.cz/course/sci/autumn2010-onlyfortheaccreditation/Z3104