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

    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

    Exchange Server 2010 TechNet Library http://technet.microsoft.com/en-us/library/bb124558(v=exchg.141).aspx Exchange Server 2013 TechNet Library http://technet.microsoft.com/en-us/library/bb124558(v=exchg.150).aspx SQL Server 2012 Product Documentation http://technet.microsoft.com/en-us/library/bb418440(v=sql.10).aspxWindows Server 2008 R2 TechNet Library http://technet.microsoft.com/en-us/library/dd349801 Windows Server 2012 Technical Library http://technet.microsoft.com/en-us/library/hh801901.aspx

    Recommended reading

    Microsoft Learning - Exchange Server https://www.microsoft.com/learning/en/us/exchange-server-certification.aspx Orin Thomas and Ian McLean: MCTS Self-Paced Training Kit (Exam 70-662): Configuring Microsoft Exchange Server 2010: Configuring Microsoft Exchange Server 2010 (Pro - Certification), ISBN: 9780735627161Microsoft Learning - MS SQL Server http://www.microsoft.com/learning/en/us/sql-certification.aspxMike Hotek: MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance, ISBN: 9780735626058Itzik Ben-Gan et al.: Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012, ISBN: 9780735666054Windows Server 2008 R2 TechNet Library http://technet.microsoft.com/en-us/library/dd349801 Windows Server 2012 Technical Library http://technet.microsoft.com/en-us/library/hh801901.aspxWilliam R. Stanek: Microsoft SQL Server 2012 Pocket Consultant, ISBN: 978 0735663763William R. Stanek: Mistrovství v Microsoft Windows Server 2008, ISBN: 9788025121580William R. Stanek: Windows Server 2012 Pocket Consultant, ISBN: 9780735666337William R. Stanek: Windows Server 2012 Inside Out, ISBN: 9780735666313

    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., optionally

    Teacher / Lecturer

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