VIKMB04 Introduction to Structured Query Language

Faculty of Arts
Spring 2009
Extent and Intensity
0/2/0. 4 credit(s). Type of Completion: zk (examination).
Teacher(s)
Ing. Zdeněk Kadlec, Dr. (lecturer)
Guaranteed by
Ing. Zdeněk Kadlec, Dr.
Division of Information and Library Studies - Department of Czech Literature and Library Studies - Faculty of Arts
Contact Person: Mgr. Iva Dušová
Timetable
Mon 8:20–9:55 A01
Prerequisites
! FI:PV003 RDBS Architecture && ! FI:PB155 Database Systems Applications && ! FI:PB154 Database Systems && ! FI:PV136 DB Systems Seminar && ! FI:P002 Introduction to Database Systems && ! FI:P502 Introduction to Database Systems && ! FI:P003 RDBS Architecture && ! FI:P136 DB Systems Seminar
English - reading skill at level of understanding computer manual.
Students of distant learning have to be able to connect to address http://knihomol.phil.muni.cz/cgi-bin/sql.exe over Internet or have to own computer with MySQL database installed.
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 the course is directly associated with
there are 6 fields of study the course is directly associated with, display
Course objectives
Main objectives can be summarized as follows:
to gain basic overview of a SQL database language (Structured Query Language);
to learn by means of SQL to work with relational database MySQL at beginner level;
Syllabus
  • Introduction
  • relational databases principles, RDBMS, client - server architecture, tables, indexes, SQL language principles.
  • 1st part - basic commands and structures
  • show databases, show tables, describe; select from one table, columns selection, alias, rows selection, distinct, sorting, rows grouping, basic aggregation functions (count, sum, min, max, avg).
  • 2nd part - DDL, DML, functions
  • create/alter/drop/truncate table, data types, create like, create select; insert, update, delete, insert select; operators and functions; searching (like, match against)
  • 3rd part - working with multiple tables
  • key, foreign key, unique, auto_increment column; joining tables - join (cross, inner, left outer, right outer), joining using where; nested select, temporary table; indexes - create/drop/show index, explain.
Literature
  • MySQL Reference Manual [online]. c1995-2005 [cit. 2005-02-16]. Anglicky. Dostupný na http://dev.mysql.com/doc/mysql/en/index.htm
  • SKLENÁK, Vilém. Data, informace, znalosti a Internet. Vyd. 1. Praha: C.H. Beck, 2001. xvii, 507. ISBN 8071794090. info
  • SQL Tutorial [online]. c1999-2005 [cit. 2005-02-16]. Anglicky. Dostupný na http://www.w3schools.com/sql/default.asp
  • TRUETT, Larry. SQL Reference and Example Site [online]. c1999-2004 [cit. 2005-02-19]. Anglicky. Dostupný na http://www.fluffycat.com/sql/
  • VÁCLAVOVIČ, Jiří. Abeceda SQL [online]. c2000 [cit. 2005-02-16]. Dostupný na http://reboot.cz/info/databaze/abeceda-sql-1-cast--uvod/articles.html?id=63
  • BERKA, Petr. Dobývání znalostí z databází. Petr Berka. Vyd. 1. Praha : Academia, c2003. 366 s. +, 1 CD-ROM. ISBN 8020010629.
  • MAKULOVÁ, Soňa. - KIMLIČKA, Štefan. Úvod do informačných technológií. 2, Databázové technológie a bázy dát : databázový systém CDS/ISIS. Bratislava : STIMUL-Centrum informatických a vzdelávacích služieb, 1993. ISBN 8085697084.
  • TSICHRITZIS, Dionysios C. - LOCHOWSKY, Frederick H. Databázové systémy. Praha : SNTL - Nakladatelství technické literatury, 1987. (Knižnice výpočetní techniky)
Assessment methods
Attendance of exercises is facultative, it is possible to pass the course by distant learning.
All students though have to personally go through a final practical test using computer. Lenght of test is 90 minutes, students will be allowed to use their own notes and any SQL manual. Any communication will be strongly prohibited.
Minimum of 80% of points will be required for receiving credit.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is also listed under the following terms Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014.
  • Enrolment Statistics (Spring 2009, recent)
  • Permalink: https://is.muni.cz/course/phil/spring2009/VIKMB04