Information Management and Databases (5 cr)
Code: R0279-3002
General information
Enrollment
23.11.2020 - 29.11.2020
Timing
06.01.2021 - 20.03.2021
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 - 35
Degree programmes
- Degree Programme in Business Information Technology (NIA), Laurea Leppävaara
Teachers
- Jukka Malinen
Teacher in charge
Jukka Malinen
Groups
-
NIA220SADegree Programme in Business Information Technology, virtual studies, S20, 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
Contact sessions (2,5 hours / session) are based on guided workshops with the following format:
- Teacher's lecture to present the session's topics (30 mins)
- Hands-on exercises (2 hours)
Learning materials and recommended literature
- Theory lectures
- Self study
- Guided workshops
- 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.
Contact sessions are mostly practice-based workshops guided by the teachers.
Grading scale
H-5
Evaluation methods and criteria
- Exam
- Database project (in pairs)