Information Management and DatabasesLaajuus (5 cr)
Study unit code: R0241
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
Enrollment
20.05.2024 - 26.05.2024
Timing
26.08.2024 - 30.11.2024
Number of ECTS credits allocated
5 op
Virtual proportion
2.5 op
Mode of delivery
50 % Contact teaching, 50 % Distance learning
Unit
Laurea Tikkurila
Campus
Laurea Tikkurila
Teaching languages
- Finnish
Seats
20 - 40
Degree programmes
- Degree Programme in Business Information Technology, Developing Digital Services (NDV2), Laurea Tikkurila (in Finnish)
Teachers
- Matti Oosi
Teacher in charge
Matti Oosi
Groups
-
NDV224KATietojenkäsittelyn koulutus, digitaalisten palveluiden kehittäminen, monimuotototeutus, K24, Tikkurila
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
Described in Finnish.
Location and time
N/A
Learning materials and recommended literature
Described in Finnish.
Alternative completion methods of implementation
Described in Finnish.
Co-operation with working life and/or RDI
N/A
Important dates
Described in Finnish.
Forms of internationality
N/A
Students workload
Described in Finnish.
Content and scheduling
Described in Finnish.
Further information for students
Described in Finnish.
Grading scale
H-5
Evaluation methods and criteria
Described in Finnish.
Evaluation criteria, fail (0)
Described in Finnish.
Evaluation criteria, satisfactory (1-2)
Described in Finnish.
Evaluation criteria, good (3-4)
Described in Finnish.
Evaluation criteria, excellent (5)
Described in Finnish.
Enrollment
20.05.2024 - 26.05.2024
Timing
01.08.2024 - 31.12.2024
Number of ECTS credits allocated
5 op
Virtual proportion
2.5 op
Mode of delivery
50 % Contact teaching, 50 % Distance learning
Unit
Laurea Leppävaara, tiko
Campus
Laurea Leppävaara
Teaching languages
- Finnish
Seats
40 - 90
Degree programmes
- Tietojenkäsittelyn koulutus, kyberturvallisuus (NKA2), Laurea Leppävaara (Finnish)
- Degree Programme in Business Information Technology, Developing Digital Services (NDA2), Laurea Leppävaara (in Finnish)
Teachers
- Outi Grotenfelt
- Katja Henttonen
Teacher in charge
Outi Grotenfelt
Groups
-
NKA224KATietojenkäsittelyn koulutus, kyberturvallisuus, monimuotototeutus, K24, Leppävaara
-
NDA224KATietojenkäsittelyn koulutus, digitaalisten palveluiden kehittäminen, monimuotototeutus, K24, 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
Described in Finnish.
Location and time
N/A
Learning materials and recommended literature
Described in Finnish.
Alternative completion methods of implementation
Described in Finnish.
Co-operation with working life and/or RDI
N/A
Important dates
Described in Finnish.
Forms of internationality
N/A
Students workload
Described in Finnish.
Content and scheduling
Described in Finnish.
Further information for students
Described in Finnish.
Grading scale
H-5
Evaluation methods and criteria
Described in Finnish.
Evaluation criteria, fail (0)
Described in Finnish.
Evaluation criteria, satisfactory (1-2)
Described in Finnish.
Evaluation criteria, good (3-4)
Described in Finnish.
Evaluation criteria, excellent (5)
Described in Finnish.
Enrollment
27.11.2023 - 03.12.2023
Timing
16.01.2024 - 26.03.2024
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Laurea Tikkurila
Campus
Laurea Tikkurila
Teaching languages
- Finnish
Seats
20 - 86
Degree programmes
- Degree Programme in Business Information Technology, Developing Digital Services (NDV2), Laurea Tikkurila (in Finnish)
Teachers
- Kari Häkkinen
Teacher in charge
Kari Häkkinen
Scheduling groups
- Pienryhmä 1 (Size: 45. Open UAS: 0.)
- Pienryhmä 2 (Size: 45. Open UAS: 0.)
Groups
-
NDV223SNTietojenkäsittelyn koulutus, digitaalisten palveluiden kehittäminen, päivätoteutus, S23, Tikkurila
Small groups
- Pienryhmä 1
- Pienryhmä 2
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
Described in Finnish.
Location and time
N/A
Learning materials and recommended literature
Described in Finnish.
Alternative completion methods of implementation
Described in Finnish.
Co-operation with working life and/or RDI
N/A
Important dates
Described in Finnish.
Forms of internationality
N/A
Students workload
Described in Finnish.
Content and scheduling
Described in Finnish.
Further information for students
Described in Finnish.
Grading scale
H-5
Evaluation methods and criteria
Described in Finnish.
Evaluation criteria, fail (0)
Described in Finnish.
Evaluation criteria, satisfactory (1-2)
Described in Finnish.
Evaluation criteria, good (3-4)
Described in Finnish.
Evaluation criteria, excellent (5)
Described in Finnish.
Enrollment
22.05.2023 - 28.05.2023
Timing
22.08.2023 - 10.11.2023
Number of ECTS credits allocated
5 op
Virtual proportion
3 op
Mode of delivery
40 % Contact teaching, 60 % Distance learning
Unit
Laurea Tikkurila
Campus
Laurea Tikkurila
Teaching languages
- Finnish
Seats
20 - 40
Degree programmes
- Degree Programme in Business Information Technology, Developing Digital Services (NDV2), Laurea Tikkurila (in Finnish)
Teachers
- Kari Häkkinen
Teacher in charge
Kari Häkkinen
Groups
-
NDV223KATietojenkäsittelyn koulutus, digitaalisten palveluiden kehittäminen, monimuotototeutus, K23, Tikkurila
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
Enrollment
22.05.2023 - 28.05.2023
Timing
21.08.2023 - 30.11.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
- Finnish
Seats
40 - 90
Degree programmes
- Degree Programme in Business Information Technology, Developing Digital Services (NDA2), Laurea Leppävaara (in Finnish)
Teachers
- Outi Grotenfelt
Teacher in charge
Outi Grotenfelt
Groups
-
NDA223KATietojenkäsittelyn koulutus, digitaalisten palveluiden kehittäminen, monimuotototeutus, K23, Leppävaara
-
NKA223KATietojenkäsittelyn koulutus, kyberturvallisuus, monimuotototeutus, K23, 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
Enrollment
28.11.2022 - 04.12.2022
Timing
18.01.2023 - 28.03.2023
Number of ECTS credits allocated
5 op
Virtual proportion
4 op
RDI proportion
1 op
Mode of delivery
20 % Contact teaching, 80 % Distance learning
Unit
Laurea Leppävaara, tiko
Campus
Laurea Leppävaara
Teaching languages
- Finnish
Seats
20 - 40
Degree programmes
- Tietojenkäsittelyn koulutus, kyberturvallisuus (NKA2), Laurea Leppävaara (Finnish)
Teachers
- Outi Grotenfelt
Teacher in charge
Outi Grotenfelt
Groups
-
NKA222SATietojenkäsittelyn koulutus, kyberturvallisuus, monimuotototeutus, 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
H-5
Enrollment
28.11.2022 - 04.12.2022
Timing
16.01.2023 - 30.03.2023
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Laurea Tikkurila
Campus
Laurea Tikkurila
Teaching languages
- Finnish
Seats
20 - 80
Degree programmes
- Degree Programme in Business Information Technology, Developing Digital Services (NDV2), Laurea Tikkurila (in Finnish)
Teachers
- Kari Häkkinen
Teacher in charge
Kari Häkkinen
Scheduling groups
- Pienryhmä 1 (Size: 45. Open UAS: 0.)
- Pienryhmä 2 (Size: 45. Open UAS: 0.)
Groups
-
NDV222SNTietojenkäsittelyn koulutus, digitaalisten palveluiden kehittäminen, päivätoteutus, S22, Tikkurila
Small groups
- Pienryhmä 1
- Pienryhmä 2
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
Enrollment
23.05.2022 - 29.05.2022
Timing
29.08.2022 - 09.12.2022
Number of ECTS credits allocated
5 op
Virtual proportion
3 op
Mode of delivery
40 % Contact teaching, 60 % Distance learning
Unit
Laurea Tikkurila
Campus
Laurea Tikkurila
Teaching languages
- Finnish
Seats
20 - 40
Degree programmes
- Tietojenkäsittelyn koulutus (NTV2), Laurea Tikkurila (Finnish)
Teachers
- Kari Häkkinen
Teacher in charge
Kari Häkkinen
Groups
-
NDV222KATietojenkäsittelyn koulutus, digitaalisten palveluiden kehittäminen, monimuotototeutus, K22, Tikkurila
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
Enrollment
23.05.2022 - 29.05.2022
Timing
01.08.2022 - 31.12.2022
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
- Finnish
Seats
40 - 85
Degree programmes
- Tietojenkäsittelyn koulutus, kyberturvallisuus (NKA2), Laurea Leppävaara (Finnish)
- Degree Programme in Business Information Technology, Developing Digital Services (NDA2), Laurea Leppävaara (in Finnish)
Teachers
- Outi Grotenfelt
Teacher in charge
Outi Grotenfelt
Groups
-
NDA222KATietojenkäsittelyn koulutus, digitaalisten palveluiden kehittäminen, monimuotototeutus, K22, Leppävaara
-
NKA222KATietojenkäsittelyn koulutus, kyberturvallisuus, monimuotototeutus, K22, 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
Zoom meetings are based on guided workshops with the following format:
- Teacher's lecture to present the session's topics
- Hands-on exercises
Learning materials and recommended literature
- lecturing materials (on Canvas)
- excercises (viope-program)
- you need your own laptop
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.
Zoom contact sessions contain theory parts and practice-based workshops guided by the teachers.
Grading scale
H-5
Evaluation methods and criteria
exame
project work (can be done in pairs)
Both parts obligatory
Evaluation criteria, satisfactory (1-2)
Minimun half of the score in exam and something done in the database
Evaluation criteria, good (3-4)
Passing exam well and making database and its queries partly
Evaluation criteria, excellent (5)
Passing exam with honor and making database and all queries expected
Enrollment
29.11.2021 - 05.12.2021
Timing
19.01.2022 - 31.03.2022
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Laurea Tikkurila
Campus
Laurea Tikkurila
Teaching languages
- Finnish
Seats
20 - 80
Degree programmes
- Tietojenkäsittelyn koulutus (NTV2), Laurea Tikkurila (Finnish)
Teachers
- Kari Häkkinen
Teacher in charge
Kari Häkkinen
Scheduling groups
- Pienryhmä 1 (Size: 45. Open UAS: 0.)
- Pienryhmä 2 (Size: 45. Open UAS: 0.)
Groups
-
NTV221SNTietojenkäsittelyn koulutus, päivätoteutus, S21, Tikkurila
Small groups
- Pienryhmä 1
- Pienryhmä 2
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
Enrollment
29.11.2021 - 05.12.2021
Timing
17.01.2022 - 08.04.2022
Number of ECTS credits allocated
5 op
Virtual proportion
2 op
Mode of delivery
60 % Contact teaching, 40 % Distance learning
Unit
Laurea Leppävaara, tiko
Campus
Laurea Leppävaara
Teaching languages
- Finnish
Seats
20 - 45
Degree programmes
- Tietojenkäsittelyn koulutus (NTA2), Laurea Leppävaara (Finnish)
Teachers
- Outi Grotenfelt
Teacher in charge
Outi Grotenfelt
Groups
-
NTA221SATietojenkäsittelyn koulutus, monimuotototeutus, 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
Zoom meetings are based on guided workshops with the following format:
- Teacher's lecture to present the session's topics
- Hands-on exercises
Learning materials and recommended literature
- lecturing materials (on Canvas)
- excercises
- you need your own laptop
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.
Zoom contact sessions contain theory parts and practice-based workshops guided by the teachers.
Grading scale
Approved/Failed
Evaluation methods and criteria
exame
project work (can be done in pairs)