Databases (5 cr)
Code: TT00CE04-3005
General information
Enrollment
27.09.2024 - 13.01.2025
Timing
01.01.2025 - 30.05.2025
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Teaching languages
- Finnish
Teachers
- Päivi Oliva
- Paula Steinby
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