Data management and data platformsLaajuus (5 cr)
Code: AL00CJ24
Credits
5 op
Teaching language
- English
Objective
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
Enrollment
20.11.2024 - 10.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
- English
Seats
20 - 50
Degree programmes
- Complementary competence, Bachelor's
Teachers
- Reko Juntto
- Jaana Tanhuanpää
Groups
-
LLPREX25KIB
-
LLTIEX25K2
-
LLTIEX25K3
-
LLPREX25KH
-
LLTIEX25K1
-
LLABTO24-25EComplementary competence (Bachelor's) 2024-2025, Faculty of Business and Hospitality Management
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.
Enrollment
06.05.2024 - 30.08.2024
Timing
30.09.2024 - 29.11.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
- English
Seats
20 - 100
Degree programmes
- Complementary competence, Bachelor's
Teachers
- Vesa Alatalo
- Jaana Tanhuanpää
Scheduling groups
- Itsenäinen opiskelu verkossa (Size: 0. Open UAS: 0.)
- Verkkoluento 1 (Size: 0. Open UAS: 0.)
Groups
-
LLABTO23-24EComplementary competence (Bachelor's) 2023-2024, Faculty of Business and Hospitality Management
-
LLTIEX24S1
-
LLTIEX24S2
-
LLABTOIT
-
LLPREX24SIB
-
LLPREX24SH
-
LLABTO24-25EComplementary competence (Bachelor's) 2024-2025, Faculty of Business and Hospitality Management
Small groups
- Self paced studies
- Online lecture 1
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 course to learn more about data management, business intelligence, and relational database management. The course has 3 online lectures. Students complete most of the course independently on the Moodle learning platform.
Timing and attendance
The course starts at the end of September and ends in November 2024. During this time, students participate in 3 online lectures. The rest of the time, the student studies 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.