Skip to main content

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.