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.
Supervisor
Department
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, elective
- 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, elective
- Programme MPC-TIT Master's, any year of study, summer semester, 5 credits, elective
- Programme MPC-KAM Master's, any year of study, summer semester, 5 credits, elective
- Programme MPC-EVM Master's, any year of study, summer semester, 5 credits, elective
- Programme MPC-EEN Master's, any year of study, summer semester, 5 credits, elective
- Programme MPC-EKT Master's, any year of study, summer semester, 5 credits, elective
- Programme MPC-MEL Master's, any year of study, summer semester, 5 credits, elective
- Programme MPC-SVE Master's, any year of study, summer semester, 5 credits, elective