Course detail

Microsoft Enterprise Solutions

FEKT-XPC-MW4Acad. year: 2023/2024

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.

Language of instruction

Czech

Number of ECTS credits

5

Mode of study

Not applicable.

Guarantor

Ing. Radomír Kurečka

Department

Faculty of Electrical Engineering and Communication (FEKT)

Entry knowledge

BMW1, BMW2, BMW3

Rules for evaluation and completion of the course

Not applicable.

Aims

To obtain detailed knowledge about installation, maintanance, implementation and design of enterprise systems based on Microsoft Windows and other server products.
Ability to deploy, implement, maintain and plan Microsoft enterprise systems

Study aids

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

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)

Recommended reading

Not applicable.

Classification of course in study plans

  • Programme BPC-TLI Bachelor's, any year of study, summer semester, elective
  • Programme BPC-IBE Bachelor's, 3. year of study, summer semester, compulsory-optional

  • Programme MPC-AUD Master's

    specialization AUDM-ZVUK , any year of study, summer semester, elective

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

Type of course unit

 

Lecture

26 hours, optionally

Teacher / Lecturer

Ing. Radomír Kurečka

Exercise in computer lab

26 hours, compulsory

Teacher / Lecturer

Ing. Radomír Kurečka