Advanced Databases (5 cr)
Code: DT10035-3002
General information
- Enrollment
- 01.10.2024 - 31.10.2024
- Registration for the implementation has ended.
- Timing
- 10.03.2025 - 30.05.2025
- Implementation has ended.
- Number of ECTS credits allocated
- 5 cr
- Local portion
- 5 cr
- Mode of delivery
- Contact learning
- Unit
- Tradenomi / Tietojenkäsittely (DD)
- 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
- Course
- DT10035
Evaluation scale
H-5
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.