ISKB56 Introduction to SQL

Faculty of Arts
Autumn 2020
Extent and Intensity
0/2/0. 4 credit(s). Type of Completion: zk (examination).
Teacher(s)
Mgr. Tomáš Hrabal (lecturer)
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
Thu 18:00–19:40 B2.33
Prerequisites (in Czech)
! VIKMB44 Database Systems
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 30 student(s).
Current registration and enrolment status: enrolled: 0/30, only registered: 0/30, only registered with preference (fields directly associated with the programme): 0/30
fields of study / plans the course is directly associated with
there are 14 fields of study the course is directly associated with, display
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
  • A bit of theory
Teaching methods
Weekly lectures.
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 2021, Autumn 2024.
  • Enrolment Statistics (Autumn 2020, recent)
  • Permalink: https://is.muni.cz/course/phil/autumn2020/ISKB56