Databases (5 cr)
Code: TT00CE04-3002
General information
Enrollment
28.04.2023 - 14.08.2023
Timing
01.08.2023 - 31.12.2023
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Teaching languages
- Finnish
Teachers
- Päivi Oliva
- Jaakko Lamminpää
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