Faculty of Information Technology, BUT

Course details

Microsoft Enterprise Solutions

IW4 Acad. year 2018/2019 Summer semester 5 credits

Course is not open in this year
Close
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

Deputy Guarantor

Kurečka Radomír, Ing. (DIFS FIT BUT)

Language of instruction

Czech

Completion

Examination (written+oral)

Time span

52 hrs pc labs

Assessment points

60 exam, 40 exercises

Department

Instructor

Kurečka Radomír, Ing. (DIFS FIT BUT)
Pataky Štefan, Ing. (FBM BUT)

Subject specific learning outcomes and competences

Ability to implement, manage, troubleshoot, design and deploy enterprise technologies MS Exchange and MS SQL Server

Generic learning outcomes and competences

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!

Prerequisites

Prerequisite kwnowledge 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.

Fundamental 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.

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 BIT, 2nd year of study, Elective
  • Programme IT-BC-3, field BIT, 2nd year of study, Elective
  • Programme IT-BC-3, field BIT, 3rd year of study, Elective
Back to top