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

Gurantor department	Department of Control Systems and Instrumentation	Credits	5
Subject guarantor	Ing. David Fojtík, Ph.D.	Subject version guarantor	Ing. David Fojtík, Ph.D.
Study level	undergraduate or graduate	Requirement	Compulsory
Year	2	Semester	summer
		Study language	Czech
Year of introduction	2013/2014	Year of cancellation
Intended for the faculties	FS	Intended for study types	Follow-up Master

Instruction secured by
Login	Name	Tuitor	Teacher giving lectures
FOJ74	Ing. David Fojtík, Ph.D.

Extent of instruction for forms of study
Form of study	Way 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

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.

Additional study materials

Study supports in the EduDocs system

Way of continuous check of knowledge in the course of semester

E-learning

Other requirements

Studenti pracují v tříčlenných týmech, kdy mají společně vyřešit týmové úlohy. Úlohy jsou strukturovány tak, aby každý člen týmu měl individuální úkol v rámci úlohy. Tým pak svou práci obhajuje společně v rámci týmové prezentace s předloženým protokolem, jehož součástí je i obhajoba dílčích individuálně řešených částí.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Jazyk XML – pravidla pro tvorbu elementů a atributů, jmenný prostor 2. Validace a editace XML dokumentů, XML schémata (XSD a DTD), DOM 3. Vyhledávaní a transformace XML dat, XPATH, XMLT 4. Dotazování nad XML daty, XML Query, Linq to XML 5. Dotazování nad SQL serverem – dolování dat (direktiva Select, filtrování a seskupování dat) 6. Dotazování nad vícero tabulkami, dotazy s poddotazy 7. Modifikace dat relačních databází (Insert, Update, Delete, Truncate table) 8. Úvod do tvorby uložených procedur a funkcí MS SQL serveru 9. Budování komplexních bezdrátových sítí, druhy bezdrátových technologií, frekvence, dovolené výkony 10. Specifická problematika technologie WiFi, anténní systémy, problematika šíření signálu 11. Problematika zabezpečení WiFi sítí

Conditions for subject completion

Part-time form (validity from: 2013/2014 Summer semester)

Task name	Type of task	Max. number of points (act. for subtasks)	Min. number of points	Max. počet pokusů
Graded exercises evaluation	Graded credit	100	51	3

Mandatory attendence participation: Participation in the exercises is mandatory. Only two absences per semester will be tolerated. Students will take two tests as part of the practicum.

Show history

Conditions for subject completion and attendance at the exercises within ISP: Participation in the exercises is mandatory. Only two absences per semester will be tolerated. Students will take two tests as part of the practicum.

Show history

Occurrence in study plans

Academic year	Programme	Branch/spec.	Form	Study language	Tut. centre	Year	Type of duty
2022/2023	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	P	Czech	Ostrava	2	Compulsory	study plan
2022/2023	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	K	Czech	Ostrava	2	Compulsory	study plan
2021/2022	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	P	Czech	Ostrava	2	Compulsory	study plan
2021/2022	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	K	Czech	Ostrava	2	Compulsory	study plan
2020/2021	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	P	Czech	Ostrava	2	Compulsory	study plan
2020/2021	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	K	Czech	Ostrava	2	Compulsory	study plan
2019/2020	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	P	Czech	Ostrava	2	Compulsory	study plan
2019/2020	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	K	Czech	Ostrava	2	Compulsory	study plan
2018/2019	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	P	Czech	Ostrava	2	Compulsory	study plan
2018/2019	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	K	Czech	Ostrava	2	Compulsory	study plan
2017/2018	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	P	Czech	Ostrava	2	Compulsory	study plan
2017/2018	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	K	Czech	Ostrava	2	Compulsory	study plan
2016/2017	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	P	Czech	Ostrava	2	Compulsory	study plan
2016/2017	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	K	Czech	Ostrava	2	Compulsory	study plan
2015/2016	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	P	Czech	Ostrava	2	Compulsory	study plan
2015/2016	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	K	Czech	Ostrava	2	Compulsory	study plan
2014/2015	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	K	Czech	Ostrava	2	Compulsory	study plan
2014/2015	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	P	Czech	Ostrava	2	Compulsory	study plan
2013/2014	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	P	Czech	Ostrava	2	Compulsory	study plan
2013/2014	(N2301) Mechanical Engineering	(3902T004) Automatic Control and Engineering Informatics	K	Czech	Ostrava	2	Compulsory	study plan

Occurrence in special blocks

Block name	Academic year	Form of study	Study language	Year	W	S	Type of block	Block owner

Assessment of instruction