Course detail

Microsoft Windows Network Technologies

FIT-IW3Acad. year: 2017/2018

IPv4, IPv6, DHCP, DNS, NAT, routing, Windows Firewall, multicasting. Services and protocols SMTP, NNTP a POP3. PKI: CA, EFS, email encryption, IIS certificates (HTTPS). IPSec a VPN (PPTP a L2TP), RADIUS (IAS). Remote Desktop Services. Network Access Protection.
NAT, routing, Windows Firewall, multicast. Services and protocols SMTP, NNTP, POP3. PKI: CA, EFS, email encryption, IIS HTTPS. IPSec and VPN (PPTP and L2TP), RADIUS. Remote Desktop Services. Network Access Protection.
Active Directory: sites, services, replication, GC, domain groups, the database and LDAP, partitions and replication, integration with DNS and NetBIOS. SW installation (Service Pack, Office + Office Resource Kit). WDS.
SQL Server: installation, system and user databases, object types, primary and foreign keys, Query Analyzer, Network Libraries, Enterprise Manager, MSDE, security, database structure and system tables, transactions, locks, logs, database files, backup and restore, replication, monitoring, DTS.

Language of instruction

Czech

Number of ECTS credits

5

Mode of study

Not applicable.

Guarantor

prof. Ing. Jan M. Honzík, CSc.

Department

Department of Information Systems (UIFS)

Learning outcomes of the course unit

Ability to implement, manage and troubleshoot network technologies based on MS Windows.

General insight into problems of computer networks and their implementation

Prerequisites

Graduation of courses IW1 and IW2.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Not applicable.

Assesment methods and criteria linked to learning outcomes

Study evaluation is based on marks obtained for specified items. Minimimum number of marks to pass is 50.

No requirements.

Course curriculum

    Syllabus of lectures:
    1. Routing, DHCP, Windows Firewall
    2. Comparison ICS and NAT, NAT, RIP, WDS, OPSF, DNS, (WINS)
    3. PKI Certificates, CA, EFS, email encryption,
    4. Remote Access Connection, authorization, RADIUS (IAS), demand-dial routing
    5. IPSec a VPN (PPTP and L2TP), Services and protocols SMTP, NNTP and POP3.
    6. Active Directory: introduction, structure, roles
    7. Active Directory: accounts, groups
    8. Active Directory: trusts, replication
    9. Active Directory: kerberos, LDAP
    10. SQL Server: Installation, system and users databases, object types (tables, views, stored procedure, functions, primary a foreign keys, SQL Query Analyzer
    11. SQL Server: Enterprise Manager, Network Libraries, MSDE, security: users and logins
    12. SQL Server: internal structure of database (transactions and logs, locks, files, backup and restore, system tables),
    13. SQL Server: Replication, monitoring, DTS.

Work placements

Not applicable.

Aims

To obtain a detailed knowledge of Microsoft Windows network environment. Acquire in practice the theory of computer networks and operating systems. Implement and manage and solve problems in network and server technologies based on Microsoft Windows Server 2016. Another goal is to obtain a basic knowledge of SQL Server management.

Specification of controlled education, way of implementation and compensation for absences

No requirements.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Basic literature

Windows Server 2008 R2 TechNet Library http://technet.microsoft.com/en-us/library/dd349801 Windows Server 2012 Technical Library http://technet.microsoft.com/en-us/library/hh801901.aspxWindows Server 2012 http://www.microsoft.com/en-us/server-cloud/windows-server/default.aspxSQL Server 2012 Product Documentation http://technet.microsoft.com/en-us/library/bb418440(v=sql.10).aspxInternetworking Technology Handbook http://docwiki.cisco.com/wiki/Internetworking_Technology_Handbook

Recommended reading

Microsoft Learning - Windows Server https://www.microsoft.com/learning/en/us/windows-server-certification.aspxDan Holme et al.: MCTS Self-Paced Training Kit (Exam 70-640): Configuring Windows Server 2008 Active Directory (2nd Edition), ISBN: 9780735651937Tony Northrup and J.C. Mackin: MCTS Self-Paced Training Kit (Exam 70-642): Configuring Windows Server 2008 Network Infrastructure (2nd Edition), ISBN: 9780735651609Orin Thomas and Ian McLean: MCITP Self-Paced Training Kit (Exam 70-646): Windows Server 2008 Server Administrator (2nd Edition), ISBN: 9780735649095William R. Stanek: Mistrovství v Microsoft Windows Server 2008, ISBN: 9788025121580William R. Stanek: Windows Server 2012 Pocket Consultant, ISBN: 9780735666337William R. Stanek: Windows Server 2012 Inside Out, ISBN: 9780735666313Microsoft Learning - MS SQL Server http://www.microsoft.com/learning/en/us/sql-certification.aspxMike Hotek: MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance, ISBN: 9780735626058 William R. Stanek: Microsoft SQL Server 2012 Pocket Consultant, ISBN: 9780735663763

Classification of course in study plans

  • Programme IT-BC-3 Bachelor's

    branch BIT , 2 year of study, winter semester, elective

Type of course unit

 

Exercise in computer lab

52 hod., optionally

Teacher / Lecturer

prof. Ing. Jan M. Honzík, CSc.