Database server administration
FP-MadseKAcad. 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
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
- compulsory co-requisite
Recommended optional programme components
Recommended or required reading
HOTEK, M. SQL Server 2008, krok za krokem. Brno, Computer Press, 2009, 488 s. ISBN 978-80-251-2466-6.
LACKO, L. Microsoft SQL Server 2008, správa,konfigurace, programování. Brno, Computer Press 2009, 469 s., ISBN 978-80-251-2101-6
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
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, 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.