Course detail

Microsoft Windows Network Technologies

FEKT-XPC-MW3Acad. year: 2020/2021

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. Active Directory: sites, services, replication, GC, domain groups, the database and LDAP, partitions and replication, integration with DNS and NetBIOS. 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

Ing. Radomír Kurečka

Department

Faculty of Information Technology (FIT)

Learning outcomes of the course unit

Ability to implement, manage, maintain and support networking in Microsoft Windows and SQL servers systems as well as troubleshoot common issues.

Prerequisites

BMW1, BMW2

Co-requisites

Not applicable.

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.

Course curriculum

Routing, DHCP, Windows Firewall
differences between ICS and NAT, NAT, RIP, WDS, OPSF, DNS, (WINS)
Certificates, certificate authority, EFS
Remote Access Connection, authentification, RADIUS (IAS), demand-dial routing
IPSec a VPN (PPTP a L2TP), protocol and services SMTP, NNTP and POP3.
Active Directory: introduction, structure, roles
Active Directory: accounts, groups
Active Directory: trusts, replication
Active Directory: kerberos, LDAP
SQL Server: instalation, systems and user databases, object types (tables, views, stored procedure, functions), primary, foreign keys, SQL Query Analyzer
SQL Server: Enterprise Manager, Network Libraries, MSDE, sevurity - users and logins
SQL Server: database internal structure (transactions and logs, locks. databases files, database backup and restore, system tables ),
SQL Server: database replication, server monitoring , DTS.

Work placements

Not applicable.

Aims

To obtain strong knowledge about administering, implementing and designing Microsoft Windows networking systems and services. Course will provide students with hands on practice at lab environment. Course will provide guidance for preparation for Microsoft certification exams for desktop systems.

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

Not applicable.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Exam Ref 70-741 Networking with Windows Server 2016 with Practice Test - Andrew Warren, Microsoft Press (CS)
Exam Ref 70-744 Securing Windows Server 2016 - Timothy L. Warner, Craig Zacker, Microsoft Press (CS)
Exam Ref 70-764 Administering a SQL Database Infrastructure - Victor Isakov, Microsoft Press (CS)

Recommended literature

Not applicable.

Classification of course in study plans

  • Programme BPC-IBE Bachelor's 3 year of study, winter semester, compulsory-optional
  • Programme BPC-TLI Bachelor's 0 year of study, winter semester, elective
  • Programme MPC-KAM Master's 0 year of study, winter semester, elective
  • Programme MPC-TIT Master's 0 year of study, winter semester, elective
  • Programme MPC-MEL Master's 0 year of study, winter semester, elective
  • Programme MPC-EKT Master's 0 year of study, winter semester, elective
  • Programme MPC-EEN Master's 0 year of study, winter semester, elective
  • Programme MPC-SVE Master's 0 year of study, winter semester, elective
  • Programme MPC-EVM Master's 0 year of study, winter semester, elective

  • Programme MPC-AUD Master's

    specialization AUDM-ZVUK , 0 year of study, winter semester, elective

Type of course unit

 

Exercise in computer lab

52 hod., compulsory

Teacher / Lecturer

Ing. Radomír Kurečka

Syllabus

1. Routing, DHCP, Windows Firewall, rozdíl mezi ICS a NAT, NAT, RIP, WDS, OPSF, DNS, (WINS).
2. Certifikáty, certifikační autorita, EFS, šifrování emailu.
3. Remote Access Connection, autorizace, RADIUS (IAS), demand-dial routing .
4. IPSec a VPN (PPTP a L2TP), Služby a protokoly SMTP, NNTP a POP3.
5. Active Directory: úvod, struktura, role
6. Active Directory: účty, skupiny
7. Active Directory: trusty, replikace
8. Active Directory: kerberos, LDAP
9. SQL Server: Instalace, systémové a uživatelské databáze, typy objektů (tabulky, view, stored procedure, funkce), primární a cizí klíče, SQL Query Analyzer
10. SQL Server: Enterprise Manager, Network Libraries, MSDE, zabezpečení: uživatelé a loginy
11. SQL Server: Vnitřní struktura databáze (transakce a logy, locky, databázové soubory, zálohování a obnova databází, systémové tabulky),
12. SQL Server: Replikace databází, monitorování serveru, DTS.