Study programmes / B-SE System engineering and informatics / Application Software Programmes
Course code:APV
Course title in language of instruction:Aplikační programové vybavení
Course title in Czech:Aplikační programové vybavení
Course title in English:Application Software Programmes
Mode of completion and number of credits:Exam (5 credits)
(1 ECTS credit = 28 hours of workload)
Mode of delivery/Timetabled classes:full-time, 2/2
(full-time, hours of lectures per week / hours of seminars per week)
Language of instruction:Czech
Level of course:bachelor
Semester:WS 2019/2020 - FBE
Name of lecturer:Ing. Jiří Lýsek, Ph.D. (supervisor)
Prerequisites:Computer Technology II or now Computer Technology II
 
Aims of the course:The aim of the course is to teach student basic categories of application software. Emphasis is given on development of web applications and relational database systems. Furthermore related technologies such as basics of network services, application protocols, application frameworks, UI frameworks are included.
Course contents:
1.Introduction to relational database systems (allowance 12/10)
 
a.Data models, basic concepts, entity-relationship diagram
b.SQL language -- data manipulation
c.Relations between tables, aggregation queries

2.Web applications (allowance 10/12)
 
a.Introduction to HTML language, web standards, HTTP protocol
b.PHP Framework, Composer, using routes
c.Forms, dynamic documents, parameters passing
d.Stateful application, working with database system

3.Cascading style sheets (allowance 6/6)
 
a.Introduction to object properties, selectors and document formating
b.Bootstrap framework, responsive design
c.Creating UI using CSS, page layout

Learning outcomes and competences:
Generic competences:
 
-ability to apply knowledge
-ability to create new ideas (creativity)
-ability to solve problems
-capacity to learn
-professional knowledge

Specific competences:
 
-Student is able to describe and explain common SQL queries and their parts and understand the logic of SQL queries.
-Student is able to describe basic principles and definitions of relational database systems.
-Student is able to describe basic principles of web applications, particularly the creation and processing of a HTTP request.
-Student is able to implement a functional application based on a given logical database schema.
-Student is able to implement a web application including the user interface given a graphic design.

Type of course unit:required
Year of study:Not applicable - the subject could be chosen at anytime during the course of the programme.
Work placement:There is no compulsory work placement in the course unit.
Recommended study modules:none
Assessment methods:Monitoring and evaluation of the project, the final test in the eLearning environment UIS in the areas of ​​SQL, database systems, web applications, HTML and cascading style sheets. It is necessary to obtain at least 50 % of points (i.e. min. 38 of 76 points) of the test. Is is necessary to gain at least 50 % points from the project.

The final grade is the mean between percentual rating of the exam test and the project (from 90 % grade A, from 80 % grade B, from 70 % grade C, from 60 % grade D, from 50 % grade E).

The class cannot be studied during foreign study stay.
 
Learning activities and study load (hours of study load)
Type of teaching methodDaily attendance
Direct teaching
     lecture28 h
     practice28 h
Self-study
     preparation for exam36 h
     preparation for regular assessment18 h
     elaboration and execution of projects30 h
Total140 h

Basic reading list
  • CASTRO, E. -- HYSLOP, B. HTML5 a CSS3: názorný průvodce tvorbou WWW stránek. Brno: Computer Press, 2012. 440 p.
  • Naučte se SQL za 21 dní: pochopte principy jazyka relačních databází, uplatněte získané dovednosti při tvorbě dotazů a databázových aplikací. 1st ed. Brno: Computer Press, 2004. 581 p. ISBN 80-7226-870-8.
  • HOGAN, B P. HTML5 a CSS3: výukový kurz webového vývojáře. 1st ed. Brno: Computer Press, 2011. 272 p. ISBN 978-80-251-3576-1.
  • WILTON, P. -- COLBY, J W. Beginning SQL. Wrox, 2011. 519 p. ISBN 978-0-764-57732-1.
  • CAMERON, D. A Software Engineer Learns HTML5, JavaScript and jQuery: A guide to standards-based web applications. U.S.: Cisdal Publishing, 2013. 256 p.
Recommended reading list
  • GROFF, J R. -- WEINBERG, P N. et al. SQL: kompletní průvodce. 1st ed. Brno: CP Books, 2005. 936 p. Programování. ISBN 80-251-0369-2.