Sep 21, 2019   0:45 a.m. Matúš
Academic information system

Course syllabus N422T0_4B - Spreadsheet and Database Systems for Data Processing (FCFT - SS 2015/2016)


     Information sheet          ECTS          Syllabus          


     Slovak          English          


University: Slovak University of Technology in Bratislava
Faculty: Faculty of Chemical and Food Technology
Course unit code: N422T0_4B
Course unit title: Spreadsheet and Database Systems for Data Processing
Mode of completion and Number of ECTS credits: Classified fulfillment of requirements (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


Last modification made by Ing. Tomáš Molnár on 12/15/2015.

Type of output: