VIKMB44 Database Systems

Faculty of Arts
Autumn 2014
Extent and Intensity
1/1/0. 4 credit(s). Type of Completion: k (colloquium).
Teacher(s)
Mgr. Jan Pospíšil (lecturer)
Mgr. Tomáš Hrabal (lecturer)
Mgr. Tomáš Bouda, Ph.D. (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. Marie Hradilová
Supplier department: Division of Information and Library Studies – Department of Czech Literature – Faculty of Arts
Timetable
Mon 17:30–19:05 L11
Prerequisites
There’s no technical prerequisites for this course. Basic computer skills are completely enough. Also, there’s no need for a special software.
Course Enrolment Limitations
The course is offered to students of any study field.
The capacity limit for the course is 20 student(s).
Current registration and enrolment status: enrolled: 0/20, only registered: 0/20, only registered with preference (fields directly associated with the programme): 0/20
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
Literature
  • KUĆ, Rafał a Marek ROGOZIŃSKI. Elasticsearch server: create a fast, scalable, and flexible search solution with the emerging open source search server, ElasticSearch. Birmingham: Packt Pub., 2013, ix, 294 p.
  • LACKO, Ľuboslav. 1001 tipů a triků pro SQL. Vyd. 1. Brno: Computer Press, 2011, 416 s. ISBN 9788025130100. info
  • KREIBICH, Jay A. Using SQLite. 1st ed. Beijing: O'Reilly, 2010, xx, 503. ISBN 9780596521189. info
Teaching methods
Weekly lectures. Course is available for distance students.
Assessment methods
Written or oral testing.
Language of instruction
Czech
Further Comments
Study Materials
The course is also listed under the following terms Autumn 2015.
  • Enrolment Statistics (Autumn 2014, recent)
  • Permalink: https://is.muni.cz/course/phil/autumn2014/VIKMB44