Course detail

Microsoft Enterprise Solutions

FEKT-XMW4Acad. year: 2017/2018

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

Learning outcomes of the course unit

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

Prerequisites

BMW1, BMW2, BMW3

Co-requisites

Not applicable.

Recommended optional programme components

Not applicable.

Recommended or required reading

Windows 2000 Server Study Guide (Exam 70-215), Osborne McGraw-Hill, ISBN 0-07-212389-3
Windows 2000 Advanced Server Help, http://www.microsoft.com/windows2000/techinfo/proddoc/advserverhelp.asp
MCSE Microsoft® Windows® 2000 Server Readiness Review; Exam 70-215, Ethan Wilansky, ISBN 0-7356-0948-9
Windows 2000 Server Resource Kit, http://www.microsoft.com/windows2000/techinfo/reskit/en-us/default.asp.
Dokumentace k ISA Serveru, http://www.microsoft.com/isaserver/techinfo/productdoc/default.asp
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
SQL Server 2000 Books Online, http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Microsoft SQL Server Books Online from MSDN, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/getstart_4fht.asp
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

Planned learning activities and teaching methods

Teaching methods depend on the type of course unit as specified in the article 7 of BUT Rules for Studies and Examinations.

Assesment methods and criteria linked to learning outcomes

Requirements for completion of a course are specified by a regulation issued by the lecturer responsible for the course and updated for every year.

Language of instruction

Czech

Work placements

Not applicable.

Course curriculum

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

Aims

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

Classification of course in study plans

  • Programme IBEP-T Bachelor's

    branch T-IBP , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-BK Bachelor's

    branch BK-AMT , 2. year of study, summer semester, 5 credits, general knowledge
    branch BK-EST , 2. year of study, summer semester, 5 credits, general knowledge
    branch BK-MET , 2. year of study, summer semester, 5 credits, general knowledge
    branch BK-SEE , 2. year of study, summer semester, 5 credits, general knowledge
    branch BK-TLI , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme IBEP-T Bachelor's

    branch T-IBP , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-B Bachelor's

    branch B-AMT , 3. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-BK Bachelor's

    branch BK-AMT , 3. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-B Bachelor's

    branch B-EST , 3. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-BK Bachelor's

    branch BK-EST , 3. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-B Bachelor's

    branch B-MET , 3. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-BK Bachelor's

    branch BK-MET , 3. year of study, summer semester, 5 credits, general knowledge
    branch BK-SEE , 3. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-B Bachelor's

    branch B-SEE , 3. year of study, summer semester, 5 credits, general knowledge
    branch B-TLI , 3. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-BK Bachelor's

    branch BK-TLI , 3. year of study, summer semester, 5 credits, general knowledge

  • Programme IBEP-T Bachelor's

    branch T-IBP , 3. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-BEI , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-BEI , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-BEI , 1. year of study, summer semester, 5 credits, general knowledge
    branch M1-TIT , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-TIT , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-TIT , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-KAM , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-KAM , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-KAM , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-EVM , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-EVM , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-EVM , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-EST , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-EST , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-EST , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-MEL , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-MEL , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-MEL , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-SVE , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-SVE , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-SVE , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-EEN , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-EEN , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-EEN , 1. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-BEI , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-BEI , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-BEI , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-TIT , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-TIT , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-TIT , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-KAM , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-KAM , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-KAM , 2. year of study, summer semester, 5 credits, general knowledge
    branch ML-EVM , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-EVM , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-EVM , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-EST , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-EST , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-EST , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-MEL , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-MEL , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-MEL , 2. year of study, summer semester, 5 credits, general knowledge
    branch ML1-SVE , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-SVE , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-SVE , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML Master's

    branch ML-EEN , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-M1 Master's

    branch M1-EEN , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-ML1 Master's

    branch ML1-EEN , 2. year of study, summer semester, 5 credits, general knowledge

  • Programme EEKR-CZV lifelong learning

    branch ET-CZV , 1. year of study, summer semester, 5 credits, general knowledge

Type of course unit

 

Lecture

26 hours, optionally

Teacher / Lecturer

Computer exercise

26 hours, compulsory

Teacher / Lecturer