Curricula

Objective

Purpose of the course

Basic knowledge of databases is often enough to go a long way, but more extensive and in-depth knowledge of databases gives you the opportunity to implement effective and appropriate databases. In this course, you deepen your previous knowledge of relational databases and get to know NoSQL database technologies.

Course competences

- Information System Competence: Is familiar with typical information systems and services and understands the importance of security in utilizing services.
- Application Development Competence: Knows the technologies used in application development and recognizes the significance of different technologies and their relationships.
- Application Development Competence: Is able to program and develop secure applications.
- Operating in a workplace: Utilises the opportunities offered by technology and digitalisation in their work.

The learning objectives of the course

After the course, you will be able to use the SQL language versatilely and understand performance-related features. You understand transactions. You are familiar with various NoSQL database technologies and know their basic usage.

Content

The course covers both relational databases and NoSQL databases from the following perspectives:

- Database management
- Relational databases: advanced use of SQL
- Database programming
- Transactions
- Indexing
- NoSQL databases
- Basic usage of NoSQL databases covered
- Advanced features of NoSQL databases covered

Qualifications

To participate in the course, you must have basic knowledge of relational databases, SQL language and container technology.

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.