SLO | EN

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

  • red. prof. dr. ROBERT LESKOVAR, univ. dipl. org.

  • Written examination: 60
  • Seminar paper: 40

  • : 36
  • : 24
  • : 150

  • Slovenian
  • Slovenian

  • ORGANIZATION AND MANAGEMENT OF INFORMATION SYSTEMS - 2nd