Demographic Data Collection II - MD360P74
Title: Demografické informační systémy II
Czech title: Demografické informační systémy II
Guaranteed by: Department of Demography and Geodemography (31-360)
Faculty: Faculty of Science
Actual: from 2024
Semester: summer
E-Credits: 3
Examination process: summer s.:
Hours per week, examination: summer s.:0/2, C [HT]
Capacity: 55
Min. number of students: unlimited
4EU+: no
Virtual mobility / capacity: no
State of the course: taught
Language: Czech
Note: enabled for web enrollment
priority enrollment if the course is part of the study plan
Guarantor: RNDr. Mgr. Olga Kurtinová, Ph.D.
Incompatibility : MD360P02
Opinion survey results   Examination dates   
Annotation -
The course Demographic Information Systems II is focused on working with medium-sized data files. During the course, students will learn the basic principles of database systems and the basics of using the SQL language. They will also deepen their knowledge of Excel and PowerPoint. Part of the course is devoted to an overview of tools that are currently used to work with data in practice.

The prerequisite for graduation is knowledge of working with computer at the user level.
Last update: Kurtinová Olga, RNDr. Mgr., Ph.D. (11.02.2025)
Literature -

Klaus, V.; Hajný, J. 2014. SQL pro blbce. Palmknihy, 2. rozšířené vydání, 140 s.,  ISBN 978-80-7486-005-8.

Pokorný, J. 1999. Konstrukce databázových systémů. Skripta, Vydavatelství ČVUT, 166 p.

Pokorný, J., Žemlička, M. 2004. Základy implementace souborů a databází, UK Praha, Karolinum.

Riordan, R.M. 2000. Vytváříme relační databázové aplikace, Computer Press, 294 s. ISBN 978-80-7226-360-8.

Taylor, Allen G. 2013. SQL For Dummies, John Wiley & Sons Inc, 8th edition, 483 p., ISBN 978-1-118-62783-9 (ebk).

Šimůnek, M. 1999. SQL – kompletní kapesní průvodce, Grada, 246 s. ISBN 80-7169-692-7. 

Last update: Kurtinová Olga, RNDr. Mgr., Ph.D. (11.02.2025)
Requirements to the exam -

1 homeworks, semester project and 10 minutes presentation of the results of the semester project

Attendance at presentation of results is obligatory

Last update: Kurtinová Olga, RNDr. Mgr., Ph.D. (11.02.2025)
Syllabus -

Sylabus is available in Czech.

Last update: Kurtinová Olga, RNDr. Mgr., Ph.D. (11.02.2025)