Siirry suoraan sisältöön

Tietokannat 2 (3 cr)

Code: HTKA0110-3002

General information


Enrollment

01.11.2022 - 05.01.2023

Timing

13.03.2023 - 19.05.2023

Number of ECTS credits allocated

3 op

Mode of delivery

Face-to-face

Unit

Liiketoimintayksikkö

Campus

Pääkampus

Teaching languages

  • Finnish

Seats

0 - 30

Degree programmes

  • Tietojenkäsittely (AMK)

Teachers

  • Jarkko Immonen

Groups

  • HTK21S1
    Tietojenkäsittely (AMK)
  • ZJA23KI
    Avoin AMK, tiko
  • ZJK23KI
    Korkeakoulujen välinen yhteistyö, TIKO
  • HTK19S1
    Tietojenkäsittely
  • HTK20S1
    Tietojenkäsittely
  • 31.03.2023 08:30 - 12:30, Tietokannat 2 HTKA0110-3002
  • 14.04.2023 08:30 - 12:30, Tietokannat 2 HTKA0110-3002
  • 21.04.2023 08:30 - 12:30, Tietokannat 2 HTKA0110-3002
  • 28.04.2023 08:30 - 12:30, Tietokannat 2 HTKA0110-3002
  • 05.05.2023 08:30 - 12:30, Tietokannat 2 HTKA0110-3002
  • 12.05.2023 08:30 - 12:30, Tietokannat 2 HTKA0110-3002

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

Oppimateriaali ja suositeltava kirjallisuus

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

Teaching methods

- Contact lessons
- Exercises
- Learning assignments
- Final exam

Exam schedules

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.

Vaihtoehtoiset suoritustavat

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

Avoin amk 3
EduFutura 5

Evaluation scale

0-5

Arviointikriteerit, tyydyttävä (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.

Arviointikriteerit, hyvä (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.

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.

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.