Academy of Technical and
Art Applied Studies Belgrade

Database Programming Course code: M62042 | 6 ECTS credits

Basic information
Level of Studies: Undergraduate applied studies
Year of Study: 1
Semester: 1
Requirements:
Goal: Becoming familiar with the limits of SQL language and the importance of working on database functionalities. Introducing students to the elements of a procedural language which is used for expansion of SQL capabilities, such as variables, conditional clauses, loops, etc, using PL/SQL language. Becoming familiar with PL/SQL components while using and creating procedures, functions, triggers.
Outcome: Students are trained to create components written in a procedural language, such as procedures, functions, triggers, etc.
Contents of the course
Theoretical instruction:
  1. Basics
  2. Defining variables and data types
  3. Using SQL in PL/SQL
  4. Cursors and parameters
  5. Using procedures, functions and packages
  6. Exceptions
  7. Triggers
Practical instruction (Problem solving sessions/Lab work/Practical training):
  1. Students are trained to create PL/SQL components in Orcale Apex, which is used during theoretical classes.
Textbooks and References
  1. Oracle 10g – PL / SQL Programming Scott Urman, Ron Hardman, Michael McLaughlin, Mikroknjiga
  2. Oracle PL/SQL by Example, Benjamin Rosenzweig, Elena Silvestrova
  3. Oracle Academy Curriculum, Oracle Database Programming with PL/SQL, 2011.
Number of active classes (weekly)
Lectures: 4
Practical classes: 1
Other types of classes: 1
Grading (maximum number of points: 100)
Pre-exam obligations
Points
activities during lectures
5
activities on practial excersises
20
seminary work
10
colloquium
20
Final exam
Points
Written exam
45
Oral exam
0