Lecturer(s)
|
-
Prokopová Zdenka, doc. Ing. CSc.
-
Vojtěšek Jiří, doc. Ing. Ph.D.
-
Ho Le Thi Kim, Ph.D.
|
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
- 8 hours per semester
- Preparation for course credit
- 14 hours per semester
- Preparation for examination
- 28 hours per semester
- Participation in classes
- 32 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 |
describe the functionality of a simple computer network |
describe the functionality of a simple computer network |
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 |
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 |
---|
Monologic (Exposition, lecture, briefing) |
Practice exercises |
Practice exercises |
Exercises on PC |
Exercises on PC |
Monologic (Exposition, lecture, briefing) |
assessment methods |
---|
Oral examination |
Analysis of seminar paper |
Analysis of seminar paper |
Composite examination (Written part + oral part) |
Composite examination (Written part + oral part) |
Oral examination |
Grade (Using a grade system) |
Grade (Using a grade system) |
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.
|