Study Guide

Learning outcomes

The student is able to
- find solutions to business data management, data storages and data sharing in various platforms
- work in the process to model an Entity Relationship diagram
- use data management system services and understands their purpose of use
- master relational database concepts and design
- use basic Structural Query Language, SQL commands
- create a simple relational database based on specified requirements

Implementation and methods of teaching

Join this online course to learn more about data management, business intelligence, and relational database management. Students complete most of the course independently on the Moodle learning platform.

Timing and attendance

The online course starts ... and ends 2025. During this time, the student studies in Moodle eLearning platform independently according to his/her own schedule.

Learning material and recommended literature

Material is given on Moodle learning platform + course book. In addition, students are supposed to search for information individually from different sources.

Course book:
It's All Analytics: The Foundations of Al, Big Data and Data Science Landscape for Professionals in Healthcare, Business, and Government
Burk, Scott ; Miner, Gary D. 2020
Available from LAB Primo: https://ebookcentral.proquest.com/lib/lab-ebooks/detail.action?docID=6209045&pq-origsite=primo

Alternative completion methods

None.

Working life cooperation

Examples from real working life are given.

Learning environment

Moodle e-learning platform.

Student time use and work load

The 5 ECTS course requires about 130 hours of work.

Contents

Relational database management system concepts and relational database structure. Overview of NoSQL databases. Data warehousing alternative technologies.
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.

Basics of knowledge management.
Business intelligence, data analytics, and AI.

Assessment criteria

The course is graded on an approved/failed basis. A minimum of 50% of the 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.