VIKBB68 Introduction to SQL

Faculty of Arts
Spring 2016
Extent and Intensity
0/2. 3 credit(s). Type of Completion: zk (examination).
Teacher(s)
Mgr. Tomáš Hrabal (lecturer)
Mgr. Jan Pospíšil (lecturer)
Guaranteed by
PhDr. Petr Škyřík, Ph.D.
Division of Information and Library Studies – Department of Czech Literature – Faculty of Arts
Contact Person: Mgr. Alžběta Šašinková, Ph.D.
Supplier department: Division of Information and Library Studies – Department of Czech Literature – Faculty of Arts
Timetable
Wed 24. 2. to Tue 3. 5. Wed 15:50–17:25 B2.33, Wed 11. 5. Wed 16:40–17:25 B2.33, Wed 18. 5. Wed 15:50–17:25 B2.33
Prerequisites (in Czech)
! VIKMB44 Database Systems
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 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
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 you own data. Beside SQL language, we are going to give you a short introduction to databases and how you can think about relationships between entities in a normal life.
Syllabus
  • An intruduction 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
  • Trends in database technologies, NoSQL databases, examples of usage
Language of instruction
Czech
Further comments (probably available only in Czech)
Study Materials
The course is taught annually.
Information on course enrolment limitations: Pro kurz je nezbytné disponovat notebookem. Máte-li o kurz zájem ale nemáte k dispozici vlastní notebook, je možné si jej na výuku vypůjčit na katedře.
The course is also listed under the following terms Autumn 2016, Autumn 2017, Autumn 2018.
  • Enrolment Statistics (Spring 2016, recent)
  • Permalink: https://is.muni.cz/course/phil/spring2016/VIKBB68