Curricula

Objectives

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

Learning materials and recommended literature

Course material written by the teacher as well as selected online resources.

Teaching methods

- Contact lessons
- Exercises
- Learning assignments
- Final exam

Exam dates and retake possibilities

The final exam will be held at the end of the course in class or virtually. The dates of the exams will be announced during the course.

Alternative completion methods

You have the right to apply for recognition of your studies if you have prior learning (e.g. university studies completed elsewhere) that can be accredited towards the degree you are currently completing.

The recognition of prior learning is possible in three primary ways: accreditation (replacement or inclusion), recognition of informal learning and studification. More precise info: JAMK Degree Regulations, section 17.

Student workload

Approximately 81 hours.

Further information for students

Avoin amk 3
EduFutura 5

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

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.

Evaluation criteria, good (3-4)

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.

Evaluation 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.

Prerequisites

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.

Objectives

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

Learning materials and recommended literature

Course material written by the teacher as well as selected online resources.

Teaching methods

- Contact lessons
- Exercises
- Learning assignments
- Final exam

Exam dates and retake possibilities

The final exam will be held at the end of the course in class or virtually. The dates of the exams will be announced during the course.

Alternative completion methods

You have the right to apply for recognition of your studies if you have prior learning (e.g. university studies completed elsewhere) that can be accredited towards the degree you are currently completing.

The recognition of prior learning is possible in three primary ways: accreditation (replacement or inclusion), recognition of informal learning and studification. More precise info: JAMK Degree Regulations, section 17.

Student workload

Approximately 81 hours.

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

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.

Evaluation criteria, good (3-4)

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.

Evaluation 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.

Prerequisites

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.