352-0555/02 – Computers Network Technology (TPS)

Gurantor departmentDepartment of Control Systems and InstrumentationCredits5
Subject guarantorIng. David Fojtík, Ph.D.Subject version guarantorIng. David Fojtík, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year2Semestersummer
Study languageCzech
Year of introduction2021/2022Year of cancellation
Intended for the facultiesFSIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
BAB75 doc. Ing. Marek Babiuch, Ph.D.
FOJ74 Ing. David Fojtík, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 2+3
Part-time Graded credit 10+4

Subject aims expressed by acquired skills and competences

The subject is designed for students of the last year of study and as such aims to supplement the gaps in knowledge in the themes wich are required in practice, but on wich in the other subjects during the studying not remain enough time. The main objective is to acquaint students with the latest technologies used in the practice in area of transformation and data processing. Students will gain a comprehensive overview of information's technologies wich are built on XML and database technologies (client-server) etc. An integral part of the course is also an area of ​​wireless WiFi networks, that is focuses on the issues of building and administering a wireless networks.

Teaching methods

Lectures
Tutorials

Summary

The subject is designed for students of the last year of study and as such aims to supplement the gaps in knowledge in the themes wich are required in practice, but on wich in the other subjects during the studying not remain enough time. The main objective is to acquaint students with the latest technologies used in the practice in area of transformation and data processing. Students will gain a comprehensive overview of information's technologies wich are built on XML and database technologies (client-server) etc. An integral part of the course is also an area of ​​wireless WiFi networks, that is focuses on the issues of building and administering a wireless networks.

Compulsory literature:

XML Tutorial, [online]. [Accessed 20 April 2020]. Retrieved from: https://www.w3schools.com/xml/default.asp KELLENBERGER, K., [2014]. Beginning T-SQL. Third edition. New York, NY: Distributed to the Book trade worldwide by Springer Science+Business Media. ISBN 1484200470. PERAHIA, Eldad a Robert STACEY, 2013. Next generation wireless LANs: 802.11n, 802.11ac, and Wi-Fi direct. Second edition. Cambridge, UK: Cambridge University Press. ISBN 1107016762.

Recommended literature:

BEN-GAN, Itzik, [2016]. T-SQL fundamentals. Third edition. Redmond, Washington: Microsoft Press. ISBN 9781509302000.

Way of continuous check of knowledge in the course of semester

To obtain the credit the student has to: 1) work out one program from the area of ​​database client creation, 2) pass the test focused on network technology.

E-learning

https://lms.vsb.cz/

Other requirements

The student is supposed to know the basics of computer networks, programming in C# language and SQL language.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. LAN, WAN, Internetworking - role of individual layers of ISO / OSI model in computer networks. 2. IP Addressing and VLSM, IP address, address classes, subnet masks and subnet addressing, IPv4 vs. IPv6. 3. Network device administration - router and switch configuration. 4. Static and dynamic routing in computer networks, routing protocols, properties, usage, configuration. 5. TCP/IP, creation of own communication protocol 6. Creating a Windows application using its own communication protocol 7. Technology of client access to SQL server data (ADO. NET, WCF) 8. Creating windows client to SQL by using ADO.NET I 9. Creating windows client to SQL by using ADO.NET II 10. Creating windows client to SQL by using WCF 11. Wireless network WiFi (protocols and equipments, antenna systems, issues of signal propagation) 12. Security of WiFi networks 13 Industrial serial communication interfaces USART, I2C, SPI 14. Credit

Conditions for subject completion

Conditions for completion are defined only for particular subject version and form of study

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2021/2022 (N0714A270011) Control of Machines and Processes P Czech Ostrava 2 Compulsory study plan
2021/2022 (N0714A270011) Control of Machines and Processes K Czech Ostrava 2 Compulsory study plan
2020/2021 (N0714A270011) Control of Machines and Processes K Czech Ostrava 2 Compulsory study plan
2020/2021 (N0714A270011) Control of Machines and Processes P Czech Ostrava 2 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner