Database Administration

Course title: Database Administration

Code: 3ФЕИТ07Л001

Number of credits (ECTS): 6

Weekly number of classes: 2+2+1+0

Prerequisite for enrollment of the subject: Passed:Data Modeling and Database Systems

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.

Total available number of classes: 180

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.

Literature: