| Course Unit Code | 352-0555/02 |
|---|
| 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. |
| BAB75 | doc. Ing. Marek Babiuch, 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. LAN, WAN, Internetworking - role of individual layers of ISO / OSI model in computer networks.
2. IP Addressing and VLSM, IP address, address classes, subnet masks and subnet addressing, IPv4 vs. IPv6.
3. Network device administration - router and switch configuration.
4. Static and dynamic routing in computer networks, routing protocols, properties, usage, configuration.
5. TCP/IP, creation of own communication protocol
6. Creating a Windows application using its own communication protocol
7. Technology of client access to SQL server data (ADO. NET, WCF)
8. Creating windows client to SQL by using ADO.NET I
9. Creating windows client to SQL by using ADO.NET II
10. Creating windows client to SQL by using WCF
11. Wireless network WiFi (protocols and equipments, antenna systems, issues of signal propagation)
12. Security of WiFi networks
13 Industrial serial communication interfaces USART, I2C, SPI
14. Credit
|
| 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 credit | Graded credit | 100 | 51 |