Course: Data Transfer and Storage Systems

« Back
Course title Data Transfer and Storage Systems
Course code AURP/AE2SD
Organizational form of instruction Lecture + Lesson
Level of course Bachelor
Year of study not specified
Semester Summer
Number of ECTS credits 5
Language of instruction Czech, English
Status of course unspecified
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Course availability The course is available to visiting students
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.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester