Microsoft Enterprise Solutions

• 52 hrs pc labs

Ability to deploy, implement, maintain and plan Microsoft enterprise systems

General insight into problems of computer networks and their implementation.

To obtain detailed knowledge about installation, maintanance, implementation and design of enterprise systems based on Microsoft Windows and other server products.

• Microsoft Windows Desktop Systems (IW1)
• Microsoft Windows Server Systems (IW2)
• Microsoft Windows Network Technologies (IW3)

Graduation of courses IW1 and IW2.

• 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

• 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

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

Study evaluation is based on marks obtained for specified items. Minimimum number of marks to pass is 50.

No requirements.

No requirements.