Title:

Microsoft Enterprise Solutions

Code:IW4
Ac.Year:2010/2011
Term:Summer
Curriculums:
ProgrammeBranchYearDuty
IT-BC-3BIT3rdElective
Language:Czech
Public info:http://www.fit.vutbr.cz/study/courses/IW4/public/
Private info:http://www.fit.vutbr.cz/study/courses/IW4/private/
Credits:5
Completion:examination
Type of
instruction:
Hour/semLecturesSem. ExercisesLab. exercisesComp. exercisesOther
Hours:000520
 ExaminationTestsExercisesLaboratoriesOther
Points:1000000
Guarantee:Kurečka Radomír, Ing., DIFS
Lecturer:Ruttkay Ladislav, Ing., DIFS
Faculty:Faculty of Information Technology BUT
Department:Department of Information Systems FIT BUT
Prerequisites: 
Microsoft Windows Desktop Systems (IW1), DIFS
Microsoft Windows Network Technologies (IW3), DIFS
Microsoft Windows Server Systems (IW2), DIFS
Follow-ups:
Programming .NET and C# (IW5), DIFS
 
Learning objectives:
  To obtain detailed knowledge about installation, maintanance, implementation and design of enterprise systems based on Microsoft Windows and other server products.
Description:
  Exchange Server. ISA Server. Software Management Server. Microsoft Operations Manager.
Knowledge and skills required for the course:
  Graduation of courses IW1 and IW2.
Subject specific learning outcomes and competences:
  Ability to deploy, implement, maintain and plan Microsoft enterprise systems
Generic learning outcomes and competences:
  General insight into problems of computer networks and their implementation.
Syllabus of lectures:
 
  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
Fundamental literature:
 
  1. Windows 2000 Advanced Server Help, http://www.microsoft.com/windows2000/techinfo/proddoc/advserverhelp.asp
  2. Windows 2000 Server Resource Kit, http://www.microsoft.com/windows2000/techinfo/reskit/en-us/default.asp.
  3. Dokumentation to ISA Server, http://www.microsoft.com/isaserver/techinfo/productdoc/default.asp
  4. SQL Server 2000 Books Online, http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
  5. Microsoft SQL Server Books Online from MSDN, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/getstart_4fht.asp
  6. Windows 2008 Server - http://www.microsoft.com/windowsserver2008/en/us/default.aspx
Study literature:
 
  • 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
  • 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
Controlled instruction:
  No requirements.
Exam prerequisites:
  No requirements.