SQL and NoSQL Databases (5 cr)

Code: R504D76-3001

General information

Enrollment: 13.03.2023 - 31.07.2023
Registration for the implementation has ended.

Timing: 11.09.2023 - 24.11.2023
Implementation has ended.

Number of ECTS credits allocated: 5 cr

Local portion: 5 cr

Mode of delivery: Contact learning

Unit: Bachelor of Engineering, Information Technology

Teaching languages: English

Seats: 0 - 30

Teachers: Juhani Kuru

Teacher in charge: Juhani Kuru

Groups: R54D21S
Bachelor of Engineering, Machine Learning and Data Engineering (full time studies), 2021

Course: R504D76

Evaluation scale

H-5

Objective

The student can utilize SQL commands. The student is familiar with non-relational Databases and knows dimensional design principles. The student can utilize NoSQL in practical application development.

Content

- SQL
- NoSQL
- Dimensional design
- Data Vault

Location and time

all lectures can be found in the timetable

Materials

All material needed will be published in Moodle

Teaching methods

- classroom lectures
- material produced during lectures
- self-study

Completion alternatives

- using databases in appklications
- Designing and implementing databases
- Relational databases
- NoSQL databases

Assessment criteria, satisfactory (1)

The student can design and process the simple relational database. The student outlines the difference between the structure and principles of SQL and NoSQL database. The student knows the principles for utilizing NoSQL. Student knows the basic concepts of the dimensional design.

Assessment criteria, good (3)

The student can design and process the relational database. Student knows the concept of NoSQL data modelling and apply the designing skills for information management in a simple application.

Assessment criteria, excellent (5)

The student can design and process the wider relational database. Student is capable to design non-relational database and utilize NoSQL fluent for data management in an application.