Data management and data platformsLaajuus (5 op)
Tunnus: AL00CJ24
Laajuus
5 op
Opetuskieli
- englanti
Osaamistavoitteet
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
Ilmoittautumisaika
20.11.2024 - 10.01.2025
Ajoitus
03.03.2025 - 16.05.2025
Opintopistemäärä
5 op
Virtuaaliosuus
5 op
Toteutustapa
Etäopetus
Yksikkö
Liiketoiminta (LAB)
Toimipiste
Verkkokampus
Opetuskielet
- Englanti
Paikat
20 - 50
Koulutus
- Complementary competence, Bachelor's
Opettaja
- Reko Juntto
- Jaana Tanhuanpää
Ryhmät
-
LLPREX25KIBSaapuvat vaihto-opiskelijat 25K, pitkät vaihdot, liiketalous, Lappeenranta
-
LLTIEX25K2Saapuvat vaihto-opiskelijat 25K, pitkät vaihdot, tietojenkäsittely, Lahti
-
LLTIEX25K3Saapuvat vaihto-opiskelijat 25K, pitkät vaihdot, matkailu, Lahti
-
LLPREX25KHSaapuvat vaihto-opiskelijat 25K, pitkät vaihdot, hotelli- ja ravintola-ala, Lappeenranta
-
LLTIEX25K1Saapuvat vaihto-opiskelijat 25K, pitkät vaihdot, liiketalous, Lahti
-
LLABTO24-25EComplementary competence (Bachelor's) 2024-2025, Faculty of Business and Hospitality Management
Osaamistavoitteet
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
Toteutustapa ja opetusmenetelmät
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.
Ajoitus ja läsnäolo
The online course starts ... and ends 2025. During this time, the student studies in Moodle eLearning platform independently according to his/her own schedule.
Oppimateriaali ja suositeltava kirjallisuus
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
Toteutuksen valinnaiset suoritustavat
None.
Työelämäyhteistyö
Examples from real working life are given.
Oppimisympäristö
Moodle e-learning platform.
Opiskelijan ajankäyttö ja kuormitus
The 5 ECTS course requires about 130 hours of work.
Sisältö
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.
Arviointimenetelmät
The course is graded on an approved/failed basis. A minimum of 50% of the maximum points needed for an approved task/exercise/test.
Arviointiasteikko
Hyväksytty/Hylätty
Arviointikriteerit: arviointiasteikko hyväksytty/hylätty
Minimum of 50% of maximum points needed for an approved task/exercise/test.
Ilmoittautumisaika
06.05.2024 - 30.08.2024
Ajoitus
30.09.2024 - 29.11.2024
Opintopistemäärä
5 op
Virtuaaliosuus
5 op
Toteutustapa
Etäopetus
Yksikkö
Liiketoiminta (LAB)
Toimipiste
Verkkokampus
Opetuskielet
- Englanti
Paikat
20 - 100
Koulutus
- Complementary competence, Bachelor's
Opettaja
- Vesa Alatalo
- Jaana Tanhuanpää
Opetusryhmät
- Itsenäinen opiskelu verkossa (Koko: 0. Avoin AMK: 0.)
- Verkkoluento 1 (Koko: 0. Avoin AMK: 0.)
Ryhmät
-
LLABTO23-24EComplementary competence (Bachelor's) 2023-2024, Faculty of Business and Hospitality Management
-
LLTIEX24S1Saapuvat vaihto-opiskelijat 24S, pitkät vaihdot, liiketalous, Lahti
-
LLTIEX24S2Saapuvat vaihto-opiskelijat 24S, pitkät vaihdot, tietojenkäsittely, Lahti
-
LLABTOITTäydentävä osaaminen (AMK), Liiketoimintayksikkö, Tietojenkäsittely
-
LLPREX24SIBSaapuvat vaihto-opiskelijat 24S, pitkät vaihdot, liiketalous, Lappeenranta
-
LLPREX24SHSaapuvat vaihto-opiskelijat 24S, pitkät vaihdot, hotelli- ja ravintola-ala, Lappeenranta
-
LLABTO24-25EComplementary competence (Bachelor's) 2024-2025, Faculty of Business and Hospitality Management
Pienryhmät
- Itsenäinen opiskelu verkossa
- Verkkoluento 1
Osaamistavoitteet
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
Toteutustapa ja opetusmenetelmät
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.
Ajoitus ja läsnäolo
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.
Oppimateriaali ja suositeltava kirjallisuus
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
Toteutuksen valinnaiset suoritustavat
None.
Työelämäyhteistyö
Examples from real working life are given.
Oppimisympäristö
Moodle e-learning platform.
Opiskelijan ajankäyttö ja kuormitus
The 5 ECTS course requires about 130 hours of work.
Sisältö
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.
Arviointimenetelmät
The course is graded on an approved/failed basis. A minimum of 50% of the maximum points needed for an approved task/exercise/test.
Arviointiasteikko
Hyväksytty/Hylätty
Arviointikriteerit: arviointiasteikko hyväksytty/hylätty
Minimum of 50% of maximum points needed for an approved task/exercise/test.