SubjectsSubjects(version: 811)
Course, academic year 2017/2018
  
Database Systems - N445003
Czech title: Databázové systémy
Guaranteed by: Department of Computing and Control Engineering (445)
Actual: from 2017
Semester: winter
Points: winter s.:5
E-Credits: winter s.:5
Examination process: winter s.:
Hours per week, examination: winter s.:1/3 C+Ex [hours/week]
Capacity: 30 / 30 (unknown)
Min. number of students: unlimited
Language: Czech
Teaching methods: full-time
Level:  
For type:  
Additional information: http://moodle.vscht.cz/course/view.php?id=4
Note: předmět je možno zapsat mimo plán
povolen pro zápis po webu
Guarantor: Kukal Jaromír doc. Ing. Ph.D.
Annotation -
Last update: Vovsík Jaroslav Ing. Ph.D. (03.07.2013)

The course is focused on gaining practical knowledge of work with modern client-server relational database systems using SQL query language. It also provides theoretical foundations for conceptual modelling, normalization of relational data model including integrity constraints, data security in terms of data access and data loss and for database application development.
Aim of the course -
Last update: Vovsík Jaroslav Ing. Ph.D. (03.07.2013)

Students will be able to:

  • work with a modern client-server relational database system,
  • work with different types of database clients,
  • create and modify simple database schemas using SQL statements,
  • insert, modify, delete, and retrieve data using SQL statements.

Literature -
Last update: Vovsík Jaroslav Ing. Ph.D. (02.07.2013)

R:MySQL 5.1 Reference Manual,MySQL AB,Sun Microsystems,2009.

R:Ponniah P.,Database Design and Development: an Essential Guide for IT Professionals,Wiley-Interscience,Hoboken,NJ,2003,0471218774.

A:Wilton P. and Colby J.W.,Beginning SQL,Wrox-Wiley,Indianapolis,Indiana,2005,0764577328.

A:Kriegel A. and Trukhnov B.M.,SQL Bible,Wiley,Hoboken,NJ,2008,0470229063.

Learning resources -
Last update: Vovsík Jaroslav Ing. Ph.D. (03.07.2013)

http://moodle.vscht.cz/course/view.php?id=4

http://dx.doi.org/10.1002/0471728993

http://dev.mysql.com/doc/

Syllabus -
Last update: Vovsík Jaroslav Ing. Ph.D. (03.07.2013)

  1. Modern database systems and database management systems. Basic database system concepts.
  2. Basic database operations, projection, filtration, joining of tables, set operations.
  3. SQL query language. Basic SQL commands. SELECT command.
  4. Simple queries creation. Filter conditions. Logical operators, regular expressions, predicates. Usage of subqueries.
  5. Data types and working with them. Usage of built-in functions.
  6. Row grouping, aggregate calculations. Joining of tables, combining results.
  7. Techniques of query creation. Pivot tables, lists, sequences, running and sliding averages.
  8. SQL commands for creation, modification, and removal of tables. SQL commands for addition, update, and removal of rows.
  9. Methods of logical organisation of data. Conceptual modelling.
  10. Relational data model. Data normalisation basics. Keys and their types.
  11. Normalisation of relational data model. Data integrity and its types. Access rights.
  12. Database system architecture. Data security and its safeguarding.
  13. Transactions and their properties. States of transactions. Recovery from failures.
  14. Database application life cycle. Planning, feasibility study, design, implementation, tests, deployment, maintenance and growth of database applications.

Entry requirements - Czech
Last update: Vovsík Jaroslav Ing. Ph.D. (19.11.2012)

Uživatelská znalost operačního systému Microsoft Windows a práce v síťovém prostředí, kterou lze získat absolvováním předmětu Aplikace výpočetní techniky - N445001.

Registration requirements -
Last update: Vovsík Jaroslav Ing. Ph.D. (03.07.2013)

Applications of Computer Science - N445001

Class methods
Activity Credits Hours
Účast na přednáškách 0,5 14
Práce na individuálním projektu 1,5 42
Příprava na zkoušku a její absolvování 1,5 42
Účast na seminářích 1,5 42
5 / 5 140 / 140
Evaluation of a student
Form Balance
Protokoly z individuálních projektů 20
Zkouškový test 80

 
VŠCHT Praha