352-0527/02 – Computer Networks Management (MPS)

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 introduction2010/2011Year 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

Summary

The goal is to update knowledge in application development wich are closely bound with network technologies and building WiFi networks. The course covers five thematic areas: XML, SQL DML, programing the client aplications using ADO.NET and building WiFi networks.

Compulsory literature:

GUNNERSON, E. Začínáme programovat v C#. Praha: Computer Press, 2001. ISBN 80- 7226-525-3. KAČMÁŘ, D. Programujeme .NET aplikace ve Visual Studiu .NET. Computer Press, Praha 2001. ISBN 80-7226-569-5. ZANDL, P. Bezdrátové sítě WiFi, praktický průvodce. Computer Press, Brno 2003. ISBN 80-7226-632-2. SOLID QUALITY LEARNING. Microsoft SQL Server 2005: Základy databází. Praha 2007. ISBN: 978-80-251-1524-4 VIEIRA, R. SQL Server 2000 Programujeme profesionálně. Praha 2001. ISBN: 8072265067 FOX, D. Naučte se ADO.NET za 21 dní. Computer Press, Praha 2002. ISBN: 80-7226- 772-8 YOUNG, M. J. XML - Krok za krokem. Mobil media 2002, ISBN: 8086593282

Recommended literature:

Way of continuous check of knowledge in the course of semester

To obtain credit the student must prepare a report from the WiFi and pass an test wich is focused on XML technology.

E-learning

Další požadavky na studenta

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. XML - the rules for creating elements and attributes, namespace 2. XML technology - validation and editing XML documents, XML schemas (XSD and DTD), DOM 3. XML - query and data transformation, XPath, XML Query, xmlt, LINQ to XML 4. Querying the SQL Server - Data Mining (directive Select, filter and group data) 5. Querying the SQL Server - querying multiple tables, queries with subqueries 6. Querying the SQL server - data modification (Insert, Update, Delete, Truncate table) 7. Introduction to the creation of stored procedures and functions 8. Introduction to ADO technology .NET, calling queries and presentation data on the forms 9. ADO technology .NET, data editing of tables in the session 10. Specific problematic of WiFi technology, antenna systems, problems of signal propagation 11. Wireless Network Security

Conditions for subject completion

Full-time form (validity from: 2010/2011 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Graded exercises evaluation Graded credit 100 (100) 51
        Projekt Other task type 100  51
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2012/2013 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 2 Compulsory study plan
2012/2013 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 2 Compulsory study plan
2011/2012 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 2 Compulsory study plan
2011/2012 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 2 Compulsory study plan
2010/2011 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 2 Compulsory study plan
2010/2011 (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