Academy of Technical and
Art Applied Studies Belgrade

Database Administration Course code: I62040I | 6 ECTS credits

Basic information
Level of Studies: Undergraduate applied studies
Year of Study:
Semester: 9
Requirements:
Goal: Introduction to the tasks and responsibilities of database administrators, the concepts that have an impact on the operation of a database, as well as the techniques to improve the performance of databases and applications that use databases. Understanding the tasks that protect and store data.
Outcome: Students should be able to explain the operation of a database management system; to use knowledge to perform tasks that improve the performance of databases and applications that use databases, and the tasks that store and protect the data contained in databases; to analyze data storage options and select the most optimal ones.
Contents of the course
Theoretical instruction:
  1. Data modeling and normalization
  2. Database design
  3. Application design
  4. Database change management
  5. DDL statements
  6. Data availability
  7. Database security
  8. Data backup
  9. Data management and storage
Practical instruction (Problem solving sessions/Lab work/Practical training):
  1. Performance of specific administrative tasks on the example of MS SQL Server.
Textbooks and References
  1. Craig S.Mullins, Administracija baza podataka, Kompjuter biblioteka, 2003.
  2. Craig S. Mullins, Database Administration, The complete guide to DBA Practices and Procedures, Second Edition, Addison-Wesley Professional, 2012
Number of active classes (weekly)
Lectures: 4
Practical classes: 2
Other types of classes: 1
Grading (maximum number of points: 100)
Pre-exam obligations
Points
activities during lectures
5
activities on practial excersises
15
seminary work
0
colloquium
20
Final exam
Points
Written exam
60
Oral exam
0