352-0555/01 – 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 introduction2013/2014Year of cancellation
Intended for the facultiesFSIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
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

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 nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. 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 yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType 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 nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2021/2022 Summer
2020/2021 Summer
2017/2018 Summer
2014/2015 Summer