Course detail
Microsoft Windows Network Technologies
FEKT-XPC-MW3Acad. year: 2021/2022
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
Number of ECTS credits
Mode of study
Guarantor
Department
Learning outcomes of the course unit
Prerequisites
Co-requisites
Planned learning activities and teaching methods
Assesment methods and criteria linked to learning outcomes
Course curriculum
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
Aims
Specification of controlled education, way of implementation and compensation for absences
Recommended optional programme components
Prerequisites and corequisites
Basic literature
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
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-AUD Master's
specialization AUDM-ZVUK , 0 year of study, winter semester, elective
- Programme MPC-EEN Master's 0 year of study, winter semester, elective
- Programme MPC-EKT Master's 0 year of study, winter semester, elective
- Programme MPC-EVM Master's 0 year of study, winter semester, elective
- Programme MPC-KAM Master's 0 year of study, winter semester, elective
- Programme MPC-MEL Master's 0 year of study, winter semester, elective
- Programme MPC-SVE Master's 0 year of study, winter semester, elective
- Programme MPC-TIT Master's 0 year of study, winter semester, elective
Type of course unit
Exercise in computer lab
Teacher / Lecturer
Syllabus
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.