Microsoft Enterprise Solutions
FEKT-XPC-MW4Acad. year: 2019/2020
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
BMW1, BMW2, BMW3
Recommended optional programme components
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
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
To obtain detailed knowledge about installation, maintanance, implementation and design of enterprise systems based on Microsoft Windows and other server products.