Databases 2Laajuus (3 cr)
Course unit code: HTKA0110
General information
- Credits
- 3 cr
- Teaching language
- Finnish
- Responsible person
- Jarkko Immonen
Objective
Basic skills regarding to databases are often sufficient, but more extensive and in-depth skills allow you to implement more efficient databases. Do you want to know how application logic can be transferred to a database management system or how database searches can be optimized? In this course you will deepen your previous knowledge of relational and NoSQL databases and get acquainted with new database technologies.
Course competences
Systems and methods in ICT
Web development competence
Learning and information management competence
After the course, you will be able to extensively use SQL and write stored routines in a relational database management server. You will understand performance-related features (such as indexing) and be able to evaluate and refactor slow queries. You are familiar with transactions. You know various NoSQL database technologies. You will be able to combine your database expertise with web application development expertise.
Content
- Database management
- Relational databases: advanced use of SQL
- Database programming (eg triggers, functions, procedures and cursors)
- Transactions
- Indexing
- NoSQL: key-value databases, graph databases
- Using databases in web application development
Qualifications
To participate in the course, you must have a basic understanding of relational databases, SQL language and Docker environment. In addition, an understanding of MongoDB databases and Javascript programming is necessary.
Assessment criteria, satisfactory (1)
Sufficient 1: You are familiar with the concepts and can use some features provided by relational and NoSQL technologies. You are familiar with the more advanced features of SQL. You know the principles and basic functionalities of the new database technologies covered in the course.
Satisfactory 2: You are familiar with the concepts and can take advantage of the features offered by relational and NoSQL technologies. You are familiar with and able to use the more advanced features of SQL. You know the principles and basic functionalities of the new database technologies covered in the course.
Assessment criteria, good (3)
Good 3: You are familiar with the concepts and can take advantage of the features offered by the relational and NoSQL technologies. You are familiar with the more advanced features of SQL and can take advantage of them. You understand the principles and basic functionalities of the new database technologies covered in the course and will be able to use them.
Very good 4: You understand the concepts and know how to take advantage of the features offered by relational and NoSQL technologies. You master SQL and are able to build queries and routines fluently. You understand the principles and basic functionalities of the new database technologies covered in the course, and you are able to design and implement solutions suitable for practical problems using those tools.
Assessment criteria, excellent (5)
Excellent 5: You master the concepts and can make extensive use of the features offered by relational and NoSQL technologies. You master SQL and are able to build demanding queries and routines. You understand the principles and basic functionalities of the new database technologies covered in the course, and you will be able to design and implement solutions suitable for practical problems using those tools. You can independently expand and apply your knowledge and skills.