Title:

Microsoft Windows Network Technologies

Code:IW3
Ac.Year:2017/2018
Term:Winter
Curriculums:
ProgrammeBranchYearDuty
IT-BC-3BIT2ndElective
IT-BC-3BIT3rdElective
Language:Czech
Public info:http://www.fit.vutbr.cz/study/courses/IW3/public/
Private info:http://www.fit.vutbr.cz/study/courses/IW3/private/
Credits:5
Completion:examination
Type of
instruction:
Hour/semLecturesSem. ExercisesLab. exercisesComp. exercisesOther
Hours:000520
 ExaminationTestsExercisesLaboratoriesOther
Points:6004000
Guarantee:Honzík Jan M., prof. Ing., CSc., DIFS
Instructor:Pluskal Jan, Ing., DIFS
Faculty:Faculty of Information Technology BUT
Department:Department of Information Systems FIT BUT
Prerequisites: 
Microsoft Windows Desktop Systems (IW1), DIFS
Microsoft Windows Server Systems (IW2), DIFS
Follow-ups:
Microsoft Enterprise Solutions (IW4), DIFS
Programming .NET and C# (IW5), DIFS
Schedule:
DayLessonWeekRoomStartEndLect.Gr.St.G.EndG.
Wedcomp.lablecturesP93/B030200713:0016:50
 
Learning objectives:
  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.
Description:
  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.
Knowledge and skills required for the course:
  Graduation of courses IW1 and IW2.
Subject specific learning outcomes and competences:
  Ability to implement, manage and troubleshoot network technologies based on MS Windows.
Generic learning outcomes and competences:
  General insight into problems of computer networks and their implementation
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.
Fundamental literature:
 
Study literature:
 
  • Microsoft Learning - Windows Server
    https://www.microsoft.com/learning/en/us/windows-server-certification.aspx
  • Dan Holme et al.: MCTS Self-Paced Training Kit (Exam 70-640): Configuring Windows Server 2008 Active Directory (2nd Edition), ISBN: 9780735651937
  • Tony Northrup and J.C. Mackin: MCTS Self-Paced Training Kit (Exam 70-642): Configuring Windows Server 2008 Network Infrastructure (2nd Edition), ISBN: 9780735651609
  • Orin Thomas and Ian McLean: MCITP Self-Paced Training Kit (Exam 70-646): Windows Server 2008 Server Administrator (2nd Edition), ISBN: 9780735649095
  • William R. Stanek: Mistrovství v Microsoft Windows Server 2008, ISBN: 9788025121580
  • William R. Stanek: Windows Server 2012 Pocket Consultant, ISBN: 9780735666337
  • William R. Stanek: Windows Server 2012 Inside Out, ISBN: 9780735666313
  • Microsoft Learning - MS SQL Server
    http://www.microsoft.com/learning/en/us/sql-certification.aspx
  • Mike 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
Controlled instruction:
  No requirements.
Exam prerequisites:
  No requirements.