|
Lecturer(s)
|
-
Prokopová Zdenka, doc. Ing. CSc.
-
Vojtěšek Jiří, doc. Ing. Ph.D.
-
Šilhavý Petr, doc. Ing. Ph.D.
-
Bajusová Darina, Ing.
|
|
Course content
|
- Basic concepts of DBS - structure, table, indexes, primary and foreign keys, data types, etc. - Conceptual data modeling. - Relational data model. - Normal forms - functional dependencies. - SQL language - basic statements and data selection. - SQL language - aggregation and functions in SQL. - SQL language - nested queries, views. - History of computer networks, basic terminology and types of networks. - Topology of computer networks - physical, logical topology. - Standardization in computer networks - ISO / OSI model, TCP / IP. History, structure. - Ways of connection to computer networks - active and passive elements, collision domain, broadcast domain. - Transmission media for wired network connection, optical fibers. - Wireless network connection - WLAN, IEEE 802.11, WiFi. Licensed and unlicensed bands, security, etc. - Ethernet - basic parameters, collisions, baud rates, etc.
|
|
Learning activities and teaching methods
|
Monologic (Exposition, lecture, briefing), Exercises on PC, Practice exercises
- Term paper
- 10 hours per semester
- Preparation for course credit
- 14 hours per semester
- Preparation for examination
- 28 hours per semester
- Participation in classes
- 42 hours per semester
- Home preparation for classes
- 14 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| Student supposed to have basic knowledge about the operating systems, computer architecture and database systems from previous studies. Other requirements: 80% attendance on seminars, gain more than 50% in tests during semester. |
| Student supposed to have basic knowledge about the operating systems, computer architecture and database systems from previous studies. Other requirements: 80% attendance on seminars, gain more than 50% in tests during semester. |
| learning outcomes |
|---|
| explain the principle of computer networks |
| explain the principle of computer networks |
| Student should be able to describe and realize basic computer network, have clue about the database system SQL and he/she will be able to realize basic database system. |
| describe the functionality of a simple computer network |
| describe the functionality of a simple computer network |
| Student should be able to describe and realize basic computer network, have clue about the database system SQL and he/she will be able to realize basic database system. |
| explain the procedure of designing the structure of a simple relational database |
| explain the procedure of designing the structure of a simple relational database |
| define the principle of relational database systems |
| define the principle of relational database systems |
| list the types of links in relational databases |
| list the types of links in relational databases |
| describe simple computer network |
| describe simple computer network |
| Skills |
|---|
| implement a simple computer network |
| implement a simple computer network |
| design a conceptual, logical, and physical model of a simple relational database |
| design a conceptual, logical, and physical model of a simple relational database |
| apply SQL query language commands |
| apply SQL query language commands |
| implement inserting, updating, and deleting data |
| implement inserting, updating, and deleting data |
| retrieve, sort, and process the required information from stored data |
| retrieve, sort, and process the required information from stored data |
| teaching methods |
|---|
| Knowledge |
|---|
| Practice exercises |
| Exercises on PC |
| Monologic (Exposition, lecture, briefing) |
| Monologic (Exposition, lecture, briefing) |
| Exercises on PC |
| Practice exercises |
| assessment methods |
|---|
| Composite examination (Written part + oral part) |
| Oral examination |
| Oral examination |
| Grade (Using a grade system) |
| Grade (Using a grade system) |
| Composite examination (Written part + oral part) |
| Analysis of seminar paper |
| Analysis of seminar paper |
|
Recommended literature
|
-
KÁLLAY, F. a P. PENIAK. Počítačové sítě LAN/MAN/WAN a jejich aplikace. Praha, 2003. ISBN 80-247-0545-1.
-
KEOGH, J. E. Datové struktury bez předchozích znalostí.. Praha, 2006. ISBN 978-80-251-0689-6.
-
KROENKE, D. M., AUER, D. J. Databáze. Brno, 2015. ISBN 978-80-251-4352-0.
-
KUROSE, J. F. a K. W. ROSS. Počítačové sítě. Brno, 2014. ISBN 978-80-251-3010-0.
-
LACKO, Ľ. 1001 tipů a triků pro SQL.. Brno, 2014. ISBN 978-80-251-3825-0.
-
SOSINSKY, B. Mistrovství ? počítačové sítě. Brno, 2010. ISBN 978-80-251-3363-7.
-
STANEK, W. R. SQL Server 2012 ? Kapesní rádce administrátora.. Praha, 2006. ISBN 978-80-251-3797-6.
-
TANENBAUM, Andrew S a D WETHERALL. Computer networks. Boston, 2011. ISBN 0132126958.
|