Subjects

Your browser does not support JavaScript, or its support is disabled. Some features may not be available.

Microsoft SQL Server Administration - NDBI039

Title:	Administrace Microsoft SQL serveru
Guaranteed by:	Department of Software Engineering (32-KSI)
Faculty:	Faculty of Mathematics and Physics
Actual:	from 2021
Semester:	summer
E-Credits:	2
Hours per week, examination:	summer s.:0/2, C [HT]
Capacity:	unlimited
Min. number of students:	unlimited
4EU+:	no
Virtual mobility / capacity:	no
State of the course:	cancelled
Language:	Czech
Teaching methods:	full-time
Teaching methods:	full-time
Note:	enabled for web enrollment

Guarantor:	doc. RNDr. David Hoksza, Ph.D.
Class:	Informatika Bc.
Classification:	Informatics > Database Systems
Pre-requisite :	NDBI025

Opinion survey results Examination dates Schedule Noticeboard

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