Course unit code:
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
Basics of SQL
Simple practical application using database
Data processing in a spreadsheet editor (MS Excel)
Data processing function
Pivot tables and pivot charts
Facebook / Youtube

Facebook / Youtube