Opinto-opas

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.