DatabasesLaajuus (5 cr)
Code: TT00CE04
Credits
5 op
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
Enrollment
28.09.2023 - 14.01.2024
Timing
01.01.2024 - 31.07.2024
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Teaching languages
- Finnish
Teachers
- Jaakko Lamminpää
- Päivi Oliva
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
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
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