Data StoragesLaajuus (5 cr)
Code: AL00CO16
Credits
5 op
Objective
Student is able to
- form queries using SQL
- apply the basic principles of normalization
- maintain databases
- describe the principles of database transactions
- explain the importance of information security in data storage
- describe alternative data storage types
Enrollment
20.11.2023 - 05.01.2024
Timing
08.01.2024 - 29.03.2024
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Faculty of Business and Hospitality Management (LAB)
Campus
Lahti Campus
Teaching languages
- Finnish
Seats
20 - 50
Degree programmes
- Bachelor's Degree Programme in Business Information Technology
Teachers
- Aki Vainio
Scheduling groups
- Luennot 1 (Size: 0. Open UAS: 0.)
Groups
-
LLTIBIT23KBachelor's Degree Programme in Business Information Technology 23K Lahti
Small groups
- Lecture 1
Learning outcomes
Student is able to
- form queries using SQL
- apply the basic principles of normalization
- maintain databases
- describe the principles of database transactions
- explain the importance of information security in data storage
- describe alternative data storage types
Implementation and methods of teaching
Lectures and excercises. The course is graded based on an assignment.
Timing and attendance
Weekly lectures, attendance recommended.
Learning material and recommended literature
The materials on Moodle and WWW, also any introductory book on SQL recommended. The Moodle page also includes optional exercises regarding SQL.
Alternative completion methods
Negotiable.
Exam retakes
Negotiable.
Learning environment
Moodle and group work. The assignment requires the use of XAMPP or similar environment.
Student time use and work load
5 credit course.
Contents
Learning outcomes of the course
Student is able to
- form queries using SQL
- apply the basic principles of normalization
- maintain databases
- describe the principles of database transactions
- explain the importance of information security in data storage
- describe alternative data storage types
Additional information for students: previous knowledge etc.
Basic understanding of programming
Assessment criteria
Based on course assignment
Assessment scale
1-5
Failed (0)
Unable to form basic queries or understand how queries are used in software
Assessment criteria: level 1 (assessment scale 1–5)
Has rudimentary understanding of queries.
Assessment criteria: level 3 (assessment scale 1–5)
Can design databases in a normalized manner
Assessment criteria: level 5 (assessment scale 1–5)
Can form complex queries.
Enrollment
21.11.2022 - 08.01.2023
Timing
01.01.2023 - 28.04.2023
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Faculty of Business and Hospitality Management (LAB)
Campus
Lahti Campus
Teaching languages
- English
Degree programmes
- Bachelor's Degree Programme in Business Information Technology
Teachers
- Aki Vainio
Scheduling groups
- Luennot 1 (Size: 0. Open UAS: 0.)
Groups
-
LLTIBIT22KBachelor's Degree Programme in Business Information Technology 22K Lahti
Small groups
- Luennot 1
Learning outcomes
Student is able to
- form queries using SQL
- apply the basic principles of normalization
- maintain databases
- describe the principles of database transactions
- explain the importance of information security in data storage
- describe alternative data storage types
Implementation and methods of teaching
Lectures and excercises.
Timing and attendance
Weekly lectures, attendance recommended.
Learning material and recommended literature
The materials on Moodle and WWW, also any introductory book on SQL recommended.
Alternative completion methods
Negotiable.
Exam retakes
Negotiable.
Learning environment
Moodle and group work.
Student time use and work load
5 credit course.
Contents
Learning outcomes of the course
Student is able to
- form queries using SQL
- apply the basic principles of normalization
- maintain databases
- describe the principles of database transactions
- explain the importance of information security in data storage
- describe alternative data storage types
Additional information for students: previous knowledge etc.
Basic understanding of programming
Assessment criteria
Based on course assignment
Assessment scale
1-5
Failed (0)
Unable to form basic queries or understand how queries are used in software
Assessment criteria: level 1 (assessment scale 1–5)
Has rudimentary understanding of queries.
Assessment criteria: level 3 (assessment scale 1–5)
Can design databases in a normalized manner
Assessment criteria: level 5 (assessment scale 1–5)
Can form complex queries.