Course detail

Database server administration

FP-ADSEAcad. year: 2019/2020

The course is an introduction to architecture, plugin installation and administration of SQL Server.

Learning outcomes of the course unit

Learning outcomes - general competencies:
Skills associated with the administration of SQL Server
The ability to plan, install and manage SQL Server
Industry-specific competencies:
Students will understand the architecture of SQL Server will gain knowledge of data backup and recovery, the ability to manage security, manage, configure, and create database roles, configure and assign permissions to manage the SQL Server 2012 Agent and jobs, maintenance of databases.


Basic knowledge of Microsoft Windows operating systems, the ability to understand and work with T-SQL, knowledge of database structures eventually proposal


Not applicable.

Recommended optional programme components

Not applicable.

Recommended or required reading

Lacko, L.: Jak vyzrát na SQL Server - správa, konfigurace a programování. CPRESS. 2009. ISBN 978-80-251-2101-6 (CS)

Planned learning activities and teaching methods

The course consists of lectures, which consist of an explanation of basic principles and methodologies of the discipline problems. Exercise encourage in particular practical mastery of the subject matter presented in lectures.

Assesment methods and criteria linked to learning outcomes

Terms graded credit:
During the semester the student must obtain at least 50% of the possible maximum points, ie 20 points out of 40th
If undetected plagiarism or unauthorized collaboration on projects, or at the mid-term exam, students are not given the option to launch disciplinary proceedings.
Mid-term test - development of a practical task according to the assignment. There is no retake. (20 points)
Project development - one project according to the assignment of appropriate documentation. By entering students are introduced to another lecture. (20 points)
The final practical test (60 points for the written part, for the successful completion of the written part must develop so that was evaluated at least 30 points, otherwise the exam 0 points evaluation F.). Oral examination.

Language of instruction


Work placements

Not applicable.

Course curriculum

Describe the architecture of the database system SQL Server 2012
To plan, install and configure SQL Server 2012
Backup and restore databases
Import and export data, their relationship to the SSIS service
manage security
Manage, configure and create a database role
Configure and assign permissions
Manage the SQL Server 2012 Agent Job
maintenance of databases
Solve the most common problems


The aim is to acquire knowledge and skills for managing SQL Server.

Specification of controlled education, way of implementation and compensation for absences

Attendance at lectures is not compulsory. Computer-aided exercises are compulsory, attendance is monitored. One of absence from seminars, teacher apologize. Student replace this lack of elaboration specifically assigned homework.

During the semester, written semester test for a maximum of 20 points. For this semester test, there is no retake. If a student is properly documented and teacher excused absence just in lessons, where he writes a midterm exam, you may report it to the alternative.

In the second lecture is given to students separate project for a maximum of 20 points. So this project was recognized for his student must obtain a minimum. 10 points. Student submits a project in the credit week.
Students who have Individual Study Plan, ie. They do not go into teaching for the credit must develop and submit a separate stand-alone project. For this particular project can get max. 30 points.

Classification of course in study plans

  • Programme BAK-MIn Bachelor's

    branch BAK-MIn , 3. year of study, winter semester, 4 credits, compulsory-optional

Type of course unit



26 hours, optionally

Teacher / Lecturer


13 hours, compulsory

Teacher / Lecturer