Objectives and competences
The intended goals of the student are:
1. to understand the methodology and technology of information system development with program units in the database
2. to understand the connection between the front-end and back-end
3.to understand processing in the back-end
4.to create complex queries across multiple SQL tables
5. to develop program units in the back-end
6. to connect back-end units with the front-end program units
7. to test complex applications
8. to develop the ability to communicate with other experts in ICT
Competences
1. ability to create / change program units for back-end
2. ability to connect and document back-end program units
Content (Syllabus outline)
1. An overview of procedural languages for contemporary relational databases
2. Limitations of SQL
3. Procedural constructs: variables, constants, cursors, conditional logic, exceptions and iteration
4. Transaction control
5. Program structure
6. Procedures, functions and parameters
7. Packages
8. Advanced triggers
9. Application Security and program units
10. Object-Oriented Aspects
11. Application of program units in other program languages
12. Application of program units in Oracle Application Express
Learning and teaching methods
• lectures and assignments
• lab practice with computer
• research and development project
• presentation of research and development project
Intended learning outcomes - knowledge and understanding
Knowledge and understanding of:
At the end of the course, the students will be able to:
• create, test and document software units in the database
• create and control transactions triggered by software units in the database
• use tools for the development of back-end software units
• connect back-end software units with front-end
Readings
1. Morris B. S. (2023). Resilient Oracle PL/SQL: Building Resilient Database Solutions for Operation. (305 str.). O'Reilly Media.
Prerequisits
- Basic BSc degree knowledge of SQL
Additional information on implementation and assessment written exam (60%)
research paper (40%)
Note:
Criteria for passing the exam:
submitted, presented and approved research paper
