Institute of Information Engineering, Automation, and Mathematics

Syllabus: Spreadsheet and Database Systems for Data Processing

Course unit code:
N422T0_4B
Course unit title:
Spreadsheet and Database Systems for Data Processing
Mode of completion and Number of ECTS credits:
Class req (2 credits)
Course contents:
Introduction to relational databases
MS Access and MySQL
Database design
Database normalization (1NF, 2NF, 3NF, ...)
Table creation (fields, data types, indexes, field properties, update)
Forms and their elements
Queries
Basics of SQL
Reports
Simple practical application using database
Data processing in a spreadsheet editor (MS Excel)
Data processing function
Pivot tables and pivot charts

Institute of Information Engineering, Automation and Mathematics was established in 1.1.2006 from two departments: Department of Information Engineering and Process Control and Department of Mathematics.

Latest Posts

Useful Links

Contact

FCFT STU in Bratislava
Radlinského 9
812 37 Bratislava, Slovakia
Tel.: +421 259 325 366
Fax: +421 259 325 340
Mobil: +421 918 674 366
e-mail: office@uiam.sk
6th floor, Block C NB

2024 © All Rights Reserved. UIAM FCHPT STU | webmaster@uiam.sk

Facebook / Youtube
Youtube
Twitter
Facebook / Youtube
Facebook
Youtube
Twitter
Instagram
RSS