Data Management and Data PlatformsLaajuus (5 cr)
Code: AL00CJ77
Credits
5 op
Teaching language
- Finnish
Objective
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
Enrollment
20.11.2024 - 05.01.2025
Timing
03.03.2025 - 16.05.2025
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Distance learning
Unit
Faculty of Business and Hospitality Management (LAB)
Campus
E-campus
Teaching languages
- Finnish
Seats
20 - 50
Degree programmes
- Bachelor's Degree Programme in Business Information Technology (in Finnish)
Teachers
- Reko Juntto
- Jaana Tanhuanpää
Scheduling groups
- Itsenäinen opiskelu verkossa (Size: 0. Open UAS: 0.)
- Avoimen ammattikorkeakoulun kiintiö (Size: 10. Open UAS: 10.)
Groups
-
LLABTOIT
-
LLABTO24-25
-
LLPRLII22SL
Small groups
- 1
- Open UAS quota
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.
Enrollment
20.11.2023 - 05.01.2024
Timing
04.03.2024 - 10.05.2024
Number of ECTS credits allocated
5 op
Virtual portion
5 op
Mode of delivery
Distance learning
Unit
Faculty of Business and Hospitality Management (LAB)
Campus
E-campus
Teaching languages
- Finnish
Degree programmes
- Bachelor's Degree Programme in Business Information Technology (in Finnish)
Teachers
- Jaana Tanhuanpää
- Vesa Alatalo
Groups
-
LLABTO23-24
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.