Course detail

Microsoft Enterprise Solutions

FEKT-XMW4Acad. year: 2019/2020

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

Language of instruction

Czech

Number of ECTS credits

5

Mode of study

Not applicable.

Learning outcomes of the course unit

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

Prerequisites

BMW1, BMW2, BMW3

Co-requisites

Not applicable.

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.

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

Work placements

Not applicable.

Aims

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

Specification of controlled education, way of implementation and compensation for absences

Not applicable.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Windows 2000 Server Study Guide (Exam 70-215), Osborne McGraw-Hill, ISBN 0-07-212389-3
MCSE Microsoft® Windows® 2000 Server Readiness Review; Exam 70-215, Ethan Wilansky, ISBN 0-7356-0948-9
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

Recommended reading

Not applicable.

Classification of course in study plans

  • Programme EEKR-ML1 Master's

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

  • Programme EEKR-M1 Master's

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

  • Programme EEKR-ML1 Master's

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

  • Programme EEKR-M1 Master's

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

  • Programme EEKR-ML1 Master's

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

  • Programme EEKR-M1 Master's

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

  • Programme EEKR-ML1 Master's

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

  • Programme EEKR-M1 Master's

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

  • Programme EEKR-ML1 Master's

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

  • Programme EEKR-M1 Master's

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

  • Programme EEKR-ML1 Master's

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

  • Programme EEKR-M1 Master's

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

  • Programme EEKR-ML1 Master's

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

  • Programme EEKR-M1 Master's

    branch M1-EEN , 1. year of study, summer semester, general knowledge
    branch M1-BEI , 2. year of study, summer semester, general knowledge

  • Programme EEKR-ML1 Master's

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

  • Programme EEKR-M1 Master's

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

  • Programme EEKR-ML1 Master's

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

  • Programme EEKR-M1 Master's

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

  • Programme EEKR-ML1 Master's

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

  • Programme EEKR-M1 Master's

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

  • Programme EEKR-ML1 Master's

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

  • Programme EEKR-M1 Master's

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

  • Programme EEKR-ML1 Master's

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

  • Programme EEKR-M1 Master's

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

  • Programme EEKR-ML1 Master's

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

  • Programme EEKR-M1 Master's

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

  • Programme EEKR-ML1 Master's

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

Type of course unit

 

Lecture

26 hours, optionally

Teacher / Lecturer

Exercise in computer lab

26 hours, compulsory

Teacher / Lecturer