Course detail

Microsoft Enterprise Solutions

FEKT-XPC-MW4Acad. year: 2020/2021

SQL Server: Management, advanced T-SQL queries, work with geographical and hierarchical data, Business Inteligence. Exchange Server: installation, configuration, relation with Active Directory and other server systems, management, backup, maintenance, troubleshooting, clustering, load-balancing.

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

Exam Ref 70-764 Administering a SQL Database Infrastructure - Victor Isakov, Microsoft Press (CS)
MCSA Windows Server 2016 Exam Ref 3-Pack: Exams 70-740, 70-741, and 70-742 - Craig Zacker, Andrew Warren, Microsoft Press (CS)
Exam Ref 70-345 Designing and Deploying Microsoft Exchange Server 2016 with Practice Test - Paul Cunningham, Brian Svidergol, Microsoft Press (CS)

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 BPC-TLI Bachelor's, any year of study, summer semester, 5 credits, optional
  • Programme BPC-IBE Bachelor's, 3. year of study, summer semester, 5 credits, compulsory-optional

  • Programme MPC-AUD Master's

    specialization AUDM-ZVUK , any year of study, summer semester, 5 credits, optional

  • Programme MPC-TIT Master's, any year of study, summer semester, 5 credits, optional
  • Programme MPC-KAM Master's, any year of study, summer semester, 5 credits, optional
  • Programme MPC-EVM Master's, any year of study, summer semester, 5 credits, optional
  • Programme MPC-EEN Master's, any year of study, summer semester, 5 credits, optional
  • Programme MPC-EKT Master's, any year of study, summer semester, 5 credits, optional
  • Programme MPC-MEL Master's, any year of study, summer semester, 5 credits, optional
  • Programme MPC-SVE Master's, any year of study, summer semester, 5 credits, optional

Type of course unit

 

Lecture

26 hours, optionally

Teacher / Lecturer

Exercise in computer lab

26 hours, compulsory

Teacher / Lecturer

eLearning