Course detail

Microsoft Enterprise Solutions

FIT-IW4Acad. year: 2009/2010

Exchange Server. ISA Server. Software Management Server. Microsoft Operations Manager.

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 deploy, implement, maintain and plan Microsoft enterprise systems

General insight into problems of computer networks and their implementation.

Prerequisites

Knowledge based on topics covered by courses IW1/MW1, IW2/MW2 and IW3/MW3.

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

  1. MS SQL - T-SQL: allowed names, SELECT, UNION, Compute By, LIKE, COALESCE, NULL value, CASE
  2. MS SQL - INSERT, UPDATE, DELETE, TRUNCATE, DROP; CREATE, BACKUP, RESTORE, GROUP BY, subquery
  3. MS SQL - T-SQL: INFORMATION_SCHEMA, Funkctions (skalar, static, inline), stored procedures, triggers
  4. MS Exchange - introduction, instalation, kompatibility with previous versions
  5. MS Exchange - servers model, public folders
  6. MS Exchange - recipients, protocols
  7. MS Exchange - trouble-shooting, maintaining, tools
  8. MS Exchange - Advanced functions MS Outlook 2003, OWA
  9. MS ISA - firewall
  10. MS ISA - web caching
  11. MS ISA - VPN server
  12. MS ISA - security, tools
  13. MS ISA - trouble-shooting

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

Type of course unit

 

Exercise in computer lab

52 hours, optionally

Teacher / Lecturer

Ing. Radomír Kurečka