Course detail

Microsoft Enterprise Solutions

FIT-IW4Acad. year: 2018/2019

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

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

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

All forms of teaching are optional. Exercises can be substituted in any other term (but we can not guarantee free space in the classroom - priority is given to enrolled students). If necessary, please contact the teacher or guarantor.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Basic literature

Not applicable.

Recommended reading

Andersson, Jonas, Nuno Mota, and Mike Pfeiffer. Microsoft Exchange Server 2016 PowerShell Cookbook - Fourth Edition. Birmingham: Packt Publishing, 2017.
Assaf, William, et al. SQL server 2017 administration inside out. Redmond, Washington: Microsoft Press, 2018.
Cunningham, Paul, and Brian Svidergol. Exam ref 70-345 : designing and deploying Microsoft Exchange Server 2016. Redmond, Washington: Microsoft Press, 2016.
Elfassy, David. Mastering microsoft exchange server 2016. Place of publication not identified: Wiley-Sybex, 2016.
Francis, Dishan. Mastering Active Directory : automate tasks by leveraging PowerShell for Active Directory Domain Services 2016. Birmingham, UK: Packt Publishing, 2017.
Isakov, Victor. Exam ref 70-764 administering a SQL database infrastructure.  Pearson Education, 2018.

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 hod., compulsory

Teacher / Lecturer

Ing. Radomír Kurečka
Ing. Štefan Pataky