Study Guide

Objective

The student knows multiple alternatives for implementing a data storage solution in their software project. The student knows how to choose and implement a suitable data management service for the applications.

Content

- Theory of Data Management
- Using databases in applications
- Designing and implementing a database
- Real-time databases
- Relational databases
- NoSQL databases

Location and time

Lessons and code labs are hold in the computer class rooms at Rantavitikka campus in the autumn 2022.

Materials

Materials in our learning environment, moodle. In addition you can use the literature to support your learning. For example:

SQL QuickStart Guide: The Simplified Beginner's Guide to Managing
Author: Shields, Walter

The Art of SQL
Author:Faroult, Stephane

Teaching methods

Lectures, assignments and tutorials. Inn addition code labs which are meant for tutoring the exercises.

International connections

The study unit will be taught in English and makes it possible for international students to join

Completion alternatives

Exercises and independent studying

Content scheduling

General about SQL Databases
Tables
Queries and Changing the data
Filtering
Aggregate functions
Dataset operation
Sorting and Grouping
Working with multiple tables
Database design and modeling
Other option, NOSQL

Evaluation scale

H-5

Assessment criteria, satisfactory (1)

The student knows the basic principles of data management and knows how to use and design simple data management systems. The student is able to complete the learning tasks under guidance and is able to implement some solutions independently. The student is able to solve basic data management problems and search additional information within the digital instruction materials of the data management service providers.

Assessment criteria, good (3)

The student knows the basic principles of data management and knows how to use, design and implement data management systems based on the needs of the given task.The student is able to complete the learning tasks under guidance and is able to implement some solutions independently.

The student knows how to use the features of a data management system and design the implementation of data management for a software project. The student knows how to choose a suitable data management system from different alternatives based on suitability and the needs of the software project.

The student knows how to implement a working solution with the selected data management system. The student is able to solve basic data management problems and search additional information within the digital instruction materials of the data management service providers.

Assessment criteria, excellent (5)

The student is able to proactively use different data management technologies as an integral part of a software implementation. The student is able to select the most suitable data management solution for their task. The student is able to diversely apply different possibilities of data management in practice. The student is able to combine multiple principles towards a working software solution.