Course detail

Microsoft Enterprise Solutions

FIT-IW4Acad. year: 2013/2014

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

Ing. Radomír Kurečka

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

The course uses teaching methods in form of Computer exercise - 4 teaching hours per week.

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

    Syllabus of lectures:

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 literature

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 , 3 year of study, summer semester, elective

Type of course unit

 

Exercise in computer lab

52 hod., optionally

Teacher / Lecturer

Ing. Radomír Kurečka