Databases (5 cr)
Code: TT00CE04-3004
General information
Enrollment
27.04.2024 - 13.08.2024
Timing
01.08.2024 - 31.12.2024
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