Advanced DatabasesLaajuus (5 cr)
Code: DT10035
Credits
5 op
Teaching language
- Finnish
Responsible person
- Joni Ranta
- Antti Hurme
Objective
-you are able to optimize the performance of a relational database according to different uses.
-you are able to select and implement a database according to the need to use the correct database model (relational model, object model, NoSQL).
-you understand the basic principles of data analytics.
-you understand different database virtualization solutions.
-you understand the concept of data warehouse.
-you can implement subroutines, functions, triggers, scheduled tasks, backup in a relational database.
-you understand the importance of data security in a database solution.
Content
-indexing the relational database at a more detailed level.
-relational databases: subroutines, functions, triggers, scheduled tasks.
-some examples of database virtualization solutions.
-data analytics examples.
-data security in practice in relational databases.
Enrollment
01.10.2024 - 31.10.2024
Timing
10.03.2025 - 30.05.2025
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Campus
Wärtsilä Campus Karjalankatu 3
Teaching languages
- Finnish
Seats
10 - 80
Degree programmes
- Degree Programme in Business Information Technology
Teachers
- Jyri Kemppainen
- Joni Ranta
- Antti Hurme
Teacher in charge
Joni Ranta
Groups
-
DTNS23Information Technology (BBA), Full-time Studies, Fall, 2023
Objective
-you are able to optimize the performance of a relational database according to different uses.
-you are able to select and implement a database according to the need to use the correct database model (relational model, object model, NoSQL).
-you understand the basic principles of data analytics.
-you understand different database virtualization solutions.
-you understand the concept of data warehouse.
-you can implement subroutines, functions, triggers, scheduled tasks, backup in a relational database.
-you understand the importance of data security in a database solution.
Content
-indexing the relational database at a more detailed level.
-relational databases: subroutines, functions, triggers, scheduled tasks.
-some examples of database virtualization solutions.
-data analytics examples.
-data security in practice in relational databases.
Evaluation scale
H-5
Enrollment
01.10.2023 - 31.10.2023
Timing
11.03.2024 - 26.05.2024
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Campus
Wärtsilä Campus Karjalankatu 3
Teaching languages
- Finnish
Seats
5 - 50
Degree programmes
- Degree Programme in Business Information Technology
Teachers
- Joni Ranta
- Jyri Kemppainen
Teacher in charge
Jyri Kemppainen
Groups
-
DTNS22Information Technology (BBA), Full-time Studies, Fall, 2022
Objective
-you are able to optimize the performance of a relational database according to different uses.
-you are able to select and implement a database according to the need to use the correct database model (relational model, object model, NoSQL).
-you understand the basic principles of data analytics.
-you understand different database virtualization solutions.
-you understand the concept of data warehouse.
-you can implement subroutines, functions, triggers, scheduled tasks, backup in a relational database.
-you understand the importance of data security in a database solution.
Content
-indexing the relational database at a more detailed level.
-relational databases: subroutines, functions, triggers, scheduled tasks.
-some examples of database virtualization solutions.
-data analytics examples.
-data security in practice in relational databases.
Evaluation scale
H-5