Database Administration

Објавено: October 23, 2019
  1.    Course Title Database Administration
  2.    Code 3ФЕИТ07Л001
  3.    Study program KTI
  4.    Organizer of the study program (unit, institute, department) Faculty of Electrical Engineering and Information Technologies
  5.    Degree (first, second, third cycle) First cycle
  6.    Academic year/semester III/6   7.    Number of ECTS credits 6.00
  8.    Lecturer Dr Goran Jakimovski
  9.    Course Prerequisites Passed: Data modeling and database systems

10.    Course Goals (acquired competencies):  Management of existing databases. Indexing and fast access to data. Upon completion, students can perform administrative tasks in the database domain.

11.    Course Syllabus: Introduction to SQL Servers. Basic tools and work environment. Creating and managing databases. Upgrading and migrating databases. Dealing with errors in SQL Server and introducing security aspects. Defining access and roles. Adding new roles and constraints. Defining access levels and permissions. Backup and restore. Configuring SQL agents. Defining routine tasks and stored procedures. Working with saved procedures and indexing. Querying indexed databases. Dealing with fragmented databases and errors. Management of databases and error alerting.
12.    Learning methods:  Lectures, auditory and laboratory exercises
13.    Total number of course hours 2 + 2 + 1 + 0
14.    Distribution of course hours 180
15.    Forms of teaching 15.1. Lectures-theoretical teaching 30
15.2. Exercises (laboratory, practice classes), seminars, teamwork 45
16.    Other course activities 16.1. Projects, seminar papers 25
16.2. Individual tasks 20
16.3. Homework and self-learning 60
17.    Grading 17.1. Exams 10
17.2. Seminar work/project (presentation: written and oral) 10
17.3. Activity and participation 0
17.4. Final exam 60
18.    Grading criteria (points) up to 50 points     5 (five) (F)
from 51 to 60 points     6 (six) (E)
from 61 to 70 points     7 (seven) (D)
from 71 to 80 points     8 (eight) (C)
from 81 to 90 points     9 (nine) (B)
from 91 to 100 points   10 (ten) (A)
19.    Conditions for acquiring teacher’s signature and for taking final exam Laboratory exercises
20.    Language Macedonian and English
21.    Method of monitoring of teaching quality Internal evaluation and questionnaires
22.    Literature
22.1. Required Literature
No. Author Title Publisher Year
1 Microsoft official academic course MTA Database Administration Fundamentals John Wiley & Sons 2011
2 Craig Mullins Database Administration: The Complete Guide to Practices and Procedures Addison-Welsey 2002
3 Steve Fogel Oracle Database Administrator’s Guide Oracle 2015