Course detail

Microsoft Enterprise Solutions

FIT-IW4Acad. year: 2017/2018

SQL Server: Management, advanced T-SQL queries, work with geographical and hierarchical data, Business Inteligence. Exchange Server: installation, configuration, relation with Active Directory and other server systems, management, backup, maintenance, troubleshooting, clustering, load-balancing.

Language of instruction

Czech

Number of ECTS credits

5

Mode of study

Not applicable.

Guarantor

prof. Ing. Jan M. Honzík, CSc.

Department

Department of Information Systems (UIFS)

Learning outcomes of the course unit

Ability to implement, manage, troubleshoot, design and deploy enterprise technologies MS Exchange and MS SQL Server

General understanding of database systems, electronic communication and troubleshooting of performance and network issues.

Prerequisites

Graduation of courses IW1 and IW2.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Not applicable.

Assesment methods and criteria linked to learning outcomes

Study evaluation is based on marks obtained for specified items. Minimimum number of marks to pass is 50.

No requirements.

Course curriculum

Not applicable.

Work placements

Not applicable.

Aims

To obtain detailed knowledge about installation, maintanance, implementation and design of enterprise systems based on Microsoft Windows and other server products.

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

No requirements.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Basic literature


Recommended reading


Classification of course in study plans

  • Programme IT-BC-3 Bachelor's

    branch BIT , 2. year of study, summer semester, elective

Type of course unit

 

Exercise in computer lab

52 hours, optionally

Teacher / Lecturer

prof. Ing. Jan M. Honzík, CSc.