Course details
Microsoft Enterprise Solutions
IW4 Acad. year 2012/2013 Summer semester 5 credits
Exchange Server. ISA Server. Software Management Server. Microsoft Operations Manager.
Guarantor
Language of instruction
Completion
Time span
- 52 hrs pc labs
Department
Subject specific learning outcomes and competences
Ability to deploy, implement, maintain and plan Microsoft enterprise systems
General insight into problems of computer networks and their implementation.
Learning objectives
To obtain detailed knowledge about installation, maintanance, implementation and design of enterprise systems based on Microsoft Windows and other server products.
Recommended prerequisites
Prerequisite knowledge and skills
Graduation of courses IW1 and IW2.
Study 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: 9780735627161
- Microsoft Learning - MS SQL Server
http://www.microsoft.com/learning/en/us/sql-certification.aspx - Mike Hotek: MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance, ISBN: 9780735626058
- Itzik Ben-Gan et al.: Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012, ISBN: 9780735666054
- Windows 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
- William R. Stanek: Microsoft SQL Server 2012 Pocket Consultant, ISBN: 978 0735663763
- William R. Stanek: Mistrovství v Microsoft Windows Server 2008, ISBN: 9788025121580
- William R. Stanek: Windows Server 2012 Pocket Consultant, ISBN: 9780735666337
- William R. Stanek: Windows Server 2012 Inside Out, ISBN: 9780735666313
Fundamental 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).aspx - Windows 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
Syllabus of seminars
- MS SQL - T-SQL: allowed names, SELECT, UNION, Compute By, LIKE, COALESCE, NULL value, CASE
- MS SQL - INSERT, UPDATE, DELETE, TRUNCATE, DROP; CREATE, BACKUP, RESTORE, GROUP BY, subquery
- MS SQL - T-SQL: INFORMATION_SCHEMA, Funkctions (skalar, static, inline), stored procedures, triggers
- MS Exchange - introduction, instalation, kompatibility with previous versions
- MS Exchange - servers model, public folders
- MS Exchange - recipients, protocols
- MS Exchange - trouble-shooting, maintaining, tools
- MS Exchange - Advanced functions MS Outlook 2003, OWA
- MS ISA - firewall
- MS ISA - web caching
- MS ISA - VPN server
- MS ISA - security, tools
- MS ISA - trouble-shooting
Progress assessment
Study evaluation is based on marks obtained for specified items. Minimimum number of marks to pass is 50.
No requirements.
Controlled instruction
No requirements.
Course inclusion in study plans