Introduction to Data ManagementLaajuus (5 cr)
Code: R504D98
Credits
5 op
Teaching language
- English
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
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.
Enrollment
02.10.2023 - 07.01.2024
Timing
08.01.2024 - 24.03.2024
Credits
5 op
Mode of delivery
Contact teaching
Unit
Bachelor of Engineering, Information Technology
Teaching languages
- English
Seats
0 - 30
Teachers
- Aku Kesti
Responsible person
Aku Kesti
Student groups
-
R54D23SBachelor of Engineering, Machine Learning and Data Engineering (full time studies), 2023
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.
Enrollment
03.10.2022 - 08.01.2023
Timing
09.01.2023 - 31.03.2023
Credits
5 op
Virtual proportion (cr)
3 op
Mode of delivery
40 % Contact teaching, 60 % Distance learning
Unit
Bachelor of Engineering, Information Technology
Teaching languages
- English
Seats
0 - 30
Degree programmes
- Machine Learning and Data Engineering
Teachers
- Aku Kesti
Responsible person
Aku Kesti
Student groups
-
R54D22S
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.