Study Guide

Learning outcomes

The student is able to
- answer questions regarding data management, storage and cooperative usage in different environments
- use the services provided by database management systems and understand their relevance
- explain the basic concepts and structures of databases
- combine and utilize data from multiple sources
- understand data storage technologies, their use cases and limitations

Implementation and methods of teaching

Virtual learning course on Moodle platform.

Learning material and recommended literature

To be published in Moodle.

Alternative completion methods

None.

Working life cooperation

Working life case descriptions as examples.

Learning environment

Moodle virtual learning platform.

Student time use and work load

5 ECTS course will be approximately 130 hours of work.

Contents

Entity Relationship diagram.
Relational database concepts and design process. Overview of NoSQL databases and their types.
Structural Query Language (SQL) fundamentals. SQL commands to create, read, update and delete data (CRUD). Focus on querying data for your specified needs from a relational database. SQL SELECT statement in detail.
Business data management, data storages and data sharing in various platforms.

Assessment criteria

Scale approved/failed. Minimum of 50% of maximum points needed for an approved task/exercise/test.

Assessment scale

Approved/Failed

Assessment criteria: assessment scale failed/approved

Minimum of 50% of maximum points needed for an approved task/exercise/test.