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. Oracle Academy (2022). Database Programming with PL/SQL. https://myacademy.oracle.com.
2. M. Vaidya (2021). Mastering SQL and PL/SQL Concepts, Database design, ACID Transactions, and Practice Real Implementation of RDBMS. BPB Publications, 2021.
3. Gradiva izvajalcev
Priporočljiva:
S. Feuerstein, B. Pribyl (2014). Oracle PL/SQL Programming, 6th Edition. ISBN: 9781449324452. O'Reilly Media, Inc.
Prerequisits
- Basic BSc degree knowledge of SQL
Additional information on implementation and assessment written examination (60 %)
research assignment (40 %)
Criteria for passing the exam:
submitted, presented and approved research report