Course details
Microsoft Enterprise Solutions
IW4 Acad. year 2017/2018 Summer semester 5 credits
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.
Guarantor
Language of instruction
Completion
Time span
- 52 hrs pc labs
Assessment points
- 100 pts final exam
Department
Subject specific learning outcomes and competences
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.
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
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