Course details

Microsoft Enterprise Solutions

IW4 Acad. year 2018/2019 Summer semester 5 credits

Current academic year

Course is not open in this year

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.

Guarantor

Honzík Jan M., prof. Ing., CSc. (DIFS)

Course coordinator

Kurečka Radomír, Ing.

Language of instruction

Czech

Completion

Examination (written+oral)

Time span

  • 52 hrs pc labs

Assessment points

  • 60 pts final exam
  • 40 pts numeric exercises

Department

Department of Information Systems (UIFS)

Instructor

Kurečka Radomír, Ing.
Pataky Štefan, Ing.

Subject specific learning outcomes and competences

Ability to implement, manage, troubleshoot, design and deploy enterprise technologies MS Exchange and MS SQL Server
General understanding of database systems, electronic communication and troubleshooting of performance and network issues.

Learning objectives

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

Why is the course taught

If you want to obtain really deep knowledge of Windows network, setting firewalls, Active Directory as well as application servers like SQL, Exhange etc, you are welcomed to IW3 and IW4 courses!

Recommended prerequisites

Prerequisite knowledge and skills

Graduation of courses IW1 and IW2.

Study literature

  • Francis, Dishan. Mastering Active Directory : automate tasks by leveraging PowerShell for Active Directory Domain Services 2016. Birmingham, UK: Packt Publishing, 2017.
  • Assaf, William, et al. SQL server 2017 administration inside out. Redmond, Washington: Microsoft Press, 2018.
  • Isakov, Victor. Exam ref 70-764 administering a SQL database infrastructure.  Pearson Education, 2018.
  • Andersson, Jonas, Nuno Mota, and Mike Pfeiffer. Microsoft Exchange Server 2016 PowerShell Cookbook - Fourth Edition. Birmingham: Packt Publishing, 2017.
  • Cunningham, Paul, and Brian Svidergol. Exam ref 70-345 : designing and deploying Microsoft Exchange Server 2016. Redmond, Washington: Microsoft Press, 2016.
  • Elfassy, David. Mastering microsoft exchange server 2016. Place of publication not identified: Wiley-Sybex, 2016.

Progress assessment

No requirements.

Controlled instruction

All forms of teaching are optional. Exercises can be substituted in any other term (but we can not guarantee free space in the classroom - priority is given to enrolled students). If necessary, please contact the teacher or guarantor.

Exam prerequisites

No requirements.

Course inclusion in study plans

  • Programme IT-BC-3, field BIT, 2nd year of study, Elective
Back to top