Course details

Microsoft Enterprise Solutions

IW4 Acad. year 2010/2011 Summer semester 5 credits

Current academic year

Exchange Server. ISA Server. Software Management Server. Microsoft Operations Manager.

Guarantor

Kurečka Radomír, Ing. (DIFS FIT BUT)

Language of instruction

Czech

Completion

Examination

Time span

52 hrs pc labs

Assessment points

100 exam

Department

Lecturer

Ruttkay Ladislav, Ing. (DIFS FIT BUT)

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.

Learning objectives

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

Prerequisite kwnowledge and skills

Graduation of courses IW1 and IW2.

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

Fundamental literature

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

Controlled instruction

No requirements.

Exam prerequisites

No requirements.

Course inclusion in study plans

  • Programme IT-BC-3, field BIT, 3rd year of study, Elective
Back to top