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

Gurantor departmentDepartment of Control Systems and InstrumentationCredits4
Subject guarantorIng. David Fojtík, Ph.D.Subject version guarantorIng. David Fojtík, Ph.D.
Study levelundergraduate or graduateRequirementChoice-compulsory
Year2Semesterwinter
Study languageCzech
Year of introduction2004/2005Year of cancellation2009/2010
Intended for the facultiesFSIntended for study typesMaster
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+2
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

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

E-learning

Other requirements

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Jazyk XML 2. Technologie XML 3. Microsoft SQL Server z pohledu správy a tvorby databází 4. Nástroje SQL Serveru, jazyk Transact SQL 5. SQL DML: získávání dat 6. SQL DML: souhrny a seskupování dat 7. SQL DML: dotazy nad vícero tabulkami 8. SQL DML: modifikace dat a fulltextové vyhledávání 9. Programové prostředky: uložené procedury, spouště, uživatelské funkce 10. Tvorba tlustých klientů v ADO .NET I (VB.NET nebo C#) 11. Tvorba tlustých klientů v ADO .NET II (VB.NET nebo C#) 12. Technologie WiFi: komponenty, typy sítí, dostupné frekvence 13. Hardware pro WiFi sítě: přístupové body, antény, kabely atd. 14. Plánování sítě: problematika šíření WiFi signálu, zabezpečení

Conditions for subject completion

Full-time form (validity from: 1960/1961 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 (100) 0 3
        Úloha Other task type 100  0
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2009/2010 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 2 Choice-compulsory study plan
2009/2010 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 2 Choice-compulsory study plan
2008/2009 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 2 Choice-compulsory study plan
2008/2009 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 2 Choice-compulsory study plan
2007/2008 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 2 Choice-compulsory study plan
2007/2008 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 2 Choice-compulsory study plan
2006/2007 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 2 Choice-compulsory study plan
2006/2007 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 2 Choice-compulsory study plan
2005/2006 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 2 Choice-compulsory study plan
2005/2006 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 2 Choice-compulsory study plan
2004/2005 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics P Czech Ostrava 2 Choice-compulsory study plan
2004/2005 (N2301) Mechanical Engineering (3902T004) Automatic Control and Engineering Informatics K Czech Ostrava 2 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2009/2010 Winter