Course details
Microsoft Enterprise Solutions
MW4 Acad. year 2006/2007 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.
Prerequisite knowledge and skills
Knowledge based on topics covered by courses MW1, MW2 and MW3.
Study literature
- William R.Stanek: Microsoft SQL Server 2005 Kapesní rádce administrátora. Computer press
Microsoft® SQL Server™ 2005: Database Essentials Step by Step. Solid Quality Learning, ISBN: 0-7356-2207-8 - Bud Ratliff, Jason Ballard: Microsoft® Internet Security and Acceleration (ISA) Server 2004 Administrator's Pocket Consultant. ISBN: 0-7356-2188-8
- MCSE Training Kit: Microsoft Internet Security and Acceleration Server 2000, Microsoft Corporation, ISBN 0-7356-1347-8
- MCSE Training Kit: Microsoft SQL Server 2000 System Administration, Microsoft Corporation, ISBN 0-7356-1247-1
- MCSE Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Microsoft Corporation, ISBN 0-7356-1248-X
- MCSE Training Kit: Microsoft Windows 2000 Advanced Server Clustering Services, Microsoft Corporation, ISBN 0-7356-1293-5
- Jim Mc Bee, Barry Gerber, Petr Šetka: Mistrovství v Microsoft Exchange Server 2003. ISBN: 80-251-0947-X
- Will Willis, Ian McLean: MCSA/MCSE Self-Paced Training Kit (Exam 70-284): Implementing and Managing Microsoft® Exchange Server 2003. ISBN: 0-7356-1899-2
Fundamental literature
- Windows 2000 Advanced Server Help, http://www.microsoft.com/windows2000/techinfo/proddoc/advserverhelp.asp
- Windows 2000 Server Resource Kit, <a href=\"http://www.microsoft.com/windows2000/techinfo/reskit/en-us/default.asp\">http://www.microsoft.com/windows2000/techinfo/reskit/en-us/default.asp.
- Dokumentace k ISA Serveru, <a href=\"http://www.microsoft.com/isaserver/techinfo/productdoc/default.asp\">http://www.microsoft.com/isaserver/techinfo/productdoc/default.asp
- SQL Server 2000 Books Online, <a href=\"http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp\">http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
- Microsoft SQL Server Books Online from MSDN, <a href=\"http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/getstart_4fht.asp\">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/getstart_4fht.asp
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.