SubjectsSubjects(version: 837)
Course, academic year 2018/2019
   Login via CAS
Microsoft SQL Server Administration - NDBI039
Title in English: Administrace Microsoft SQL serveru
Guaranteed by: Department of Software Engineering (32-KSI)
Faculty: Faculty of Mathematics and Physics
Actual: from 2017
Semester: summer
E-Credits: 2
Hours per week, examination: summer s.:0/2 C [hours/week]
Capacity: unlimited
Min. number of students: unlimited
State of the course: not taught
Language: Czech
Teaching methods: full-time
Note: enabled for web enrollment
Guarantor: RNDr. David Hoksza, Ph.D.
Class: Informatika Bc.
Classification: Informatics > Database Systems
Pre-requisite : NDBI025
Annotation -
Last update: T_KSI (04.05.2015)
The lecture will provide students with the knowledge of installation, configuration, maintenance and optimization of Microsoft SQL Server. Students will learn specific features of SQL Server including practical administration (installation, configuration, backup) and programming support (CLR integration, optimization, debugging, performance monitoring, transaction support). The knowledge in scope of lecture NDBI026 - Database Applications is supposed!
Literature - Czech
Last update: T_KSI (28.02.2011)
  • Sack, J., “SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach”. Apress, 2008, ISBN 978-1590599808
  • Knight, B., Patel, K., Snyder, W., LoForte, R., Wort S., “Professional Microsoft SQL Server 2008 Administration”, Wrox, 2008, ISBN 978-0470247969
  • Walters, R.E., Coles, M., Rae, R., Ferracchiati, R. Farme, D., “Mistrovství v Microsoft SQL Server 2008”. Computer Press, 2009, ISBN 978-80-251-2329-4
  • Delaney, K., Randal, P. S., Tripp, K. L., Cunningham, C., Machanic, A., “Microsoft SQL Server 2008 Internals“, Microsoft Press, 2009, ISBN 978-0735626249

Syllabus -
Last update: T_KSI (28.02.2011)

1. MS SQL Server architecture, DB configuration, development and administration tools

2. Security - users, permissions, roles

3. Backup and recovery

4. Performance - SQL Server Profiler, index types, statistics

5. Transactions management - transaction types, locks, blocking

6. CLR integration

7. Spatial and XML data support

8. Monitoring and automation

Charles University | Information system of Charles University |