| Course Unit Code | 352-0555/01 |
|---|
| Number of ECTS Credits Allocated | 5 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | Second Cycle |
|---|
| Year of Study * | Second Year |
|---|
| Semester when the Course Unit is delivered | Summer Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| FOJ74 | Ing. David Fojtík, Ph.D. |
| 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. |
| Learning Outcomes of the Course Unit |
|---|
| 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. |
| Course Contents |
|---|
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í
|
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
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. |
FOJTÍK, David, Technologie počítačových sítí [online]. [cit. 2020-04-20]. Dostupné z: https://lms.vsb.cz/
XML Tutorial, [online]. [Accessed 20 April 2020]. Retrieved from: https://www.w3schools.com/xml/default.asp
STEPHENS, Ryan K., Ronald R. PLEW a Arie JONES, 2010. Naučte se SQL za 28 dní: [stačí hodina denně]. Brno: Computer Press. ISBN 978-80-251-2700-1.
KÖHRE, Thomas, 2004. Stavíme si bezdrátovou síť Wi-fi. Brno: Computer Press. ISBN 80-251-0391-9.
|
| Recommended Reading: |
|---|
BEN-GAN, Itzik, [2016]. T-SQL fundamentals. Third edition. Redmond, Washington: Microsoft Press. ISBN 9781509302000.
|
FOJTÍK, David, Srovnání LINQ to XML a XQuery. In XXXIII. Seminar ASR ‘2008 “Instruments and Control”. Ostrava: VŠB-TU Ostrava, 25. 4. 2008, s. 67 – 79. ISBN 978-80-248-1727-9.
HOLUBOVÁ, Irena a Jaroslav POKORNÝ, 2008. XML technologie: principy a aplikace v praxi. Praha: Grada. Průvodce (Grada). ISBN 978-80-247-2725-7.
KELLENBERGER, Kathi, [2014]. Beginning T-SQL. Third edition. New York, NY: Distributed to the Book trade worldwide by Springer Science+Business Media. ISBN 1484200470.
SOLID QUALITY LEARNING. Microsoft SQL Server 2005: Základy databází. Praha 2007. ISBN: 978-80-251-1524-4
VIEIRA, Robert, 2001. SQL Server 2000: programujeme profesionálně. Praha: Computer Press. Profi. ISBN 80-7226-506-7.
YOUNG, Michael J., 2006. XML krok za krokem. 2. vyd. Přeložil Aleš THIEMEL. Brno: Computer Press. ISBN 80-251-1070-2.
ZANDL, Patrick, 2003. Bezdrátové sítě WiFi: praktický průvodce. Brno: Computer Press. ISBN 80-7226-632-2. |
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Graded exercises evaluation | Graded credit | 100 | 51 |