Skip to main content
Link list

Study Guide

Choose language
In Finnish In English

Information Management and DatabasesLaajuus (5 cr)

Study unit code: R0279

Credits

5 op

Learning outcomes

The student is able to
- design and implement databases
- manage and use databases
- use query languages to search and modify data in a database

Open in new tab
Enrollment

25.11.2024 - 01.12.2024

Timing

10.01.2025 - 15.03.2025

Number of ECTS credits allocated

5 op

Virtual proportion

5 op

Mode of delivery

Distance learning

Unit

10 Liiketalous-, tietojenkäsittely- ja palvelualat

Campus

Laurea Virtual Campus

Teaching languages
  • English
Seats

20 - 80

Degree programmes
  • Degree Programme in Business Information Technology, Cyber Security (NCA2), Laurea Leppävaara
Teachers
  • Outi Grotenfelt
  • Katja Henttonen
Teacher in charge

Outi Grotenfelt

Groups
  • NSA224SA
    Degree Programme in Business Information Technology, Developing Digital Services, virtual studies, S24, Leppävaara
  • NCA224SA
    Degree Programme in Business Information Technology, Cyber Security, virtual studies, S24, Leppävaara

Learning outcomes

The student is able to
- design and implement databases
- manage and use databases
- use query languages to search and modify data in a database

Grading scale

H-5

Open in new tab
Enrollment

27.11.2023 - 03.12.2023

Timing

01.01.2024 - 31.07.2024

Number of ECTS credits allocated

5 op

Virtual proportion

5 op

Mode of delivery

Distance learning

Unit

Laurea Leppävaara, tiko

Campus

Laurea Virtual Campus

Teaching languages
  • English
Seats

20 - 80

Degree programmes
  • Degree Programme in Business Information Technology, Cyber Security (NCA2), Laurea Leppävaara
Teachers
  • Outi Grotenfelt
Teacher in charge

Outi Grotenfelt

Groups
  • NSA223SA
    Degree Programme in Business Information Technology, Developing Digital Services, virtual studies, S23, Leppävaara
  • NCA223SA
    Degree Programme in Business Information Technology, Cyber Security, virtual studies, S23, Leppävaara

Learning outcomes

The student is able to
- design and implement databases
- manage and use databases
- use query languages to search and modify data in a database

Grading scale

H-5

Open in new tab
Enrollment

28.11.2022 - 04.12.2022

Timing

16.01.2023 - 01.03.2023

Number of ECTS credits allocated

5 op

Virtual proportion

5 op

RDI proportion

1 op

Mode of delivery

Distance learning

Unit

Laurea Leppävaara, tiko

Campus

Laurea Virtual Campus

Teaching languages
  • English
Seats

20 - 75

Degree programmes
  • Degree Programme in Business Information Technology, Cyber Security (NCA2), Laurea Leppävaara
Teachers
  • Outi Grotenfelt
Teacher in charge

Outi Grotenfelt

Groups
  • NSA222SA
    Degree Programme in Business Information Technology, Developing Digital Services, virtual studies, S22, Leppävaara
  • NCA222SA
    Degree Programme in Business Information Technology, Cyber Security, blended learning, S22, Leppävaara

Learning outcomes

The student is able to
- design and implement databases
- manage and use databases
- use query languages to search and modify data in a database

Grading scale

Approved/Failed

Open in new tab
Enrollment

29.11.2021 - 05.12.2021

Timing

10.01.2022 - 06.03.2022

Number of ECTS credits allocated

5 op

Virtual proportion

5 op

Mode of delivery

Distance learning

Unit

Laurea Leppävaara, tiko

Campus

Laurea Virtual Campus

Teaching languages
  • English
Seats

20 - 75

Degree programmes
  • Degree Programme in Business Information Technology, Cyber Security (NCA2), Laurea Leppävaara
  • Degree Programme in Business Information Technology (NIA), Laurea Leppävaara
Teachers
  • Jukka Malinen
Teacher in charge

Jukka Malinen

Groups
  • NCA221SA
    Degree Programme in Business Information Technology, Cyber Security, blended learning, S21, Leppävaara
  • NIA221SA
    Degree Programme in Business Information Technology, virtual studies, S21, Leppävaara

Learning outcomes

The student is able to
- design and implement databases
- manage and use databases
- use query languages to search and modify data in a database

Teaching methods

On-line implementation
Guided workshops with the following format:
- Teacher's lecture to present the session's topics
- Hands-on exercises
-Self study

Learning materials and recommended literature

Lecture material in Canvas
- Exercises and Workshops

Further information for students

During this course students will learn in a practical approach key concepts and methods related to information management and databases. Databases are important components in most of today's information systems and applications. The concepts, tools, and methods covered during this course are an essential knowledge base for anyone willing to have a career in the ICT field.
At the beginning of the course, students will be introduced to key concepts and get an overview of the subject. Later, students will get acquainted with relational databases and how to use the SQL query language to search and manipulate data from a database. NoSQL databases are also discussed during the course.

A virtual learning environment (Viope) is used to offer students the possibility to practice SQL in a flexible manner.

Lectures are mostly practice-based workshops guided by the teachers.

Grading scale

H-5

Evaluation methods and criteria

- Exam
- Database project (in pairs)