Study Guide

Objective

- you know the principles of DBMS, base functions and purposes
- you know different kind of DBMSs
- you know how to implement drawing of database based on requirements
- you understand the differences between different data models and you know how to choose the right database for your data model
- you know how to design and implement database correctly.
- you know how to use database as a part of system
- you know how to use different kind of database systems

Content

- SQL-language basics (queries, DML- and DDL -commands)
- normalizing
- data models
- DBMSs, especially for PostgreSQL, MySQL/MariaDB, Oracle, MS SQL Server
- going through small database application development

Location and time

- SQL-language basics (queries, DML- and DDL -commands)
- normalizing
- data models
- DBMSs, especially for PostgreSQL, MySQL/MariaDB, Oracle, MS SQL Server
- going through small database application development

Teaching methods

Student
- knows the principles of DBMS, base functions and purposes
- knows different kind of DBMSs
- can implement drawing of database based on requirements
- understands different kind of database models and can choose DBMS for model
- can implement database that works
- can make use of database as a part of system
- can implement different kind of database systems

Evaluation scale

H-5

Assessment methods and criteria

Exercises, project work (50%) and exam (50%).