Databases (5 cr)
Code: TT00CE04-3001
General information
Enrollment
01.12.2021 - 20.01.2022
Timing
10.01.2022 - 29.05.2022
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Teaching languages
- Finnish
Seats
0 - 25
Teachers
- Matti Kuikka
Objective
After completing the course the student can:
- understand different types of databases and evaluate their feasibility for different purposes.
- plan and implement a database based on requirements and search and modify data in the database
- use at least one well-known database management system and describe database management tasks
Content
- Relational database installation
- Basic SQL queries and functions, DDL statements, data changes
- More challenging SQL queries
- Relational database design: conceptual modelling (ER), conversion to relational tables, normalization rules and method
- Use of NoSQL document database, data addition and basic queries, document design principles, external connection to the database
Evaluation scale
H-5