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
Combined 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:

W3C "XML Technology" available from http://www.w3.org/standards/xml/ Jeff Duntemann's "Wi-Fi Guide", ISBN-10: 1932111883, ISBN-13: 978-1932111880

Recommended literature:

W3C "XML Tutorial" available from http://www.w3schools.com/xml/default.asp Mateti, Prabhaker (2005). "Hacking Techniques in Wireless Networks". Dayton, Ohio: Department of Computer Science and Engineering Wright State University. Retrieved 2010-02-28.

Way of continuous check of knowledge in the course of semester

E-learning

Další požadavky na studenta

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

Combined form (validity from: 2013/2014 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Graded exercises evaluation Graded credit 100  51
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
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