ISKB56 Introduction to SQL

Faculty of Arts
Autumn 2024
Extent and Intensity
0/2/0. 4 credit(s). Type of Completion: zk (examination).
Synchronous online teaching
Teacher(s)
Mgr. Jan Pospíšil (lecturer)
Mgr. Tomáš Marek (assistant)
Guaranteed by
PhDr. Petr Škyřík, Ph.D.
Department of Information and Library Studies – Faculty of Arts
Contact Person: Mgr. Alice Lukavská
Supplier department: Department of Information and Library Studies – Faculty of Arts
Timetable
each odd Thursday 12:00–15:40 B2.33, except Mon 18. 11. to Sun 24. 11.
Prerequisites (in Czech)
Tento předmět z nové akreditace nahrazuje B předmět s kódem VIKBB68. Pokud máte absolvován předmět VIKBB68, ISKB56 si nezapisujte.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 33 student(s).
Current registration and enrolment status: enrolled: 36/33, only registered: 7/33, only registered with preference (fields directly associated with the programme): 6/33
fields of study / plans the course is directly associated with
Course objectives
The aim of this course is to show how to use SQL language for solving practical tasks of getting information from existing databases or your own data. Besides SQL language, we are going to give you a short introduction to databases and how you can think about relationships between entities in normal life.
Syllabus
  • An introduction or why it makes sense to teach SQL even at Humanities
  • SQL: Basic queries
  • How to set up your own database and fill it with data
  • SQL: Using more tables
  • SQL: Complex queries
Teaching methods
The course is available for distance students as well. The student will discuss assessment methods and criteria with course teachers.
Assessment methods
Written and practical examination.
The course is available for distance students as well. The student will discuss assessment methods and criteria with course teachers.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Autumn 2019, Autumn 2020, Autumn 2021.
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/phil/autumn2024/ISKB56