Course: Programming Database Applications

« Back
Course title Programming Database Applications
Course code KST/NNPDA
Organizational form of instruction Lecture + Tutorial
Level of course Master
Year of study 2
Semester Winter
Number of ECTS credits 4
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Fikejz Jan, Ing. Ph.D.
Course content
Lecture program: 1. Basic DB connections (Java Database Connectivity JDBC) 2. REST web services, 3. SOAP web services 4. Elasticsearch 5. Kibana 6. Database synchronization using Logstash 7. Using Hibernate 8. Java Persisten API (JPA) 9. Spring/Spring Boot 10. Application servers 11. Full-text databases - Elasticsearch 12. Application virtualization using Docker 13. Oracle Spatial extensions - MapBilder and MapViewer Exercise program: 1. Assignment of semester work A, analysis of implementation options. 2. Development of the concept of semester work A using UML, independent work of students on the implementation of semester work A. 3. Continuous individual control of partial iterations of the development of semester work A. 4. Continuous individual control of partial iterations of the development of semester work A. 5. Assignment of semester work B, analysis of implementation options, individual defense of semester work A. 6. Development of the concept of semester work B using UML, independent work of students on the implementation of semester work B, individual defense of semester work A. 7. Continuous individual control of partial iterations of the development of semester work B. 8. Continuous individual control of partial iterations of the development of semester work B. 9. Assignment of semester work C, analysis of implementation options, individual defense of semester work B. 10. Development of the concept of semester work C using UML, independent work of students on the implementation of semester work B. thesis C, individual defenses of semester thesis B. 11. Continuous individual control of partial iteration of development of semester thesis C. 12. Potential assignment of optional semester thesis D, analysis of implementation options, individual defenses of semester thesis C. 13. Individual defenses of semester thesis C and potentially also D.

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Skills training
  • Contact teaching - 52 hours per semester
  • Home preparation for classes - 20 hours per semester
  • Term paper - 45 hours per semester
  • Preparation for an exam - 30 hours per semester
Learning outcomes
The main goal of the course is to familiarize students with with programming techniques of database application in Java language with utilization of selected frameworks and application servers.
Passing the course enables to use selected frameworks and application servers in practice.
Prerequisites
There is expected fundamental knowledge of advanced programming techniques, data structures and database systems.

Assessment methods and criteria
Written examination, Home assignment evaluation

The condition for granting credit is the successful processing of semester papers (implementation of software applications using selected frameworks and application servers). The student receives the appropriate points for processing each semester paper. The minimum number of points to receive credit is 80b/100b. The maximum point rating of individual semester papers and the deadlines for their latest possible submission in the semester are stated in the materials for the 1st lecture. The subject exam is written, where the student answers approximately 13-15 questions and each question has its own points. To successfully pass the exam, it is necessary to answer at least 60% of the questions correctly.
Recommended literature
  • Albert Godfrind, Richard Pitts, Hans Viehmann, Ravikanth Kothuri. Pro Oracle Spatial for Oracle Database 12c. Apress, 2017. ISBN 143026313X.
  • Keith Mike. Pro JPA 2. APress, 2010. ISBN 9781430219569.
  • Paul Fisher. Spring Persistence with Hibernate. Berlin: Springer, 2016. ISBN 1484202694.
  • Sanjay Patni. Pro RESTful APIs. Apress, 2017. ISBN 9781484226643.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester