Databases 2Laajuus (3 cr)
Code: HTO10401
Credits
3 op
Teaching language
- Finnish
Responsible person
- Jarkko Immonen
Objective
The students can design and implement efficient relational database solutions. They understand the concepts and features of the NoSQL databases studied during the course and know how to use them in the software development projects.
Content
Relational databases
o Andvanced SQL
o Transactions
o Triggers, functions and procedures
o Indexing
NoSQL databases
o MongoDB
o Redis
o Neo4j
Qualifications
Computing, databases, programming
Assessment criteria, satisfactory (1)
Satisfactory (1-2): The students know the basic concepts and they can apply their knowledge in practical problems. They can use some of the features offered by the database management system. They kwow the SQL language and they are able to use it to make queries and routines. The students know the basic concepts and features of certain NoSQL databases and can utilize that knowledge somehow.
Assessment criteria, good (3)
Good (3-4): The students know the concepts and they can apply their knowledge in practical problems. They can use the features offered by the database management system. They master the SQL language and they can use it in a versatile way to make queries and routines. The students know the concepts and features of certain NoSQL databases and can utilize that knowledge.
Assessment criteria, excellent (5)
Excellent (5): The students understand the concepts and they can apply their knowledge in practical problems. They can utilize widely the features offered by the database management system. The students master the SQL language and they can build advanced queries and routines. The students understand the concepts and features of certain NoSQL databases and can utilize that knowledge well.