Course detail

Microsoft Windows Network Technologies

FEKT-XPC-MW3Acad. year: 2023/2024

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.

Entry knowledge

BMW1, BMW2

Rules for evaluation and completion of the course

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.
Ability to implement, manage, maintain and support networking in Microsoft Windows and SQL servers systems as well as troubleshoot common issues.

Study aids

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 reading

Not applicable.

Classification of course in study plans

  • Programme MPC-TIT Master's 0 year of study, winter semester, elective
  • Programme MPC-SVE Master's 0 year of study, winter semester, elective
  • Programme MPC-MEL Master's 0 year of study, winter semester, elective
  • Programme MPC-KAM Master's 0 year of study, winter semester, elective
  • Programme MPC-EVM 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-AUD Master's

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

  • Programme BPC-TLI Bachelor's 0 year of study, winter semester, elective
  • Programme BPC-IBE Bachelor's 3 year of study, winter semester, compulsory-optional

Type of course unit

 

Exercise in computer lab

52 hod., compulsory

Teacher / Lecturer

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.