VIKMB04 Introduction to Structured Query Language

Faculty of Arts
Spring 2010
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 – Faculty of Arts
Contact Person: Mgr. Iva Dušová
Timetable
Mon 10:00–11:35 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 / plans the course is directly associated with
there are 6 fields of study the course is directly associated with, display
Course objectives
At the end of the course students will:
have basic knowledge of a SQL database language (Structured Query Language);
be able to use 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. xvii, 507. ISBN 8071794090. 2001. 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)
Teaching methods
Attendance of exercises is facultative, it is possible to pass the course by distant learning.
Computer exercises using web based environment for sample databese interaction will be aimed at solution of practical tasks by construction SQL queries.
Assessment methods
All students 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
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2011, Spring 2012, Spring 2013, Spring 2014.
  • Enrolment Statistics (Spring 2010, recent)
  • Permalink: https://is.muni.cz/course/phil/spring2010/VIKMB04